summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/expected/sql-dynalloc.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-dynalloc.c')
-rw-r--r--src/interfaces/ecpg/test/expected/sql-dynalloc.c350
1 files changed, 207 insertions, 143 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-dynalloc.c b/src/interfaces/ecpg/test/expected/sql-dynalloc.c
index 77cfa52b19..ac6e722af1 100644
--- a/src/interfaces/ecpg/test/expected/sql-dynalloc.c
+++ b/src/interfaces/ecpg/test/expected/sql-dynalloc.c
@@ -74,7 +74,6 @@ struct sqlca_t *ECPGget_sqlca(void);
#ifdef __cplusplus
}
#endif
-
#endif
#line 2 "dynalloc.pgc"
@@ -91,250 +90,315 @@ struct sqlca_t *ECPGget_sqlca(void);
#line 4 "dynalloc.pgc"
-int main(void)
+int
+main(void)
{
- /* exec sql begin declare section */
-
-
-
-
-
-
-
-/* char **d8=0; */
-
-
-
-
-
-
-
-
-/* int *i8=0; */
-
-
+ /* exec sql begin declare section */
+
+
+
+
+
+
+
+/* char **d8=0; */
+
+
+
+
+
+
+
+
+/* int *i8=0; */
+
+
#line 9 "dynalloc.pgc"
- int * d1 = 0 ;
-
+ int *d1 = 0;
+
#line 10 "dynalloc.pgc"
- double * d2 = 0 ;
-
+ double *d2 = 0;
+
#line 11 "dynalloc.pgc"
- char ** d3 = 0 ;
-
+ char **d3 = 0;
+
#line 12 "dynalloc.pgc"
- char ** d4 = 0 ;
-
+ char **d4 = 0;
+
#line 13 "dynalloc.pgc"
- char ** d5 = 0 ;
-
+ char **d5 = 0;
+
#line 14 "dynalloc.pgc"
- char ** d6 = 0 ;
-
+ char **d6 = 0;
+
#line 15 "dynalloc.pgc"
- char ** d7 = 0 ;
-
+ char **d7 = 0;
+
#line 17 "dynalloc.pgc"
- char ** d9 = 0 ;
-
+ char **d9 = 0;
+
#line 18 "dynalloc.pgc"
- int * i1 = 0 ;
-
+ int *i1 = 0;
+
#line 19 "dynalloc.pgc"
- int * i2 = 0 ;
-
+ int *i2 = 0;
+
#line 20 "dynalloc.pgc"
- int * i3 = 0 ;
-
+ int *i3 = 0;
+
#line 21 "dynalloc.pgc"
- int * i4 = 0 ;
-
+ int *i4 = 0;
+
#line 22 "dynalloc.pgc"
- int * i5 = 0 ;
-
+ int *i5 = 0;
+
#line 23 "dynalloc.pgc"
- int * i6 = 0 ;
-
+ int *i6 = 0;
+
#line 24 "dynalloc.pgc"
- int * i7 = 0 ;
-
+ int *i7 = 0;
+
#line 26 "dynalloc.pgc"
- int * i9 = 0 ;
+ int *i9 = 0;
+
/* exec sql end declare section */
#line 27 "dynalloc.pgc"
- int i;
+ int i;
- ECPGdebug(1, stderr);
+ ECPGdebug(1, stderr);
- /* exec sql whenever sqlerror do sqlprint ( ) ; */
+ /* exec sql whenever sqlerror do sqlprint ( ) ; */
#line 32 "dynalloc.pgc"
- { ECPGconnect(__LINE__, 0, "regress1" , NULL,NULL , NULL, 0);
+ {
+ ECPGconnect(__LINE__, 0, "regress1", NULL, NULL, NULL, 0);
#line 33 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 33 "dynalloc.pgc"
- { ECPGdo(__LINE__, 0, 1, NULL, "set datestyle to mdy", ECPGt_EOIT, ECPGt_EORT);
+ {
+ ECPGdo(__LINE__, 0, 1, NULL, "set datestyle to mdy", ECPGt_EOIT, ECPGt_EORT);
#line 35 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 35 "dynalloc.pgc"
- { ECPGdo(__LINE__, 0, 1, NULL, "create table test ( a serial , b numeric ( 12 , 3 ) , c varchar , d varchar ( 3 ) , e char ( 4 ) , f timestamptz , g boolean , h box , i inet ) ", ECPGt_EOIT, ECPGt_EORT);
+ {
+ ECPGdo(__LINE__, 0, 1, NULL, "create table test ( a serial , b numeric ( 12 , 3 ) , c varchar , d varchar ( 3 ) , e char ( 4 ) , f timestamptz , g boolean , h box , i inet ) ", ECPGt_EOIT, ECPGt_EORT);
#line 37 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 37 "dynalloc.pgc"
- { ECPGdo(__LINE__, 0, 1, NULL, "insert into test ( b , c , d , e , f , g , h , i ) values( 23.456 , 'varchar' , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , true , '(1,2,3,4)' , '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128' ) ", ECPGt_EOIT, ECPGt_EORT);
+ {
+ ECPGdo(__LINE__, 0, 1, NULL, "insert into test ( b , c , d , e , f , g , h , i ) values( 23.456 , 'varchar' , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , true , '(1,2,3,4)' , '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128' ) ", ECPGt_EOIT, ECPGt_EORT);
#line 38 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 38 "dynalloc.pgc"
- { ECPGdo(__LINE__, 0, 1, NULL, "insert into test ( b , c , d , e , f , g , h , i ) values( 2.446456 , null , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , false , null , null ) ", ECPGt_EOIT, ECPGt_EORT);
+ {
+ ECPGdo(__LINE__, 0, 1, NULL, "insert into test ( b , c , d , e , f , g , h , i ) values( 2.446456 , null , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , false , null , null ) ", ECPGt_EOIT, ECPGt_EORT);
#line 39 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 39 "dynalloc.pgc"
- ECPGallocate_desc(__LINE__, "mydesc");
+ ECPGallocate_desc(__LINE__, "mydesc");
#line 41 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );
+ if (sqlca.sqlcode < 0)
+ sqlprint();
#line 41 "dynalloc.pgc"
- { ECPGdo(__LINE__, 0, 1, NULL, "select a , b , c , d , e , f , g , h , i from test order by a", ECPGt_EOIT,
- ECPGt_descriptor, "mydesc", 0L, 0L, 0L,
- ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
+ {
+ ECPGdo(__LINE__, 0, 1, NULL, "select a , b , c , d , e , f , g , h , i from test order by a", ECPGt_EOIT,
+ ECPGt_descriptor, "mydesc", 0L, 0L, 0L,
+ ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT);
#line 42 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 42 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 1,ECPGd_indicator,
- ECPGt_int,&(i1),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_int,&(d1),(long)1,(long)0,sizeof(int), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 1, ECPGd_indicator,
+ ECPGt_int, &(i1), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_int, &(d1), (long) 1, (long) 0, sizeof(int), ECPGd_EODT);
#line 43 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 43 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 2,ECPGd_indicator,
- ECPGt_int,&(i2),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_double,&(d2),(long)1,(long)0,sizeof(double), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 2, ECPGd_indicator,
+ ECPGt_int, &(i2), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_double, &(d2), (long) 1, (long) 0, sizeof(double), ECPGd_EODT);
#line 44 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 44 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 3,ECPGd_indicator,
- ECPGt_int,&(i3),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d3),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 3, ECPGd_indicator,
+ ECPGt_int, &(i3), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d3), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 45 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 45 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 4,ECPGd_indicator,
- ECPGt_int,&(i4),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d4),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 4, ECPGd_indicator,
+ ECPGt_int, &(i4), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d4), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 46 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 46 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 5,ECPGd_indicator,
- ECPGt_int,&(i5),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d5),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 5, ECPGd_indicator,
+ ECPGt_int, &(i5), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d5), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 47 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 47 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 6,ECPGd_indicator,
- ECPGt_int,&(i6),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d6),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 6, ECPGd_indicator,
+ ECPGt_int, &(i6), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d6), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 48 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 48 "dynalloc.pgc"
- { ECPGget_desc(__LINE__, "mydesc", 7,ECPGd_indicator,
- ECPGt_int,&(i7),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d7),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ {
+ ECPGget_desc(__LINE__, "mydesc", 7, ECPGd_indicator,
+ ECPGt_int, &(i7), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d7), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 49 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 49 "dynalloc.pgc"
- /* skip box for now */
- /* exec sql get descriptor mydesc value 8 :d8=DATA, :i8=INDICATOR; */
- { ECPGget_desc(__LINE__, "mydesc", 9,ECPGd_indicator,
- ECPGt_int,&(i9),(long)1,(long)0,sizeof(int), ECPGd_data,
- ECPGt_char,&(d9),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
+ /* skip box for now */
+ /* exec sql get descriptor mydesc value 8 :d8=DATA, :i8=INDICATOR; */
+ {
+ ECPGget_desc(__LINE__, "mydesc", 9, ECPGd_indicator,
+ ECPGt_int, &(i9), (long) 1, (long) 0, sizeof(int), ECPGd_data,
+ ECPGt_char, &(d9), (long) 0, (long) 0, (1) * sizeof(char), ECPGd_EODT);
#line 52 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 52 "dynalloc.pgc"
- printf("Result:\n");
- for (i=0;i<sqlca.sqlerrd[2];++i)
- {
- if (i1[i]) printf("NULL, ");
- else printf("%d, ",d1[i]);
-
- if (i2[i]) printf("NULL, ");
- else printf("%f, ",d2[i]);
-
- if (i3[i]) printf("NULL, ");
- else printf("'%s', ",d3[i]);
-
- if (i4[i]) printf("NULL, ");
- else printf("'%s', ",d4[i]);
-
- if (i5[i]) printf("NULL, ");
- else printf("'%s', ",d5[i]);
-
- if (i6[i]) printf("NULL, ");
- else printf("'%s', ",d6[i]);
-
- if (i7[i]) printf("NULL, ");
- else printf("'%s', ",d7[i]);
-
- if (i9[i]) printf("NULL, ");
- else printf("'%s', ",d9[i]);
-
- printf("\n");
- }
- ECPGfree_auto_mem();
- printf("\n");
-
- ECPGdeallocate_desc(__LINE__, "mydesc");
+ printf("Result:\n");
+ for (i = 0; i < sqlca.sqlerrd[2]; ++i)
+ {
+ if (i1[i])
+ printf("NULL, ");
+ else
+ printf("%d, ", d1[i]);
+
+ if (i2[i])
+ printf("NULL, ");
+ else
+ printf("%f, ", d2[i]);
+
+ if (i3[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d3[i]);
+
+ if (i4[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d4[i]);
+
+ if (i5[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d5[i]);
+
+ if (i6[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d6[i]);
+
+ if (i7[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d7[i]);
+
+ if (i9[i])
+ printf("NULL, ");
+ else
+ printf("'%s', ", d9[i]);
+
+ printf("\n");
+ }
+ ECPGfree_auto_mem();
+ printf("\n");
+
+ ECPGdeallocate_desc(__LINE__, "mydesc");
#line 86 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );
+ if (sqlca.sqlcode < 0)
+ sqlprint();
#line 86 "dynalloc.pgc"
- { ECPGdisconnect(__LINE__, "CURRENT");
+ {
+ ECPGdisconnect(__LINE__, "CURRENT");
#line 87 "dynalloc.pgc"
-if (sqlca.sqlcode < 0) sqlprint ( );}
+ if (sqlca.sqlcode < 0)
+ sqlprint();
+ }
#line 87 "dynalloc.pgc"
- return 0;
+ return 0;
}