Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-insupd.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 18: query: create table insupd_test ( a int , b int ); with 0 parameter(s) on connection ecpg1_regression
6 [NO_PID]: sqlca: code: 0, state: 00000
7 [NO_PID]: ecpg_execute on line 18: using PQexec
8 [NO_PID]: sqlca: code: 0, state: 00000
9 [NO_PID]: ecpg_process_output on line 18: OK: CREATE TABLE
10 [NO_PID]: sqlca: code: 0, state: 00000
11 [NO_PID]: ecpg_execute on line 20: query: insert into insupd_test ( a , b ) values ( 1 , 1 ); with 0 parameter(s) on connection ecpg1_regression
12 [NO_PID]: sqlca: code: 0, state: 00000
13 [NO_PID]: ecpg_execute on line 20: using PQexec
14 [NO_PID]: sqlca: code: 0, state: 00000
15 [NO_PID]: ecpg_process_output on line 20: OK: INSERT 0 1
16 [NO_PID]: sqlca: code: 0, state: 00000
17 [NO_PID]: ecpg_execute on line 21: query: insert into insupd_test ( a , b ) values ( 2 , 2 ); with 0 parameter(s) on connection ecpg1_regression
18 [NO_PID]: sqlca: code: 0, state: 00000
19 [NO_PID]: ecpg_execute on line 21: using PQexec
20 [NO_PID]: sqlca: code: 0, state: 00000
21 [NO_PID]: ecpg_process_output on line 21: OK: INSERT 0 1
22 [NO_PID]: sqlca: code: 0, state: 00000
23 [NO_PID]: ecpg_execute on line 22: query: insert into insupd_test ( a , b ) values ( 3 , 3 ) returning a; with 0 parameter(s) on connection ecpg1_regression
24 [NO_PID]: sqlca: code: 0, state: 00000
25 [NO_PID]: ecpg_execute on line 22: using PQexec
26 [NO_PID]: sqlca: code: 0, state: 00000
27 [NO_PID]: ecpg_process_output on line 22: correctly got 1 tuples with 1 fields
28 [NO_PID]: sqlca: code: 0, state: 00000
29 [NO_PID]: ecpg_get_data on line 22: RESULT: 3 offset: -1; array: no
30 [NO_PID]: sqlca: code: 0, state: 00000
31 [NO_PID]: ecpg_execute on line 24: query: update insupd_test set a = a + 1 returning a; with 0 parameter(s) on connection ecpg1_regression
32 [NO_PID]: sqlca: code: 0, state: 00000
33 [NO_PID]: ecpg_execute on line 24: using PQexec
34 [NO_PID]: sqlca: code: 0, state: 00000
35 [NO_PID]: ecpg_process_output on line 24: correctly got 3 tuples with 1 fields
36 [NO_PID]: sqlca: code: 0, state: 00000
37 [NO_PID]: ecpg_get_data on line 24: RESULT: 2 offset: -1; array: no
38 [NO_PID]: sqlca: code: 0, state: 00000
39 [NO_PID]: ecpg_get_data on line 24: RESULT: 3 offset: -1; array: no
40 [NO_PID]: sqlca: code: 0, state: 00000
41 [NO_PID]: ecpg_get_data on line 24: RESULT: 4 offset: -1; array: no
42 [NO_PID]: sqlca: code: 0, state: 00000
43 [NO_PID]: ecpg_execute on line 25: query: update insupd_test set ( a , b ) = ( 5 , 5 ) where a = 4; with 0 parameter(s) on connection ecpg1_regression
44 [NO_PID]: sqlca: code: 0, state: 00000
45 [NO_PID]: ecpg_execute on line 25: using PQexec
46 [NO_PID]: sqlca: code: 0, state: 00000
47 [NO_PID]: ecpg_process_output on line 25: OK: UPDATE 1
48 [NO_PID]: sqlca: code: 0, state: 00000
49 [NO_PID]: ecpg_execute on line 26: query: update insupd_test set a = 4 where a = 3; with 0 parameter(s) on connection ecpg1_regression
50 [NO_PID]: sqlca: code: 0, state: 00000
51 [NO_PID]: ecpg_execute on line 26: using PQexec
52 [NO_PID]: sqlca: code: 0, state: 00000
53 [NO_PID]: ecpg_process_output on line 26: OK: UPDATE 1
54 [NO_PID]: sqlca: code: 0, state: 00000
55 [NO_PID]: ecpg_execute on line 28: query: select a , b from insupd_test order by a; with 0 parameter(s) on connection ecpg1_regression
56 [NO_PID]: sqlca: code: 0, state: 00000
57 [NO_PID]: ecpg_execute on line 28: using PQexec
58 [NO_PID]: sqlca: code: 0, state: 00000
59 [NO_PID]: ecpg_process_output on line 28: correctly got 3 tuples with 2 fields
60 [NO_PID]: sqlca: code: 0, state: 00000
61 [NO_PID]: ecpg_get_data on line 28: RESULT: 2 offset: -1; array: no
62 [NO_PID]: sqlca: code: 0, state: 00000
63 [NO_PID]: ecpg_get_data on line 28: RESULT: 4 offset: -1; array: no
64 [NO_PID]: sqlca: code: 0, state: 00000
65 [NO_PID]: ecpg_get_data on line 28: RESULT: 5 offset: -1; array: no
66 [NO_PID]: sqlca: code: 0, state: 00000
67 [NO_PID]: ecpg_get_data on line 28: RESULT: 1 offset: -1; array: no
68 [NO_PID]: sqlca: code: 0, state: 00000
69 [NO_PID]: ecpg_get_data on line 28: RESULT: 2 offset: -1; array: no
70 [NO_PID]: sqlca: code: 0, state: 00000
71 [NO_PID]: ecpg_get_data on line 28: RESULT: 5 offset: -1; array: no
72 [NO_PID]: sqlca: code: 0, state: 00000
73 [NO_PID]: ecpg_finish: connection ecpg1_regression closed
74 [NO_PID]: sqlca: code: 0, state: 00000