Debian Codegraph @

src/interfaces/ecpg/test/expected/compat_informix-test_informix.stderr

raw
1 [NO_PID]: ECPGdebug: set to 1
2 [NO_PID]: sqlca: code: 0, state: 00000
3 [NO_PID]: ECPGconnect: opening database ecpg1_regression on <DEFAULT> port <DEFAULT>
4 [NO_PID]: sqlca: code: 0, state: 00000
5 [NO_PID]: ecpg_execute on line 24: query: create table test ( i int primary key , j int , c text ); with 0 parameter(s) on connection ecpg1_regression
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 24: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 24: OK: CREATE TABLE
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_execute on line 28: query: insert into test ( i , j , c ) values ( 7 , $1 , 'test ' ); with 1 parameter(s) on connection ecpg1_regression
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 28: using PQexecParams
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_free_params on line 28: parameter 1 = 0
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_process_output on line 28: OK: INSERT 0 1
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ECPGtrans on line 29: action "commit"; connection "ecpg1_regression"
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_execute on line 32: query: insert into test ( i , j , c ) values ( 7 , 12 , 'a' ); with 0 parameter(s) on connection ecpg1_regression
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_execute on line 32: using PQexec
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_check_PQresult on line 32: bad response - ERROR: duplicate key value violates unique constraint "test_pkey"
26 DETAIL: Key (i)=(7) already exists.
27 [NO_PID]: sqlca: code: 0, state: 00000
28 [NO_PID]: raising sqlstate 23505 (sqlcode -239): duplicate key value violates unique constraint "test_pkey" on line 32
29 [NO_PID]: sqlca: code: -239, state: 23505
30 [NO_PID]: ECPGtrans on line 34: action "rollback"; connection "ecpg1_regression"
31 [NO_PID]: sqlca: code: 0, state: 00000
32 [NO_PID]: ecpg_execute on line 36: query: insert into test ( i , j , c ) values ( $1 , 1 , 'a ' ); with 1 parameter(s) on connection ecpg1_regression
33 [NO_PID]: sqlca: code: 0, state: 00000
34 [NO_PID]: ecpg_execute on line 36: using PQexecParams
35 [NO_PID]: sqlca: code: 0, state: 00000
36 [NO_PID]: ecpg_free_params on line 36: parameter 1 = 14
37 [NO_PID]: sqlca: code: 0, state: 00000
38 [NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 1
39 [NO_PID]: sqlca: code: 0, state: 00000
40 [NO_PID]: ECPGtrans on line 37: action "commit"; connection "ecpg1_regression"
41 [NO_PID]: sqlca: code: 0, state: 00000
42 [NO_PID]: ecpg_execute on line 40: query: select i from test where j = ( select j from test ); with 0 parameter(s) on connection ecpg1_regression
43 [NO_PID]: sqlca: code: 0, state: 00000
44 [NO_PID]: ecpg_execute on line 40: using PQexec
45 [NO_PID]: sqlca: code: 0, state: 00000
46 [NO_PID]: ecpg_check_PQresult on line 40: bad response - ERROR: more than one row returned by a subquery used as an expression
47 [NO_PID]: sqlca: code: 0, state: 00000
48 [NO_PID]: raising sqlstate 21000 (sqlcode -284): more than one row returned by a subquery used as an expression on line 40
49 [NO_PID]: sqlca: code: -284, state: 21000
50 [NO_PID]: ECPGtrans on line 41: action "rollback"; connection "ecpg1_regression"
51 [NO_PID]: sqlca: code: 0, state: 00000
52 [NO_PID]: ecpg_execute on line 44: query: select i from test where j = ( select j from test order by i limit 1 ); with 0 parameter(s) on connection ecpg1_regression
53 [NO_PID]: sqlca: code: 0, state: 00000
54 [NO_PID]: ecpg_execute on line 44: using PQexec
55 [NO_PID]: sqlca: code: 0, state: 00000
56 [NO_PID]: ecpg_process_output on line 44: correctly got 1 tuples with 1 fields
57 [NO_PID]: sqlca: code: 0, state: 00000
58 [NO_PID]: ecpg_execute on line 94: query: declare c cursor for select * from test where i <= $1 ; with 1 parameter(s) on connection ecpg1_regression
59 [NO_PID]: sqlca: code: 0, state: 00000
60 [NO_PID]: ecpg_execute on line 94: using PQexecParams
61 [NO_PID]: sqlca: code: 0, state: 00000
62 [NO_PID]: ecpg_free_params on line 94: parameter 1 = 14
63 [NO_PID]: sqlca: code: 0, state: 00000
64 [NO_PID]: ecpg_process_output on line 94: OK: DECLARE CURSOR
65 [NO_PID]: sqlca: code: 0, state: 00000
66 [NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
67 [NO_PID]: sqlca: code: 0, state: 00000
68 [NO_PID]: ecpg_execute on line 57: using PQexec
69 [NO_PID]: sqlca: code: 0, state: 00000
70 [NO_PID]: ecpg_process_output on line 57: correctly got 1 tuples with 3 fields
71 [NO_PID]: sqlca: code: 0, state: 00000
72 [NO_PID]: ecpg_get_data on line 57: RESULT: 7 offset: -1; array: no
73 [NO_PID]: sqlca: code: 0, state: 00000
74 [NO_PID]: ecpg_get_data on line 57: RESULT: 0 offset: -1; array: no
75 [NO_PID]: sqlca: code: 0, state: 00000
76 [NO_PID]: ecpg_get_data on line 57: RESULT: test offset: -1; array: no
77 [NO_PID]: sqlca: code: 0, state: 00000
78 [NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
79 [NO_PID]: sqlca: code: 0, state: 00000
80 [NO_PID]: ecpg_execute on line 57: using PQexec
81 [NO_PID]: sqlca: code: 0, state: 00000
82 [NO_PID]: ecpg_process_output on line 57: correctly got 1 tuples with 3 fields
83 [NO_PID]: sqlca: code: 0, state: 00000
84 [NO_PID]: ecpg_get_data on line 57: RESULT: 14 offset: -1; array: no
85 [NO_PID]: sqlca: code: 0, state: 00000
86 [NO_PID]: ecpg_get_data on line 57: RESULT: 1 offset: -1; array: no
87 [NO_PID]: sqlca: code: 0, state: 00000
88 [NO_PID]: ecpg_get_data on line 57: RESULT: a offset: -1; array: no
89 [NO_PID]: sqlca: code: 0, state: 00000
90 [NO_PID]: ecpg_execute on line 57: query: fetch forward c; with 0 parameter(s) on connection ecpg1_regression
91 [NO_PID]: sqlca: code: 0, state: 00000
92 [NO_PID]: ecpg_execute on line 57: using PQexec
93 [NO_PID]: sqlca: code: 0, state: 00000
94 [NO_PID]: ecpg_process_output on line 57: correctly got 0 tuples with 3 fields
95 [NO_PID]: sqlca: code: 0, state: 00000
96 [NO_PID]: raising sqlcode 100 on line 57: no data found on line 57
97 [NO_PID]: sqlca: code: 100, state: 02000
98 [NO_PID]: ecpg_execute on line 74: query: delete from test where i = $1 :: decimal; with 1 parameter(s) on connection ecpg1_regression
99 [NO_PID]: sqlca: code: 0, state: 00000
100 [NO_PID]: ecpg_execute on line 74: using PQexecParams
101 [NO_PID]: sqlca: code: 0, state: 00000
102 [NO_PID]: ecpg_free_params on line 74: parameter 1 = 21.0
103 [NO_PID]: sqlca: code: 0, state: 00000
104 [NO_PID]: ecpg_process_output on line 74: OK: DELETE 0
105 [NO_PID]: sqlca: code: 0, state: 00000
106 [NO_PID]: raising sqlcode 100 on line 74: no data found on line 74
107 [NO_PID]: sqlca: code: 100, state: 02000
108 [NO_PID]: ecpg_execute on line 77: query: select 1 from test where i = 14; with 0 parameter(s) on connection ecpg1_regression
109 [NO_PID]: sqlca: code: 0, state: 00000
110 [NO_PID]: ecpg_execute on line 77: using PQexec
111 [NO_PID]: sqlca: code: 0, state: 00000
112 [NO_PID]: ecpg_process_output on line 77: correctly got 1 tuples with 1 fields
113 [NO_PID]: sqlca: code: 0, state: 00000
114 [NO_PID]: ecpg_execute on line 80: query: select 1 from test where i = 147; with 0 parameter(s) on connection ecpg1_regression
115 [NO_PID]: sqlca: code: 0, state: 00000
116 [NO_PID]: ecpg_execute on line 80: using PQexec
117 [NO_PID]: sqlca: code: 0, state: 00000
118 [NO_PID]: ecpg_process_output on line 80: correctly got 0 tuples with 1 fields
119 [NO_PID]: sqlca: code: 0, state: 00000
120 [NO_PID]: raising sqlcode 100 on line 80: no data found on line 80
121 [NO_PID]: sqlca: code: 100, state: 02000
122 [NO_PID]: ECPGtrans on line 83: action "commit"; connection "ecpg1_regression"
123 [NO_PID]: sqlca: code: 0, state: 00000
124 [NO_PID]: ecpg_execute on line 84: query: drop table test; with 0 parameter(s) on connection ecpg1_regression
125 [NO_PID]: sqlca: code: 0, state: 00000
126 [NO_PID]: ecpg_execute on line 84: using PQexec
127 [NO_PID]: sqlca: code: 0, state: 00000
128 [NO_PID]: ecpg_process_output on line 84: OK: DROP TABLE
129 [NO_PID]: sqlca: code: 0, state: 00000
130 [NO_PID]: ECPGtrans on line 85: action "commit"; connection "ecpg1_regression"
131 [NO_PID]: sqlca: code: 0, state: 00000
132 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
133 [NO_PID]: sqlca: code: 0, state: 00000