Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-desc.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 30: query: create table test1 ( a int , b text ); with 0 parameter(s) on connection ecpg1_regression
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 30: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 30: OK: CREATE TABLE
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: prepare_common on line 31: name foo1; query: "INSERT INTO test1 VALUES ($1, $2)"
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: prepare_common on line 32: name Foo-1; query: "INSERT INTO test1 VALUES ($1, $2)"
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: prepare_common on line 33: name foo2; query: "SELECT * from test1 where a = $1 and b = $2"
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: prepare_common on line 34: name foo3; query: "SELECT * from test1 where $1 = a"
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 36: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_execute on line 36: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)"
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_free_params on line 36: parameter 1 = 1
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_free_params on line 36: parameter 2 = one
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 1
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_execute on line 41: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 41: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)"
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_free_params on line 41: parameter 1 = 2
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_free_params on line 41: parameter 2 = null
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_process_output on line 41: OK: INSERT 0 1
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_execute on line 46: query: INSERT INTO test1 VALUES ($1, $2); with 2 parameter(s) on connection ecpg1_regression
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_execute on line 46: using PQexecPrepared for "INSERT INTO test1 VALUES ($1, $2)"
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_free_params on line 46: parameter 1 = 3
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_free_params on line 46: parameter 2 = this is a long test
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ecpg_process_output on line 46: OK: INSERT 0 1
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: deallocate_one on line 48: name Foo-1
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_execute on line 53: query: SELECT * from test1 where a = $1 and b = $2; with 2 parameter(s) on connection ecpg1_regression
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_execute on line 53: using PQexecPrepared for "SELECT * from test1 where a = $1 and b = $2"
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_free_params on line 53: parameter 1 = 1
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_free_params on line 53: parameter 2 = one
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_process_output on line 53: correctly got 1 tuples with 2 fields
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_process_output on line 53: putting result (1 tuples) into descriptor outdesc
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ECPGget_desc: reading items for tuple 1
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_get_data on line 55: RESULT: 1 offset: -1; array: no
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_execute on line 59: query: declare c1 cursor for SELECT * from test1 where a = $1 and b = $2; with 2 parameter(s) on connection ecpg1_regression
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_execute on line 59: using PQexecParams
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_free_params on line 59: parameter 1 = 1
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_free_params on line 59: parameter 2 = one
74 [NO_PID]: sqlca: code: 0, state: 00000
75 [NO_PID]: ecpg_process_output on line 59: OK: DECLARE CURSOR
76 [NO_PID]: sqlca: code: 0, state: 00000
77 [NO_PID]: ecpg_execute on line 61: query: fetch next from c1; with 0 parameter(s) on connection ecpg1_regression
78 [NO_PID]: sqlca: code: 0, state: 00000
79 [NO_PID]: ecpg_execute on line 61: using PQexec
80 [NO_PID]: sqlca: code: 0, state: 00000
81 [NO_PID]: ecpg_process_output on line 61: correctly got 1 tuples with 2 fields
82 [NO_PID]: sqlca: code: 0, state: 00000
83 [NO_PID]: ecpg_get_data on line 61: RESULT: 1 offset: -1; array: no
84 [NO_PID]: sqlca: code: 0, state: 00000
85 [NO_PID]: ecpg_get_data on line 61: RESULT: one offset: -1; array: no
86 [NO_PID]: sqlca: code: 0, state: 00000
87 [NO_PID]: ecpg_execute on line 65: query: close c1; with 0 parameter(s) on connection ecpg1_regression
88 [NO_PID]: sqlca: code: 0, state: 00000
89 [NO_PID]: ecpg_execute on line 65: using PQexec
90 [NO_PID]: sqlca: code: 0, state: 00000
91 [NO_PID]: ecpg_process_output on line 65: OK: CLOSE CURSOR
92 [NO_PID]: sqlca: code: 0, state: 00000
93 [NO_PID]: ecpg_execute on line 71: query: declare c2 cursor for SELECT * from test1 where $1 = a; with 1 parameter(s) on connection ecpg1_regression
94 [NO_PID]: sqlca: code: 0, state: 00000
95 [NO_PID]: ecpg_execute on line 71: using PQexecParams
96 [NO_PID]: sqlca: code: 0, state: 00000
97 [NO_PID]: ecpg_free_params on line 71: parameter 1 = 2
98 [NO_PID]: sqlca: code: 0, state: 00000
99 [NO_PID]: ecpg_process_output on line 71: OK: DECLARE CURSOR
100 [NO_PID]: sqlca: code: 0, state: 00000
101 [NO_PID]: ecpg_execute on line 73: query: fetch next from c2; with 0 parameter(s) on connection ecpg1_regression
102 [NO_PID]: sqlca: code: 0, state: 00000
103 [NO_PID]: ecpg_execute on line 73: using PQexec
104 [NO_PID]: sqlca: code: 0, state: 00000
105 [NO_PID]: ecpg_process_output on line 73: correctly got 1 tuples with 2 fields
106 [NO_PID]: sqlca: code: 0, state: 00000
107 [NO_PID]: ecpg_get_data on line 73: RESULT: 2 offset: -1; array: no
108 [NO_PID]: sqlca: code: 0, state: 00000
109 [NO_PID]: ecpg_get_data on line 73: RESULT: offset: -1; array: no
110 [NO_PID]: sqlca: code: 0, state: 00000
111 [NO_PID]: ecpg_execute on line 76: query: close c2; with 0 parameter(s) on connection ecpg1_regression
112 [NO_PID]: sqlca: code: 0, state: 00000
113 [NO_PID]: ecpg_execute on line 76: using PQexec
114 [NO_PID]: sqlca: code: 0, state: 00000
115 [NO_PID]: ecpg_process_output on line 76: OK: CLOSE CURSOR
116 [NO_PID]: sqlca: code: 0, state: 00000
117 [NO_PID]: ecpg_execute on line 78: query: select * from test1 where a = 3; with 0 parameter(s) on connection ecpg1_regression
118 [NO_PID]: sqlca: code: 0, state: 00000
119 [NO_PID]: ecpg_execute on line 78: using PQexec
120 [NO_PID]: sqlca: code: 0, state: 00000
121 [NO_PID]: ecpg_process_output on line 78: correctly got 1 tuples with 2 fields
122 [NO_PID]: sqlca: code: 0, state: 00000
123 [NO_PID]: ecpg_get_data on line 78: RESULT: 3 offset: -1; array: no
124 [NO_PID]: sqlca: code: 0, state: 00000
125 [NO_PID]: ecpg_get_data on line 78: RESULT: this is a long test offset: -1; array: no
126 [NO_PID]: sqlca: code: 0, state: 00000
127 [NO_PID]: ecpg_execute on line 81: query: drop table test1; with 0 parameter(s) on connection ecpg1_regression
128 [NO_PID]: sqlca: code: 0, state: 00000
129 [NO_PID]: ecpg_execute on line 81: using PQexec
130 [NO_PID]: sqlca: code: 0, state: 00000
131 [NO_PID]: ecpg_process_output on line 81: OK: DROP TABLE
132 [NO_PID]: sqlca: code: 0, state: 00000
133 [NO_PID]: deallocate_one on line 82: name foo3
134 [NO_PID]: sqlca: code: 0, state: 00000
135 [NO_PID]: deallocate_one on line 82: name foo2
136 [NO_PID]: sqlca: code: 0, state: 00000
137 [NO_PID]: deallocate_one on line 82: name foo1
138 [NO_PID]: sqlca: code: 0, state: 00000
139 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
140 [NO_PID]: sqlca: code: 0, state: 00000