diff options
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-show.c')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-show.c | 157 |
1 files changed, 74 insertions, 83 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-show.c b/src/interfaces/ecpg/test/expected/sql-show.c index a0cba021afc..541ed73afb5 100644 --- a/src/interfaces/ecpg/test/expected/sql-show.c +++ b/src/interfaces/ecpg/test/expected/sql-show.c @@ -22,134 +22,125 @@ #line 5 "show.pgc" -int -main(int argc, char *argv[]) -{ - /* exec sql begin declare section */ - - +int main(int argc, char* argv[]) { + /* exec sql begin declare section */ + + #line 9 "show.pgc" - char var[25]; - + char var [ 25 ] ; /* exec sql end declare section */ #line 10 "show.pgc" - ECPGdebug(1, stderr); - { - ECPGconnect(__LINE__, 0, "regress1", NULL, NULL, NULL, 0); - } + ECPGdebug(1, stderr); + { ECPGconnect(__LINE__, 0, "regress1" , NULL,NULL , NULL, 0); } #line 13 "show.pgc" - /* exec sql whenever sql_warning sqlprint ; */ + /* exec sql whenever sql_warning sqlprint ; */ #line 15 "show.pgc" - /* exec sql whenever sqlerror sqlprint ; */ + /* exec sql whenever sqlerror sqlprint ; */ #line 16 "show.pgc" - { - ECPGdo(__LINE__, 0, 1, NULL, "show search_path", ECPGt_EOIT, - ECPGt_char, (var), (long) 25, (long) 1, (25) * sizeof(char), - ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT); + { ECPGdo(__LINE__, 0, 1, NULL, "set search_path to 'public'", ECPGt_EOIT, ECPGt_EORT); #line 18 "show.pgc" - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); +if (sqlca.sqlwarn[0] == 'W') sqlprint(); #line 18 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } +if (sqlca.sqlcode < 0) sqlprint();} #line 18 "show.pgc" - printf("Var: Search path: %s\n", var); + { ECPGdo(__LINE__, 0, 1, NULL, "show search_path", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 19 "show.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 19 "show.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 19 "show.pgc" - { - ECPGdo(__LINE__, 0, 1, NULL, "show wal_buffers", ECPGt_EOIT, - ECPGt_char, (var), (long) 25, (long) 1, (25) * sizeof(char), - ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT); -#line 21 "show.pgc" + printf("Var: Search path: %s\n", var); - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); -#line 21 "show.pgc" + { ECPGdo(__LINE__, 0, 1, NULL, "set standard_conforming_strings to off", ECPGt_EOIT, ECPGt_EORT); +#line 22 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } -#line 21 "show.pgc" +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 22 "show.pgc" - printf("Var: WAL buffers: %s\n", var); +if (sqlca.sqlcode < 0) sqlprint();} +#line 22 "show.pgc" - { - ECPGdo(__LINE__, 0, 1, NULL, "show standard_conforming_strings", ECPGt_EOIT, - ECPGt_char, (var), (long) 25, (long) 1, (25) * sizeof(char), - ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT); -#line 24 "show.pgc" + { ECPGdo(__LINE__, 0, 1, NULL, "show standard_conforming_strings", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 23 "show.pgc" - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); -#line 24 "show.pgc" +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 23 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } -#line 24 "show.pgc" +if (sqlca.sqlcode < 0) sqlprint();} +#line 23 "show.pgc" - printf("Var: Standard conforming strings: %s\n", var); + printf("Var: Standard conforming strings: %s\n", var); - { - ECPGdo(__LINE__, 0, 1, NULL, "show time zone", ECPGt_EOIT, - ECPGt_char, (var), (long) 25, (long) 1, (25) * sizeof(char), - ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT); + { ECPGdo(__LINE__, 0, 1, NULL, "set time zone PST8PDT", ECPGt_EOIT, ECPGt_EORT); +#line 26 "show.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 26 "show.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 26 "show.pgc" + + { ECPGdo(__LINE__, 0, 1, NULL, "show time zone", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); #line 27 "show.pgc" - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); +if (sqlca.sqlwarn[0] == 'W') sqlprint(); #line 27 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } +if (sqlca.sqlcode < 0) sqlprint();} #line 27 "show.pgc" - printf("Time Zone: %s\n", var); + printf("Time Zone: %s\n", var); - { - ECPGdo(__LINE__, 0, 1, NULL, "show transaction isolation level", ECPGt_EOIT, - ECPGt_char, (var), (long) 25, (long) 1, (25) * sizeof(char), - ECPGt_NO_INDICATOR, NULL, 0L, 0L, 0L, ECPGt_EORT); + { ECPGdo(__LINE__, 0, 1, NULL, "set transaction isolation level read committed", ECPGt_EOIT, ECPGt_EORT); #line 30 "show.pgc" - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); +if (sqlca.sqlwarn[0] == 'W') sqlprint(); #line 30 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } +if (sqlca.sqlcode < 0) sqlprint();} #line 30 "show.pgc" - printf("Transaction isolation level: %s\n", var); + { ECPGdo(__LINE__, 0, 1, NULL, "show transaction isolation level", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 31 "show.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 31 "show.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 31 "show.pgc" - /* Do not ask for the user name, it may differ in a regression test */ - /* EXEC SQL SHOW SESSION AUTHORIZATION INTO :var; */ + printf("Transaction isolation level: %s\n", var); - { - ECPGdisconnect(__LINE__, "ALL"); -#line 36 "show.pgc" + { ECPGdisconnect(__LINE__, "ALL"); +#line 34 "show.pgc" - if (sqlca.sqlwarn[0] == 'W') - sqlprint(); -#line 36 "show.pgc" +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 34 "show.pgc" - if (sqlca.sqlcode < 0) - sqlprint(); - } -#line 36 "show.pgc" +if (sqlca.sqlcode < 0) sqlprint();} +#line 34 "show.pgc" - return 0; + return 0; } |