diff options
| author | Michael Meskes <meskes@postgresql.org> | 2013-11-26 17:15:15 +0100 |
|---|---|---|
| committer | Michael Meskes <meskes@postgresql.org> | 2013-11-26 17:42:32 +0100 |
| commit | 1ec4c56e76714d3894cfc301212ec98674720e3b (patch) | |
| tree | a00830507b4a152d3afbcdceb02fd1980ab7397a /src/interfaces/ecpg/test/expected/sql-fetch.c | |
| parent | db58e8ff7cec9a14418d6dccd33bbe186d10c1f4 (diff) | |
| download | postgresql-1ec4c56e76714d3894cfc301212ec98674720e3b.tar.gz postgresql-1ec4c56e76714d3894cfc301212ec98674720e3b.zip | |
ECPG: Add EXEC SQL CLOSE C to the tests.
Patch by Boszormenyi Zoltan <zb@cybertec.at>
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-fetch.c')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-fetch.c | 46 |
1 files changed, 28 insertions, 18 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-fetch.c b/src/interfaces/ecpg/test/expected/sql-fetch.c index db7a0c2aab5..c6be49ccb09 100644 --- a/src/interfaces/ecpg/test/expected/sql-fetch.c +++ b/src/interfaces/ecpg/test/expected/sql-fetch.c @@ -162,24 +162,34 @@ if (sqlca.sqlcode < 0) sqlprint();} printf("%d: %s\n", i, str); - /* declare D cursor for select * from My_Table where Item1 = $1 */ + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "close C", ECPGt_EOIT, ECPGt_EORT); #line 42 "fetch.pgc" +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 42 "fetch.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 42 "fetch.pgc" + + + /* declare D cursor for select * from My_Table where Item1 = $1 */ +#line 44 "fetch.pgc" + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "declare D cursor for select * from My_Table where Item1 = $1", ECPGt_const,"1",(long)1,(long)1,strlen("1"), ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT); -#line 44 "fetch.pgc" +#line 46 "fetch.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 44 "fetch.pgc" +#line 46 "fetch.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 44 "fetch.pgc" +#line 46 "fetch.pgc" /* exec sql whenever not found break ; */ -#line 46 "fetch.pgc" +#line 48 "fetch.pgc" while (1) { { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "fetch 1 in D", ECPGt_EOIT, @@ -187,47 +197,47 @@ if (sqlca.sqlcode < 0) sqlprint();} ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_char,(str),(long)25,(long)1,(25)*sizeof(char), ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); -#line 48 "fetch.pgc" +#line 50 "fetch.pgc" if (sqlca.sqlcode == ECPG_NOT_FOUND) break; -#line 48 "fetch.pgc" +#line 50 "fetch.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 48 "fetch.pgc" +#line 50 "fetch.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 48 "fetch.pgc" +#line 50 "fetch.pgc" printf("%d: %s\n", i, str); } { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "close D", ECPGt_EOIT, ECPGt_EORT); -#line 51 "fetch.pgc" +#line 53 "fetch.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 51 "fetch.pgc" +#line 53 "fetch.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 51 "fetch.pgc" +#line 53 "fetch.pgc" { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "drop table My_Table", ECPGt_EOIT, ECPGt_EORT); -#line 53 "fetch.pgc" +#line 55 "fetch.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 53 "fetch.pgc" +#line 55 "fetch.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 53 "fetch.pgc" +#line 55 "fetch.pgc" { ECPGdisconnect(__LINE__, "ALL"); -#line 55 "fetch.pgc" +#line 57 "fetch.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 55 "fetch.pgc" +#line 57 "fetch.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 55 "fetch.pgc" +#line 57 "fetch.pgc" return 0; |