diff options
Diffstat (limited to 'src/interfaces/ecpg/test/expected/preproc-variable.stderr')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/preproc-variable.stderr | 164 |
1 files changed, 82 insertions, 82 deletions
diff --git a/src/interfaces/ecpg/test/expected/preproc-variable.stderr b/src/interfaces/ecpg/test/expected/preproc-variable.stderr index eb62ef52682..73daf0637fc 100644 --- a/src/interfaces/ecpg/test/expected/preproc-variable.stderr +++ b/src/interfaces/ecpg/test/expected/preproc-variable.stderr @@ -2,167 +2,167 @@ [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]: ecpg_execute line 46: QUERY: set datestyle to iso with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 46: query: set datestyle to iso; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 46: using PQexec +[NO_PID]: ecpg_execute on line 46: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 46 Ok: SET +[NO_PID]: ecpg_execute on line 46: OK: SET [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 49: QUERY: create table family ( name char ( 8 ) , born integer , age smallint , married date , children integer ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 49: query: create table family ( name char ( 8 ) , born integer , age smallint , married date , children integer ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 49: using PQexec +[NO_PID]: ecpg_execute on line 49: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 49 Ok: CREATE TABLE +[NO_PID]: ecpg_execute on line 49: OK: CREATE TABLE [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 52: QUERY: insert into family ( name , married , children ) values ( 'Mum' , '19870714' , 3 ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 52: query: insert into family ( name , married , children ) values ( 'Mum' , '19870714' , 3 ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 52: using PQexec +[NO_PID]: ecpg_execute on line 52: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 52 Ok: INSERT 0 1 +[NO_PID]: ecpg_execute on line 52: OK: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 53: QUERY: insert into family ( name , born , married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 53: query: insert into family ( name , born , married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 53: using PQexec +[NO_PID]: ecpg_execute on line 53: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 53 Ok: INSERT 0 1 +[NO_PID]: ecpg_execute on line 53: OK: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 54: QUERY: insert into family ( name , age ) values ( 'Child 1' , 16 ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 54: query: insert into family ( name , age ) values ( 'Child 1' , 16 ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 54: using PQexec +[NO_PID]: ecpg_execute on line 54: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 54 Ok: INSERT 0 1 +[NO_PID]: ecpg_execute on line 54: OK: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 55: QUERY: insert into family ( name , age ) values ( 'Child 2' , 14 ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 55: query: insert into family ( name , age ) values ( 'Child 2' , 14 ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 55: using PQexec +[NO_PID]: ecpg_execute on line 55: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 55 Ok: INSERT 0 1 +[NO_PID]: ecpg_execute on line 55: OK: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 56: QUERY: insert into family ( name , age ) values ( 'Child 3' , 9 ) with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 56: query: insert into family ( name , age ) values ( 'Child 3' , 9 ) ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 56: using PQexec +[NO_PID]: ecpg_execute on line 56: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 56 Ok: INSERT 0 1 +[NO_PID]: ecpg_execute on line 56: OK: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGtrans line 59 action = commit connection = regress1 +[NO_PID]: ECPGtrans on line 59: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 62: QUERY: declare cur cursor for select name , born , age , married , children from family with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 62: query: declare cur cursor for select name , born , age , married , children from family ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 62: using PQexec +[NO_PID]: ecpg_execute on line 62: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 62 Ok: DECLARE CURSOR +[NO_PID]: ecpg_execute on line 62: OK: DECLARE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: Mum offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: Mum offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_store_result: line 71: allocating memory for 1 tuples +[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 1987-07-14 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 1987-07-14 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 3 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 3 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: Dad offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: Dad offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 19610721 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 19610721 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_store_result: line 71: allocating memory for 1 tuples +[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 1987-07-14 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 1987-07-14 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 3 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 3 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: Child 1 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: Child 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 16 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 16 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_store_result: line 71: allocating memory for 1 tuples +[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: Child 2 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: Child 2 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 14 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 14 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_store_result: line 71: allocating memory for 1 tuples +[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 1 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: Child 3 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: Child 3 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: 9 offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: 9 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_store_result: line 71: allocating memory for 1 tuples +[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_get_data line 71: RESULT: offset: -1 array: Yes +[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: QUERY: fetch cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: using PQexec +[NO_PID]: ecpg_execute on line 71: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 71: Correctly got 0 tuples with 5 fields +[NO_PID]: ecpg_execute on line 71: correctly got 0 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: raising sqlcode 100 in line 71, 'No data found in line 71.'. +[NO_PID]: raising sqlcode 100 on line 71: no data found on line 71 [NO_PID]: sqlca: code: 100, state: 02000 -[NO_PID]: ecpg_execute line 88: QUERY: close cur with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 88: query: close cur; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 88: using PQexec +[NO_PID]: ecpg_execute on line 88: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 88 Ok: CLOSE CURSOR +[NO_PID]: ecpg_execute on line 88: OK: CLOSE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 91: QUERY: drop table family with 0 parameter on connection regress1 +[NO_PID]: ecpg_execute on line 91: query: drop table family ; with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 91: using PQexec +[NO_PID]: ecpg_execute on line 91: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute line 91 Ok: DROP TABLE +[NO_PID]: ecpg_execute on line 91: OK: DROP TABLE [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGtrans line 94 action = commit connection = regress1 +[NO_PID]: ECPGtrans on line 94: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_finish: Connection regress1 closed. +[NO_PID]: ecpg_finish: connection regress1 closed [NO_PID]: sqlca: code: 0, state: 00000 |