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 78: 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 78: using PQexec
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_process_output on line 78: OK: SET
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 81: query: create table a1 ( id serial primary key , t text , d1 numeric , d2 float8 , c character ( 10 ) ); with 0 parameter(s) on connection ecpg1_regression
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ecpg_execute on line 81: using PQexec
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_process_output on line 81: OK: CREATE TABLE
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 84: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , 'a' , 1.0 , 2 , 'a' ); with 0 parameter(s) on connection ecpg1_regression
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 84: using PQexec
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_process_output on line 84: OK: INSERT 0 1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 85: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , null , null , null , null ); with 0 parameter(s) on connection ecpg1_regression
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: ecpg_execute on line 85: using PQexec
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_process_output on line 85: OK: INSERT 0 1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 86: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , 'b' , 2.0 , 3 , 'b' ); with 0 parameter(s) on connection ecpg1_regression
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 86: using PQexec
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: ecpg_process_output on line 86: OK: INSERT 0 1
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ECPGtrans on line 89: action "commit"; connection "ecpg1_regression"
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ecpg_execute on line 40: query: declare mycur cursor for select * from a1; with 0 parameter(s) on connection ecpg1_regression
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_execute on line 40: using PQexec
40
[NO_PID]: sqlca: code: 0, state: 00000
41
[NO_PID]: ecpg_process_output on line 40: OK: DECLARE CURSOR
42
[NO_PID]: sqlca: code: 0, state: 00000
43
[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression
44
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ecpg_execute on line 49: using PQexec
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields
48
[NO_PID]: sqlca: code: 0, state: 00000
49
[NO_PID]: ecpg_get_data on line 49: RESULT: 1 offset: -1; array: no
50
[NO_PID]: sqlca: code: 0, state: 00000
51
[NO_PID]: ecpg_get_data on line 49: RESULT: a offset: -1; array: no
52
[NO_PID]: sqlca: code: 0, state: 00000
53
[NO_PID]: ecpg_get_data on line 49: RESULT: 1.0 offset: -1; array: no
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_get_data on line 49: RESULT: 2 offset: -1; array: no
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_get_data on line 49: RESULT: a offset: -1; array: no
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ecpg_execute on line 49: using PQexec
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_get_data on line 49: RESULT: 2 offset: -1; array: no
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ecpg_execute on line 49: using PQexec
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_get_data on line 49: RESULT: 3 offset: -1; array: no
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_get_data on line 49: RESULT: b offset: -1; array: no
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ecpg_get_data on line 49: RESULT: 2.0 offset: -1; array: no
86
[NO_PID]: sqlca: code: 0, state: 00000
87
[NO_PID]: ecpg_get_data on line 49: RESULT: 3 offset: -1; array: no
88
[NO_PID]: sqlca: code: 0, state: 00000
89
[NO_PID]: ecpg_get_data on line 49: RESULT: b offset: -1; array: no
90
[NO_PID]: sqlca: code: 0, state: 00000
91
[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression
92
[NO_PID]: sqlca: code: 0, state: 00000
93
[NO_PID]: ecpg_execute on line 49: using PQexec
94
[NO_PID]: sqlca: code: 0, state: 00000
95
[NO_PID]: ecpg_process_output on line 49: correctly got 0 tuples with 5 fields
96
[NO_PID]: sqlca: code: 0, state: 00000
97
[NO_PID]: raising sqlcode 100 on line 49: no data found on line 49
98
[NO_PID]: sqlca: code: 100, state: 02000
99
[NO_PID]: ecpg_execute on line 58: query: close mycur; with 0 parameter(s) on connection ecpg1_regression
100
[NO_PID]: sqlca: code: 0, state: 00000
101
[NO_PID]: ecpg_execute on line 58: using PQexec
102
[NO_PID]: sqlca: code: 0, state: 00000
103
[NO_PID]: ecpg_process_output on line 58: OK: CLOSE CURSOR
104
[NO_PID]: sqlca: code: 0, state: 00000
105
[NO_PID]: ecpg_execute on line 118: query: drop table a1; with 0 parameter(s) on connection ecpg1_regression
106
[NO_PID]: sqlca: code: 0, state: 00000
107
[NO_PID]: ecpg_execute on line 118: using PQexec
108
[NO_PID]: sqlca: code: 0, state: 00000
109
[NO_PID]: ecpg_process_output on line 118: OK: DROP TABLE
110
[NO_PID]: sqlca: code: 0, state: 00000
111
[NO_PID]: ECPGtrans on line 121: action "commit"; connection "ecpg1_regression"
112
[NO_PID]: sqlca: code: 0, state: 00000
113
[NO_PID]: ecpg_finish: connection ecpg1_regression closed
114
[NO_PID]: sqlca: code: 0, state: 00000