diff options
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-sqlda.stderr')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-sqlda.stderr | 242 |
1 files changed, 94 insertions, 148 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-sqlda.stderr b/src/interfaces/ecpg/test/expected/sql-sqlda.stderr index e33c728878e..8cb2f5976a2 100644 --- a/src/interfaces/ecpg/test/expected/sql-sqlda.stderr +++ b/src/interfaces/ecpg/test/expected/sql-sqlda.stderr @@ -14,65 +14,65 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 76: OK: CREATE TABLE [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 84: query: insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' ) , ( 2 , null , null , null , null ) , ( 3 , '"c"' , - 3 , 'nan' :: float8 , 'c' ) , ( 4 , 'd' , 4.0 , 4 , 'd' ); with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 84: query: insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' ) , ( 2 , null , null , null , null ) , ( 4 , 'd' , 4.0 , 4 , 'd' ); with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 84: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 84: OK: INSERT 0 4 +[NO_PID]: ecpg_execute on line 84: OK: INSERT 0 3 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGtrans on line 91: action "commit"; connection "regress1" +[NO_PID]: ECPGtrans on line 90: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGprepare on line 98: name st_id1; query: "SELECT * FROM t1" +[NO_PID]: ECPGprepare on line 97: name st_id1; query: "SELECT * FROM t1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 104: query: declare mycur1 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 103: query: declare mycur1 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 104: using PQexec +[NO_PID]: ecpg_execute on line 103: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 104: OK: DECLARE CURSOR +[NO_PID]: ecpg_execute on line 103: OK: DECLARE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: using PQexec +[NO_PID]: ecpg_execute on line 111: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: new sqlda was built +[NO_PID]: ecpg_execute on line 111: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 1 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: a offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: a offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 1 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: a offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: a offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: using PQexec +[NO_PID]: ecpg_execute on line 111: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: new sqlda was built +[NO_PID]: ecpg_execute on line 111: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 2 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: 2 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NULL [NO_PID]: sqlca: code: 0, state: 00000 @@ -82,153 +82,99 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: using PQexec +[NO_PID]: ecpg_execute on line 111: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: new sqlda was built +[NO_PID]: ecpg_execute on line 111: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 3 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: "c" offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: NaN offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: c offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 111: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: using PQexec +[NO_PID]: ecpg_execute on line 111: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 111: correctly got 0 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_build_native_sqlda sqld = 5 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: new sqlda was built -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 4 offset: -1; array: yes -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: d offset: -1; array: yes -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: 4 offset: -1; array: yes -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 112: RESULT: d offset: -1; array: yes -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: putting result (1 tuple 5 fields) into sqlda descriptor -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: using PQexec -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 112: correctly got 0 tuples with 5 fields -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: raising sqlcode 100 on line 112: no data found on line 112 +[NO_PID]: raising sqlcode 100 on line 111: no data found on line 111 [NO_PID]: sqlca: code: 100, state: 02000 -[NO_PID]: ecpg_execute on line 121: query: close mycur1; with 0 parameter(s) on connection regress1 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 121: using PQexec -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 121: OK: CLOSE CURSOR -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGdeallocate on line 124: name st_id1 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGprepare on line 133: name st_id2; query: "SELECT * FROM t1" -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 139: query: declare mycur2 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 139: using PQexec -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 139: OK: DECLARE CURSOR -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: query: fetch all from mycur2; with 0 parameter(s) on connection regress1 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: using PQexec -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: correctly got 4 tuples with 5 fields -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_build_native_sqlda sqld = 5 -[NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: new sqlda was built +[NO_PID]: ecpg_execute on line 120: query: close mycur1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 3 col 0 IS NOT NULL +[NO_PID]: ecpg_execute on line 120: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_execute on line 120: OK: CLOSE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 3 col 1 IS NOT NULL +[NO_PID]: ECPGdeallocate on line 123: name st_id1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: d offset: -1; array: yes +[NO_PID]: ECPGprepare on line 132: name st_id2; query: "SELECT * FROM t1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 3 col 2 IS NOT NULL +[NO_PID]: ecpg_execute on line 138: query: declare mycur2 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 3 col 3 IS NOT NULL +[NO_PID]: ecpg_execute on line 138: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_execute on line 138: OK: DECLARE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_set_native_sqlda row 3 col 4 IS NOT NULL +[NO_PID]: ecpg_execute on line 141: query: fetch all from mycur2; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: d offset: -1; array: yes +[NO_PID]: ecpg_execute on line 141: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 141: correctly got 3 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: new sqlda was built +[NO_PID]: ecpg_execute on line 141: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 2 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 3 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 2 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: "c" offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 2 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 2 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: NaN offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 2 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: c offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 141: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: new sqlda was built +[NO_PID]: ecpg_execute on line 141: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 1 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 2 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: 2 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 1 col 1 IS NULL [NO_PID]: sqlca: code: 0, state: 00000 @@ -238,125 +184,125 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 1 col 4 IS NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 141: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: new sqlda was built +[NO_PID]: ecpg_execute on line 141: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 1 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: a offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: a offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: 1 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 142: RESULT: a offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 141: RESULT: a offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 142: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 141: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 158: query: close mycur2; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 157: query: close mycur2; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 158: using PQexec +[NO_PID]: ecpg_execute on line 157: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 158: OK: CLOSE CURSOR +[NO_PID]: ecpg_execute on line 157: OK: CLOSE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGdeallocate on line 161: name st_id2 +[NO_PID]: ECPGdeallocate on line 160: name st_id2 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGprepare on line 183: name st_id3; query: "SELECT * FROM t1 WHERE id = $1" +[NO_PID]: ECPGprepare on line 182: name st_id3; query: "SELECT * FROM t1 WHERE id = $1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 186: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 185: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 186: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" +[NO_PID]: ecpg_execute on line 185: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: free_params on line 186: parameter 1 = 4 +[NO_PID]: free_params on line 185: parameter 1 = 4 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 186: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 185: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 186: new sqlda was built +[NO_PID]: ecpg_execute on line 185: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 186: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 185: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 186: RESULT: d offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 185: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 186: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 185: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 186: RESULT: d offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 185: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 186: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 185: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGdeallocate on line 191: name st_id3 +[NO_PID]: ECPGdeallocate on line 190: name st_id3 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGconnect: opening database regress1 on <DEFAULT> port <DEFAULT> [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGprepare on line 220: name st_id4; query: "SELECT * FROM t1 WHERE id = $1" +[NO_PID]: ECPGprepare on line 219: name st_id4; query: "SELECT * FROM t1 WHERE id = $1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 223: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection con2 +[NO_PID]: ecpg_execute on line 222: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection con2 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 223: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" +[NO_PID]: ecpg_execute on line 222: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: free_params on line 223: parameter 1 = 4 +[NO_PID]: free_params on line 222: parameter 1 = 4 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 223: correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 222: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_build_native_sqlda sqld = 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 223: new sqlda was built +[NO_PID]: ecpg_execute on line 222: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 0 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 223: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 222: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 1 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 223: RESULT: d offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 222: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 2 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 3 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 223: RESULT: 4 offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 222: RESULT: 4 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_set_native_sqlda row 0 col 4 IS NOT NULL [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data on line 223: RESULT: d offset: -1; array: yes +[NO_PID]: ecpg_get_data on line 222: RESULT: d offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 223: putting result (1 tuple 5 fields) into sqlda descriptor +[NO_PID]: ecpg_execute on line 222: putting result (1 tuple 5 fields) into sqlda descriptor [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGtrans on line 228: action "commit"; connection "con2" +[NO_PID]: ECPGtrans on line 227: action "commit"; connection "con2" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGdeallocate on line 231: name st_id4 +[NO_PID]: ECPGdeallocate on line 230: name st_id4 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_finish: connection con2 closed [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 242: query: drop table t1; with 0 parameter(s) on connection regress1 +[NO_PID]: ecpg_execute on line 241: query: drop table t1; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 242: using PQexec +[NO_PID]: ecpg_execute on line 241: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 242: OK: DROP TABLE +[NO_PID]: ecpg_execute on line 241: OK: DROP TABLE [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGtrans on line 245: action "commit"; connection "regress1" +[NO_PID]: ECPGtrans on line 244: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_finish: connection regress1 closed [NO_PID]: sqlca: code: 0, state: 00000 |