Debian Codegraph @

src/interfaces/ecpg/test/preproc/whenever.pgc

raw
1 #include <stdlib.h>
2
3 exec sql include ../regression;
4
5 exec sql whenever sqlerror sqlprint;
6
7 static void print(const char *msg)
8 {
9 fprintf(stderr, "Error in statement '%s':\n", msg);
10 sqlprint();
11 }
12
13 static void print2(void)
14 {
15 fprintf(stderr, "Found another error\n");
16 sqlprint();
17 }
18
19 static void warn(void)
20 {
21 fprintf(stderr, "Warning: At least one column was truncated\n");
22 }
23
24 int main(void)
25 {
26 exec sql int i;
27 exec sql char c[6];
28
29 ECPGdebug(1, stderr);
30
31 exec sql connect to REGRESSDB1;
32 exec sql create table test(i int, c char(10));
33 exec sql insert into test values(1, 'abcdefghij');
34
35 exec sql whenever sqlwarning do warn();
36 exec sql select * into :i, :c from test;
37 exec sql rollback;
38
39 exec sql select * into :i from nonexistent;
40 exec sql rollback;
41
42 exec sql whenever sqlerror do print("select");
43 exec sql select * into :i from nonexistent;
44 exec sql rollback;
45
46 exec sql whenever sqlerror call print2();
47 exec sql select * into :i from nonexistent;
48 exec sql rollback;
49
50 exec sql whenever sqlerror continue;
51 exec sql select * into :i from nonexistent;
52 exec sql rollback;
53
54 exec sql whenever sqlerror goto error;
55 exec sql select * into :i from nonexistent;
56 printf("Should not be reachable\n");
57
58 error:
59 exec sql rollback;
60
61 exec sql whenever sqlerror stop;
62 /* This cannot fail, thus we don't get an exit value not equal 0. */
63 /* However, it still test the precompiler output. */
64 exec sql select 1 into :i;
65 exec sql rollback;
66 exit (0);
67 }