blob: 5ab0a761866351ef0bad5d8c60e2c77b48c7f20a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
/* Test ECPG warning/error messages */
#include <stdlib.h>
int
main(void)
{
EXEC SQL BEGIN DECLARE SECTION;
char *cursor_var = "mycursor";
short a;
EXEC SQL END DECLARE SECTION;
/* For consistency with other tests */
EXEC SQL CONNECT TO testdb AS con1;
/* Test AT option errors */
EXEC SQL AT con1 CONNECT TO testdb2;
EXEC SQL AT con1 DISCONNECT;
EXEC SQL AT con1 SET CONNECTION TO testdb2;
EXEC SQL AT con1 TYPE string IS char[11];
EXEC SQL AT con1 WHENEVER NOT FOUND CONTINUE;
EXEC SQL AT con1 VAR a IS int;
/* Test COPY FROM STDIN warning */
EXEC SQL COPY test FROM stdin;
/* Test same variable in multi declare statement */
EXEC SQL DECLARE :cursor_var CURSOR FOR SELECT * FROM test;
EXEC SQL DECLARE :cursor_var CURSOR FOR SELECT * FROM test;
/* Test duplicate cursor declarations */
EXEC SQL DECLARE duplicate_cursor CURSOR FOR SELECT * FROM test;
EXEC SQL DECLARE duplicate_cursor CURSOR FOR SELECT * FROM test;
/* Test SHOW ALL error */
EXEC SQL SHOW ALL;
/* Test deprecated LIMIT syntax warning */
EXEC SQL SELECT * FROM test LIMIT 10, 5;
return 0;
}
|
