aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/expected/compat_informix-test_informix.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/interfaces/ecpg/test/expected/compat_informix-test_informix.c')
-rw-r--r--src/interfaces/ecpg/test/expected/compat_informix-test_informix.c106
1 files changed, 57 insertions, 49 deletions
diff --git a/src/interfaces/ecpg/test/expected/compat_informix-test_informix.c b/src/interfaces/ecpg/test/expected/compat_informix-test_informix.c
index d139a1f422e..efdbd49d9bb 100644
--- a/src/interfaces/ecpg/test/expected/compat_informix-test_informix.c
+++ b/src/interfaces/ecpg/test/expected/compat_informix-test_informix.c
@@ -43,106 +43,112 @@ int main(void)
#line 15 "test_informix.pgc"
+
+#line 16 "test_informix.pgc"
+ char c [ 10 ] ;
+
+#line 16 "test_informix.pgc"
+
ECPGdebug(1, stderr);
/* exec sql whenever sqlerror do dosqlprint ( ) ; */
-#line 18 "test_informix.pgc"
+#line 19 "test_informix.pgc"
{ ECPGconnect(__LINE__, 1, "regress1" , NULL, NULL , NULL, 0);
-#line 20 "test_informix.pgc"
+#line 21 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 20 "test_informix.pgc"
+#line 21 "test_informix.pgc"
if (sqlca.sqlcode != 0) exit(1);
- { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "create table test ( i int primary key , j int )", ECPGt_EOIT, ECPGt_EORT);
-#line 23 "test_informix.pgc"
+ { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "create table test ( i int primary key , j int , c text )", ECPGt_EOIT, ECPGt_EORT);
+#line 24 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 23 "test_informix.pgc"
+#line 24 "test_informix.pgc"
/* this INSERT works */
rsetnull(CDECIMALTYPE, (char *)&j);
- { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j ) values ( 7 , $1 )",
+ { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j , c ) values ( 7 , $1 , 'test ' )",
ECPGt_decimal,&(j),(long)1,(long)1,sizeof(decimal),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
-#line 27 "test_informix.pgc"
+#line 28 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 27 "test_informix.pgc"
+#line 28 "test_informix.pgc"
{ ECPGtrans(__LINE__, NULL, "commit");
-#line 28 "test_informix.pgc"
+#line 29 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 28 "test_informix.pgc"
+#line 29 "test_informix.pgc"
/* this INSERT should fail because i is a unique column */
- { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j ) values ( 7 , 12 )", ECPGt_EOIT, ECPGt_EORT);
-#line 31 "test_informix.pgc"
+ { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j , c ) values ( 7 , 12 , 'a' )", ECPGt_EOIT, ECPGt_EORT);
+#line 32 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 31 "test_informix.pgc"
+#line 32 "test_informix.pgc"
printf("INSERT: %ld=%s\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc);
if (sqlca.sqlcode != 0) { ECPGtrans(__LINE__, NULL, "rollback");
-#line 33 "test_informix.pgc"
+#line 34 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 33 "test_informix.pgc"
+#line 34 "test_informix.pgc"
- { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j ) values ( $1 , 1 )",
+ { ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "insert into test ( i , j , c ) values ( $1 , 1 , 'a ' )",
ECPGt_int,&(i),(long)1,(long)1,sizeof(int),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
-#line 35 "test_informix.pgc"
+#line 36 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 35 "test_informix.pgc"
+#line 36 "test_informix.pgc"
{ ECPGtrans(__LINE__, NULL, "commit");
-#line 36 "test_informix.pgc"
+#line 37 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 36 "test_informix.pgc"
+#line 37 "test_informix.pgc"
/* this will fail (more than one row in subquery) */
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "select i from test where j = ( select j from test )", ECPGt_EOIT, ECPGt_EORT);
-#line 39 "test_informix.pgc"
+#line 40 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 39 "test_informix.pgc"
+#line 40 "test_informix.pgc"
{ ECPGtrans(__LINE__, NULL, "rollback");
-#line 40 "test_informix.pgc"
+#line 41 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 40 "test_informix.pgc"
+#line 41 "test_informix.pgc"
/* this however should be ok */
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "select i from test where j = ( select j from test order by i limit 1 )", ECPGt_EOIT, ECPGt_EORT);
-#line 43 "test_informix.pgc"
+#line 44 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 43 "test_informix.pgc"
+#line 44 "test_informix.pgc"
printf("SELECT: %ld=%s\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc);
if (sqlca.sqlcode != 0) { ECPGtrans(__LINE__, NULL, "rollback");
-#line 45 "test_informix.pgc"
+#line 46 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 45 "test_informix.pgc"
+#line 46 "test_informix.pgc"
ECPG_informix_set_var( 0, &( i ), __LINE__);\
/* declare c cursor for select * from test where i <= $1 */
-#line 47 "test_informix.pgc"
+#line 48 "test_informix.pgc"
openit();
@@ -154,11 +160,13 @@ if (sqlca.sqlcode < 0) dosqlprint ( );}
ECPGt_int,&(i),(long)1,(long)1,sizeof(int),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
ECPGt_decimal,&(j),(long)1,(long)1,sizeof(decimal),
+ ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
+ ECPGt_string,(c),(long)10,(long)1,(10)*sizeof(char),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
-#line 54 "test_informix.pgc"
+#line 55 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 54 "test_informix.pgc"
+#line 55 "test_informix.pgc"
if (sqlca.sqlcode == 100) break;
else if (sqlca.sqlcode != 0) printf ("Error: %ld\n", sqlca.sqlcode);
@@ -170,7 +178,7 @@ if (sqlca.sqlcode < 0) dosqlprint ( );}
int a;
dectoint(&j, &a);
- printf("%d %d\n", i, a);
+ printf("%d %d \"%s\"\n", i, a, c);
}
}
@@ -180,53 +188,53 @@ if (sqlca.sqlcode < 0) dosqlprint ( );}
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "delete from test where i = $1 :: decimal",
ECPGt_decimal,&(n),(long)1,(long)1,sizeof(decimal),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
-#line 72 "test_informix.pgc"
+#line 73 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 72 "test_informix.pgc"
+#line 73 "test_informix.pgc"
printf("DELETE: %ld\n", sqlca.sqlcode);
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "select 1 from test where i = 14", ECPGt_EOIT, ECPGt_EORT);
-#line 75 "test_informix.pgc"
+#line 76 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 75 "test_informix.pgc"
+#line 76 "test_informix.pgc"
printf("Exists: %ld\n", sqlca.sqlcode);
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "select 1 from test where i = 147", ECPGt_EOIT, ECPGt_EORT);
-#line 78 "test_informix.pgc"
+#line 79 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 78 "test_informix.pgc"
+#line 79 "test_informix.pgc"
printf("Does not exist: %ld\n", sqlca.sqlcode);
{ ECPGtrans(__LINE__, NULL, "commit");
-#line 81 "test_informix.pgc"
+#line 82 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 81 "test_informix.pgc"
+#line 82 "test_informix.pgc"
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "drop table test", ECPGt_EOIT, ECPGt_EORT);
-#line 82 "test_informix.pgc"
+#line 83 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 82 "test_informix.pgc"
+#line 83 "test_informix.pgc"
{ ECPGtrans(__LINE__, NULL, "commit");
-#line 83 "test_informix.pgc"
+#line 84 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 83 "test_informix.pgc"
+#line 84 "test_informix.pgc"
{ ECPGdisconnect(__LINE__, "CURRENT");
-#line 85 "test_informix.pgc"
+#line 86 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 85 "test_informix.pgc"
+#line 86 "test_informix.pgc"
return 0;
@@ -237,10 +245,10 @@ static void openit(void)
{ ECPGdo(__LINE__, 1, 1, NULL, 0, ECPGst_normal, "declare c cursor for select * from test where i <= $1 ",
ECPGt_int,&(*( int *)(ECPG_informix_get_var( 0))),(long)1,(long)1,sizeof(int),
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
-#line 92 "test_informix.pgc"
+#line 93 "test_informix.pgc"
if (sqlca.sqlcode < 0) dosqlprint ( );}
-#line 92 "test_informix.pgc"
+#line 93 "test_informix.pgc"
}
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-03 01:16:19 +0000