summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/expected/sql-dyntest.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-dyntest.c')
-rw-r--r--src/interfaces/ecpg/test/expected/sql-dyntest.c77
1 files changed, 42 insertions, 35 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-dyntest.c b/src/interfaces/ecpg/test/expected/sql-dyntest.c
index 4fd5260803..167b6aeb68 100644
--- a/src/interfaces/ecpg/test/expected/sql-dyntest.c
+++ b/src/interfaces/ecpg/test/expected/sql-dyntest.c
@@ -225,42 +225,49 @@ if (sqlca.sqlcode < 0) error ( );}
#line 47 "dyntest.pgc"
+ { ECPGdo(__LINE__, 0, 1, NULL, "set datestyle to german", ECPGt_EOIT, ECPGt_EORT);
+#line 49 "dyntest.pgc"
+
+if (sqlca.sqlcode < 0) error ( );}
+#line 49 "dyntest.pgc"
+
+
{ ECPGdo(__LINE__, 0, 1, NULL, "create table dyntest ( name char ( 14 ) , d float8 , i int , bignumber int8 , b boolean , comment text , day date ) ", ECPGt_EOIT, ECPGt_EORT);
-#line 51 "dyntest.pgc"
+#line 53 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 51 "dyntest.pgc"
+#line 53 "dyntest.pgc"
{ ECPGdo(__LINE__, 0, 1, NULL, "insert into dyntest values( 'first entry' , 14.7 , 14 , 123045607890 , true , 'The world''s most advanced open source database.' , '1987-07-14' )", ECPGt_EOIT, ECPGt_EORT);
-#line 52 "dyntest.pgc"
+#line 54 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 52 "dyntest.pgc"
+#line 54 "dyntest.pgc"
{ ECPGdo(__LINE__, 0, 1, NULL, "insert into dyntest values( 'second entry' , 1407.87 , 1407 , 987065403210 , false , 'The elephant never forgets.' , '1999-11-5' )", ECPGt_EOIT, ECPGt_EORT);
-#line 53 "dyntest.pgc"
+#line 55 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 53 "dyntest.pgc"
+#line 55 "dyntest.pgc"
{ ECPGprepare(__LINE__, "MYQUERY" , QUERY);
-#line 55 "dyntest.pgc"
+#line 57 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 55 "dyntest.pgc"
+#line 57 "dyntest.pgc"
/* declare MYCURS cursor for ? */
-#line 56 "dyntest.pgc"
+#line 58 "dyntest.pgc"
{ ECPGdo(__LINE__, 0, 1, NULL, "declare MYCURS cursor for ?",
ECPGt_char_variable,(ECPGprepared_statement("MYQUERY")),(long)1,(long)1,(1)*sizeof(char),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
-#line 58 "dyntest.pgc"
+#line 60 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 58 "dyntest.pgc"
+#line 60 "dyntest.pgc"
while (1)
@@ -268,10 +275,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGdo(__LINE__, 0, 1, NULL, "fetch in MYCURS", ECPGt_EOIT,
ECPGt_descriptor, "MYDESC", 0L, 0L, 0L,
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
-#line 62 "dyntest.pgc"
+#line 64 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 62 "dyntest.pgc"
+#line 64 "dyntest.pgc"
if (sqlca.sqlcode)
@@ -279,10 +286,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc_header(__LINE__, "MYDESC", &(COUNT));
-#line 67 "dyntest.pgc"
+#line 69 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 67 "dyntest.pgc"
+#line 69 "dyntest.pgc"
if (!done)
{
@@ -302,10 +309,10 @@ if (sqlca.sqlcode < 0) error ( );}
ECPGt_int,&(LENGTH),(long)1,(long)1,sizeof(int), ECPGd_type,
ECPGt_int,&(TYPE),(long)1,(long)1,sizeof(int), ECPGd_EODT);
-#line 84 "dyntest.pgc"
+#line 86 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 84 "dyntest.pgc"
+#line 86 "dyntest.pgc"
printf ("%2d\t%s (type: %d length: %d precision: %d scale: %d = " , INDEX, NAME, TYPE, LENGTH, PRECISION, SCALE);
switch (TYPE)
@@ -338,10 +345,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_di_code,
ECPGt_int,&(DATETIME_INTERVAL_CODE),(long)1,(long)1,sizeof(int), ECPGd_EODT);
-#line 114 "dyntest.pgc"
+#line 116 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 114 "dyntest.pgc"
+#line 116 "dyntest.pgc"
switch (DATETIME_INTERVAL_CODE)
{
@@ -395,10 +402,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_data,
ECPGt_bool,&(BOOLVAR),(long)1,(long)1,sizeof(bool), ECPGd_EODT);
-#line 164 "dyntest.pgc"
+#line 166 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 164 "dyntest.pgc"
+#line 166 "dyntest.pgc"
printf ("%s\n", BOOLVAR ? "true" : "false");
break;
@@ -407,10 +414,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_data,
ECPGt_int,&(INTVAR),(long)1,(long)1,sizeof(int), ECPGd_EODT);
-#line 169 "dyntest.pgc"
+#line 171 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 169 "dyntest.pgc"
+#line 171 "dyntest.pgc"
printf ("%d\n", INTVAR);
break;
@@ -418,10 +425,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_data,
ECPGt_double,&(DOUBLEVAR),(long)1,(long)1,sizeof(double), ECPGd_EODT);
-#line 173 "dyntest.pgc"
+#line 175 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 173 "dyntest.pgc"
+#line 175 "dyntest.pgc"
printf ("%.*f\n", PRECISION, DOUBLEVAR);
break;
@@ -430,10 +437,10 @@ if (sqlca.sqlcode < 0) error ( );}
ECPGt_char,(STRINGVAR),(long)1024,(long)1,(1024)*sizeof(char), ECPGd_di_code,
ECPGt_int,&(DATETIME_INTERVAL_CODE),(long)1,(long)1,sizeof(int), ECPGd_EODT);
-#line 179 "dyntest.pgc"
+#line 181 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 179 "dyntest.pgc"
+#line 181 "dyntest.pgc"
printf ("%d \"%s\"\n", DATETIME_INTERVAL_CODE, STRINGVAR);
break;
@@ -442,10 +449,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_data,
ECPGt_char,(STRINGVAR),(long)1024,(long)1,(1024)*sizeof(char), ECPGd_EODT);
-#line 184 "dyntest.pgc"
+#line 186 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 184 "dyntest.pgc"
+#line 186 "dyntest.pgc"
printf ("\"%s\"\n", STRINGVAR);
break;
@@ -453,10 +460,10 @@ if (sqlca.sqlcode < 0) error ( );}
{ ECPGget_desc(__LINE__, "MYDESC", INDEX,ECPGd_data,
ECPGt_char,(STRINGVAR),(long)1024,(long)1,(1024)*sizeof(char), ECPGd_EODT);
-#line 188 "dyntest.pgc"
+#line 190 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 188 "dyntest.pgc"
+#line 190 "dyntest.pgc"
printf ("<\"%s\">\n", STRINGVAR);
break;
@@ -465,17 +472,17 @@ if (sqlca.sqlcode < 0) error ( );}
}
{ ECPGdo(__LINE__, 0, 1, NULL, "close MYCURS", ECPGt_EOIT, ECPGt_EORT);
-#line 195 "dyntest.pgc"
+#line 197 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );}
-#line 195 "dyntest.pgc"
+#line 197 "dyntest.pgc"
ECPGdeallocate_desc(__LINE__, "MYDESC");
-#line 197 "dyntest.pgc"
+#line 199 "dyntest.pgc"
if (sqlca.sqlcode < 0) error ( );
-#line 197 "dyntest.pgc"
+#line 199 "dyntest.pgc"
return 0;
View Lorry Controller Status