5 EXEC SQL INCLUDE ../regression;
7 int main(int argc, char* argv[]) {
8 EXEC SQL BEGIN DECLARE SECTION;
11 EXEC SQL END DECLARE SECTION;
14 EXEC SQL CONNECT TO REGRESSDB1;
16 EXEC SQL SET AUTOCOMMIT TO ON;
17 EXEC SQL WHENEVER SQLWARNING SQLPRINT;
18 EXEC SQL WHENEVER SQLERROR SQLPRINT;
20 EXEC SQL CREATE TABLE "My_Table" ( Item1 int, Item2 text );
22 EXEC SQL SHOW standard_conforming_strings INTO :var;
23 printf("Standard conforming strings: %s\n", var);
25 /* this is a\\b actually */
26 EXEC SQL INSERT INTO "My_Table" VALUES ( 1, 'a\\\\b' );
28 EXEC SQL INSERT INTO "My_Table" VALUES ( 1, E'a\\\\b' );
30 EXEC SQL SET standard_conforming_strings TO on;
32 /* this is a\\\\b actually */
33 EXEC SQL INSERT INTO "My_Table" VALUES ( 2, 'a\\\\b' );
35 EXEC SQL INSERT INTO "My_Table" VALUES ( 2, E'a\\\\b' );
38 EXEC SQL DECLARE C CURSOR FOR SELECT * FROM "My_Table";
42 EXEC SQL WHENEVER NOT FOUND DO BREAK;
46 EXEC SQL FETCH C INTO :i, :var;
47 printf("value: %d %s\n", i, var);
51 EXEC SQL DROP TABLE "My_Table";
53 EXEC SQL DISCONNECT ALL;