From 84844bab2c1f7e018cd05cd12332d853cb84ac79 Mon Sep 17 00:00:00 2001 From: Michael Meskes Date: Sat, 19 Aug 2006 13:42:40 +0000 Subject: More SoC stuff --- .../ecpg/test/expected/sql-dynalloc.stderr | 68 ++++++++++++---------- 1 file changed, 36 insertions(+), 32 deletions(-) (limited to 'src/interfaces/ecpg/test/expected/sql-dynalloc.stderr') diff --git a/src/interfaces/ecpg/test/expected/sql-dynalloc.stderr b/src/interfaces/ecpg/test/expected/sql-dynalloc.stderr index c871bee98a..aa47dd9146 100644 --- a/src/interfaces/ecpg/test/expected/sql-dynalloc.stderr +++ b/src/interfaces/ecpg/test/expected/sql-dynalloc.stderr @@ -2,87 +2,91 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGconnect: opening database regress1 on port [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 35: QUERY: create table test ( a serial , b numeric ( 12 , 3 ) , c varchar , d varchar ( 3 ) , e char ( 4 ) , f timestamptz , g boolean , h box , i inet ) on connection regress1 +[NO_PID]: ECPGexecute line 35: QUERY: set datestyle to mdy on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 35 Ok: CREATE TABLE +[NO_PID]: ECPGexecute line 35 Ok: SET [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 36: QUERY: insert into test ( b , c , d , e , f , g , h , i ) values( 23.456 , 'varchar' , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , true , '(1,2,3,4)' , '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128' ) on connection regress1 +[NO_PID]: ECPGexecute line 37: QUERY: create table test ( a serial , b numeric ( 12 , 3 ) , c varchar , d varchar ( 3 ) , e char ( 4 ) , f timestamptz , g boolean , h box , i inet ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 36 Ok: INSERT 0 1 +[NO_PID]: ECPGexecute line 37 Ok: CREATE TABLE [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 37: QUERY: insert into test ( b , c , d , e , f , g , h , i ) values( 2.446456 , null , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , false , null , null ) on connection regress1 +[NO_PID]: ECPGexecute line 38: QUERY: insert into test ( b , c , d , e , f , g , h , i ) values( 23.456 , 'varchar' , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , true , '(1,2,3,4)' , '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128' ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 37 Ok: INSERT 0 1 +[NO_PID]: ECPGexecute line 38 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 40: QUERY: select a , b , c , d , e , f , g , h , i from test order by a on connection regress1 +[NO_PID]: ECPGexecute line 39: QUERY: insert into test ( b , c , d , e , f , g , h , i ) values( 2.446456 , null , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , false , null , null ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGexecute line 40: Correctly got 2 tuples with 9 fields +[NO_PID]: ECPGexecute line 39 Ok: INSERT 0 1 +[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: ECPGexecute line 42: QUERY: select a , b , c , d , e , f , g , h , i from test order by a on connection regress1 +[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: ECPGexecute line 42: Correctly got 2 tuples with 9 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute putting result (2 tuples) into descriptor 'mydesc' [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 41: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 43: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 41: RESULT: 1 offset: -1 array: Yes +[NO_PID]: ECPGget_data line 43: RESULT: 1 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 41: RESULT: 2 offset: -1 array: Yes +[NO_PID]: ECPGget_data line 43: RESULT: 2 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 2 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 42: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 44: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 42: RESULT: 23.456 offset: -1 array: Yes +[NO_PID]: ECPGget_data line 44: RESULT: 23.456 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 42: RESULT: 2.446 offset: -1 array: Yes +[NO_PID]: ECPGget_data line 44: RESULT: 2.446 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 3 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 43: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 45: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 43: RESULT: varchar offset: -1 array: Yes +[NO_PID]: ECPGget_data line 45: RESULT: varchar offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 43: RESULT: offset: -1 array: Yes +[NO_PID]: ECPGget_data line 45: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 4 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 44: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 46: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 44: RESULT: v offset: -1 array: Yes +[NO_PID]: ECPGget_data line 46: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 44: RESULT: v offset: -1 array: Yes +[NO_PID]: ECPGget_data line 46: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 5 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 45: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 47: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 45: RESULT: c offset: -1 array: Yes +[NO_PID]: ECPGget_data line 47: RESULT: c offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 45: RESULT: c offset: -1 array: Yes +[NO_PID]: ECPGget_data line 47: RESULT: c offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 6 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 46: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 48: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes +[NO_PID]: ECPGget_data line 48: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes +[NO_PID]: ECPGget_data line 48: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 7 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 47: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 49: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 47: RESULT: t offset: -1 array: Yes +[NO_PID]: ECPGget_data line 49: RESULT: t offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 47: RESULT: f offset: -1 array: Yes +[NO_PID]: ECPGget_data line 49: RESULT: f offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 9 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGstore_result: line 50: allocating memory for 2 tuples +[NO_PID]: ECPGstore_result: line 52: allocating memory for 2 tuples [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 50: RESULT: 2001:4f8:3:ba:2e0:81ff:fe22:d1f1 offset: -1 array: Yes +[NO_PID]: ECPGget_data line 52: RESULT: 2001:4f8:3:ba:2e0:81ff:fe22:d1f1 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ECPGget_data line 50: RESULT: offset: -1 array: Yes +[NO_PID]: ECPGget_data line 52: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_finish: Connection regress1 closed. [NO_PID]: sqlca: code: 0, state: 00000 -- cgit v1.2.1