Age Owner TLA Line data Source code
1 : #include <stdio.h>
2 : #include <stdlib.h>
3 : #include <string.h>
4 :
5 : EXEC SQL INCLUDE ../regression;
6 :
5072 meskes 7 CBC 1 : int main() {
8 : EXEC SQL BEGIN DECLARE SECTION;
9 : char var[25];
10 : int i, loopcount;
11 : EXEC SQL END DECLARE SECTION;
12 :
6094 13 1 : ECPGdebug(1, stderr);
14 1 : EXEC SQL CONNECT TO REGRESSDB1;
15 :
16 1 : EXEC SQL SET AUTOCOMMIT TO ON;
17 : EXEC SQL WHENEVER SQLWARNING SQLPRINT;
18 : EXEC SQL WHENEVER SQLERROR STOP;
19 :
6057 20 1 : EXEC SQL CREATE TABLE "My_Table" ( Item1 int, Item2 text );
6094 21 1 :
4646 rhaas 22 1 : EXEC SQL SET standard_conforming_strings TO off;
23 1 :
6094 meskes 24 1 : EXEC SQL SHOW standard_conforming_strings INTO :var;
25 1 : printf("Standard conforming strings: %s\n", var);
26 :
27 : /* this is a\\b actually */
6057 28 1 : EXEC SQL INSERT INTO "My_Table" VALUES ( 1, 'a\\\\b' );
5717 29 1 : /* this is a\\b */
6057 30 1 : EXEC SQL INSERT INTO "My_Table" VALUES ( 1, E'a\\\\b' );
6094 31 1 :
32 1 : EXEC SQL SET standard_conforming_strings TO on;
33 1 :
4646 rhaas 34 1 : EXEC SQL SHOW standard_conforming_strings INTO :var;
35 1 : printf("Standard conforming strings: %s\n", var);
36 :
37 : /* this is a\\\\b actually */
5717 meskes 38 1 : EXEC SQL INSERT INTO "My_Table" VALUES ( 2, 'a\\\\b' );
39 1 : /* this is a\\b */
40 1 : EXEC SQL INSERT INTO "My_Table" VALUES ( 2, E'a\\\\b' );
41 1 :
42 1 : EXEC SQL BEGIN;
43 1 : EXEC SQL DECLARE C CURSOR FOR SELECT * FROM "My_Table";
44 :
45 1 : EXEC SQL OPEN C;
46 1 :
47 : EXEC SQL WHENEVER NOT FOUND DO BREAK;
48 :
1536 tgl 49 5 : for (loopcount = 0; loopcount < 100; loopcount++)
50 : {
3437 peter_e 51 5 : EXEC SQL FETCH C INTO :i, :var;
5717 meskes 52 5 : printf("value: %d %s\n", i, var);
53 : }
54 :
55 1 : EXEC SQL ROLLBACK;
6057 56 1 : EXEC SQL DROP TABLE "My_Table";
6094 57 1 :
58 1 : EXEC SQL DISCONNECT ALL;
59 1 :
60 1 : return 0;
61 : }
|
