Debian Codegraph @

src/interfaces/ecpg/test/expected/preproc-variable.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 49: query: set datestyle to iso; with 0 parameter(s) on connection ecpg1_regression
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 49: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 49: OK: SET
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_execute on line 52: query: create table family ( name char ( 8 ) , born integer , age smallint , married date , children integer ); with 0 parameter(s) on connection ecpg1_regression
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 52: using PQexec
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_process_output on line 52: OK: CREATE TABLE
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_execute on line 55: query: insert into family ( name , married , children ) values ( 'Mum' , '19870714' , 3 ); with 0 parameter(s) on connection ecpg1_regression
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 55: using PQexec
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_process_output on line 55: OK: INSERT 0 1
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_execute on line 56: query: insert into family ( name , born , married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ); with 0 parameter(s) on connection ecpg1_regression
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 56: using PQexec
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_process_output on line 56: OK: INSERT 0 1
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_execute on line 57: query: insert into family ( name , age ) values ( 'Child 1' , 16 ); with 0 parameter(s) on connection ecpg1_regression
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 57: using PQexec
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_process_output on line 57: OK: INSERT 0 1
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_execute on line 58: query: insert into family ( name , age ) values ( 'Child 2' , 14 ); with 0 parameter(s) on connection ecpg1_regression
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_execute on line 58: using PQexec
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_process_output on line 58: OK: INSERT 0 1
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_execute on line 59: query: insert into family ( name , age ) values ( 'Child 3' , 9 ); with 0 parameter(s) on connection ecpg1_regression
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_execute on line 59: using PQexec
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_process_output on line 59: OK: INSERT 0 1
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ECPGtrans on line 62: action "commit"; connection "ecpg1_regression"
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_execute on line 65: query: declare cur cursor for select name , born , age , married , children from family; with 0 parameter(s) on connection ecpg1_regression
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_execute on line 65: using PQexec
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_process_output on line 65: OK: DECLARE CURSOR
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_execute on line 74: using PQexec
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 5 fields
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_get_data on line 74: RESULT: Mum offset: -1; array: no
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_store_result on line 74: allocating memory for 1 tuples
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_get_data on line 74: RESULT: 1987-07-14 offset: -1; array: no
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_get_data on line 74: RESULT: 3 offset: -1; array: no
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_execute on line 74: using PQexec
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 5 fields
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_get_data on line 74: RESULT: Dad offset: -1; array: no
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_get_data on line 74: RESULT: 19610721 offset: -1; array: no
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_store_result on line 74: allocating memory for 1 tuples
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_get_data on line 74: RESULT: 1987-07-14 offset: -1; array: no
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_get_data on line 74: RESULT: 3 offset: -1; array: no
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
92 [NO_PID]: sqlca: code: 0, state: 00000
93 [NO_PID]: ecpg_execute on line 74: using PQexec
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 5 fields
96 [NO_PID]: sqlca: code: 0, state: 00000
97 [NO_PID]: ecpg_get_data on line 74: RESULT: Child 1 offset: -1; array: no
98 [NO_PID]: sqlca: code: 0, state: 00000
99 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
100 [NO_PID]: sqlca: code: 0, state: 00000
101 [NO_PID]: ecpg_get_data on line 74: RESULT: 16 offset: -1; array: no
102 [NO_PID]: sqlca: code: 0, state: 00000
103 [NO_PID]: ecpg_store_result on line 74: allocating memory for 1 tuples
104 [NO_PID]: sqlca: code: 0, state: 00000
105 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_execute on line 74: using PQexec
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 5 fields
114 [NO_PID]: sqlca: code: 0, state: 00000
115 [NO_PID]: ecpg_get_data on line 74: RESULT: Child 2 offset: -1; array: no
116 [NO_PID]: sqlca: code: 0, state: 00000
117 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_get_data on line 74: RESULT: 14 offset: -1; array: no
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_store_result on line 74: allocating memory for 1 tuples
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_execute on line 74: using PQexec
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: ecpg_process_output on line 74: correctly got 1 tuples with 5 fields
132 [NO_PID]: sqlca: code: 0, state: 00000
133 [NO_PID]: ecpg_get_data on line 74: RESULT: Child 3 offset: -1; array: no
134 [NO_PID]: sqlca: code: 0, state: 00000
135 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
136 [NO_PID]: sqlca: code: 0, state: 00000
137 [NO_PID]: ecpg_get_data on line 74: RESULT: 9 offset: -1; array: no
138 [NO_PID]: sqlca: code: 0, state: 00000
139 [NO_PID]: ecpg_store_result on line 74: allocating memory for 1 tuples
140 [NO_PID]: sqlca: code: 0, state: 00000
141 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
142 [NO_PID]: sqlca: code: 0, state: 00000
143 [NO_PID]: ecpg_get_data on line 74: RESULT: offset: -1; array: no
144 [NO_PID]: sqlca: code: 0, state: 00000
145 [NO_PID]: ecpg_execute on line 74: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
146 [NO_PID]: sqlca: code: 0, state: 00000
147 [NO_PID]: ecpg_execute on line 74: using PQexec
148 [NO_PID]: sqlca: code: 0, state: 00000
149 [NO_PID]: ecpg_process_output on line 74: correctly got 0 tuples with 5 fields
150 [NO_PID]: sqlca: code: 0, state: 00000
151 [NO_PID]: raising sqlcode 100 on line 74: no data found on line 74
152 [NO_PID]: sqlca: code: 100, state: 02000
153 [NO_PID]: ecpg_execute on line 91: query: close cur; with 0 parameter(s) on connection ecpg1_regression
154 [NO_PID]: sqlca: code: 0, state: 00000
155 [NO_PID]: ecpg_execute on line 91: using PQexec
156 [NO_PID]: sqlca: code: 0, state: 00000
157 [NO_PID]: ecpg_process_output on line 91: OK: CLOSE CURSOR
158 [NO_PID]: sqlca: code: 0, state: 00000
159 [NO_PID]: ecpg_execute on line 94: query: drop table family; with 0 parameter(s) on connection ecpg1_regression
160 [NO_PID]: sqlca: code: 0, state: 00000
161 [NO_PID]: ecpg_execute on line 94: using PQexec
162 [NO_PID]: sqlca: code: 0, state: 00000
163 [NO_PID]: ecpg_process_output on line 94: OK: DROP TABLE
164 [NO_PID]: sqlca: code: 0, state: 00000
165 [NO_PID]: ECPGtrans on line 97: action "commit"; connection "ecpg1_regression"
166 [NO_PID]: sqlca: code: 0, state: 00000
167 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
168 [NO_PID]: sqlca: code: 0, state: 00000