diff options
Diffstat (limited to 'src/interfaces/ecpg/test/test_informix.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/test_informix.pgc | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/test/test_informix.pgc b/src/interfaces/ecpg/test/test_informix.pgc index abcd65ac2d..755dab2ef2 100644 --- a/src/interfaces/ecpg/test/test_informix.pgc +++ b/src/interfaces/ecpg/test/test_informix.pgc @@ -17,8 +17,18 @@ int main() rsetnull(CDECIMALTYPE, (char *)&j); $insert into test (i, j) values (7, :j); + $commit; + + $insert into test (i, j) values (7, 2); + printf("%ld: %s\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc); + if (sqlca.sqlcode != 0) $rollback; + $insert into test (i, j) values (:i, 1); + $select i from test where j=(select j from test); + printf("%ld: %s\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc); + if (sqlca.sqlcode != 0) $rollback; + $declare c cursor for select * from test where i <= :i; openit(); |