Debian Codegraph @

src/interfaces/ecpg/preproc/t/err_warn_msg.pgc

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