1
[NO_PID]: ECPGdebug: set to 1
2
[NO_PID]: sqlca: code: 0, state: 00000
3
[NO_PID]: ECPGconnect: opening database regress1 on <DEFAULT> port <DEFAULT>
4
[NO_PID]: sqlca: code: 0, state: 00000
5
[NO_PID]: ECPGsetcommit on line 16: action "on"; connection "regress1"
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 20: query: create table "My_Table" ( Item1 int , Item2 text ); with 0 parameter(s) on connection regress1
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 20: using PQexec
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 20: OK: CREATE TABLE
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ecpg_execute on line 22: query: set standard_conforming_strings to off; with 0 parameter(s) on connection regress1
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_execute on line 22: using PQexec
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 22: OK: SET
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 24: query: show standard_conforming_strings; with 0 parameter(s) on connection regress1
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 24: using PQexec
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 24: correctly got 1 tuples with 1 fields
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: ecpg_get_data on line 24: RESULT: off offset: -1; array: no
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 28: query: insert into "My_Table" values ( 1 , 'a\\\\b' ); with 0 parameter(s) on connection regress1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ECPGnoticeReceiver: nonstandard use of \\ in a string literal
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: raising sqlcode 0
32
[NO_PID]: sqlca: code: 0, state: 22P06
33
[NO_PID]: ecpg_execute on line 28: using PQexec
34
[NO_PID]: sqlca: code: 0, state: 22P06
35
[NO_PID]: ecpg_execute on line 28: OK: INSERT 0 1
36
[NO_PID]: sqlca: code: 0, state: 22P06
37
SQL error: nonstandard use of \\ in a string literal
38
[NO_PID]: ecpg_execute on line 30: query: insert into "My_Table" values ( 1 , E'a\\\\b' ); with 0 parameter(s) on connection regress1
39
[NO_PID]: sqlca: code: 0, state: 00000
40
[NO_PID]: ecpg_execute on line 30: using PQexec
41
[NO_PID]: sqlca: code: 0, state: 00000
42
[NO_PID]: ecpg_execute on line 30: OK: INSERT 0 1
43
[NO_PID]: sqlca: code: 0, state: 00000
44
[NO_PID]: ecpg_execute on line 32: query: set standard_conforming_strings to on; with 0 parameter(s) on connection regress1
45
[NO_PID]: sqlca: code: 0, state: 00000
46
[NO_PID]: ecpg_execute on line 32: using PQexec
47
[NO_PID]: sqlca: code: 0, state: 00000
48
[NO_PID]: ecpg_execute on line 32: OK: SET
49
[NO_PID]: sqlca: code: 0, state: 00000
50
[NO_PID]: ecpg_execute on line 34: query: show standard_conforming_strings; with 0 parameter(s) on connection regress1
51
[NO_PID]: sqlca: code: 0, state: 00000
52
[NO_PID]: ecpg_execute on line 34: using PQexec
53
[NO_PID]: sqlca: code: 0, state: 00000
54
[NO_PID]: ecpg_execute on line 34: correctly got 1 tuples with 1 fields
55
[NO_PID]: sqlca: code: 0, state: 00000
56
[NO_PID]: ecpg_get_data on line 34: RESULT: on offset: -1; array: no
57
[NO_PID]: sqlca: code: 0, state: 00000
58
[NO_PID]: ecpg_execute on line 38: query: insert into "My_Table" values ( 2 , 'a\\\\b' ); with 0 parameter(s) on connection regress1
59
[NO_PID]: sqlca: code: 0, state: 00000
60
[NO_PID]: ecpg_execute on line 38: using PQexec
61
[NO_PID]: sqlca: code: 0, state: 00000
62
[NO_PID]: ecpg_execute on line 38: OK: INSERT 0 1
63
[NO_PID]: sqlca: code: 0, state: 00000
64
[NO_PID]: ecpg_execute on line 40: query: insert into "My_Table" values ( 2 , E'a\\\\b' ); with 0 parameter(s) on connection regress1
65
[NO_PID]: sqlca: code: 0, state: 00000
66
[NO_PID]: ecpg_execute on line 40: using PQexec
67
[NO_PID]: sqlca: code: 0, state: 00000
68
[NO_PID]: ecpg_execute on line 40: OK: INSERT 0 1
69
[NO_PID]: sqlca: code: 0, state: 00000
70
[NO_PID]: ECPGtrans on line 42: action "begin"; connection "regress1"
71
[NO_PID]: sqlca: code: 0, state: 00000
72
[NO_PID]: ecpg_execute on line 45: query: declare C cursor for select * from "My_Table"; with 0 parameter(s) on connection regress1
73
[NO_PID]: sqlca: code: 0, state: 00000
74
[NO_PID]: ecpg_execute on line 45: using PQexec
75
[NO_PID]: sqlca: code: 0, state: 00000
76
[NO_PID]: ecpg_execute on line 45: OK: DECLARE CURSOR
77
[NO_PID]: sqlca: code: 0, state: 00000
78
[NO_PID]: ecpg_execute on line 51: query: fetch C; with 0 parameter(s) on connection regress1
79
[NO_PID]: sqlca: code: 0, state: 00000
80
[NO_PID]: ecpg_execute on line 51: using PQexec
81
[NO_PID]: sqlca: code: 0, state: 00000
82
[NO_PID]: ecpg_execute on line 51: correctly got 1 tuples with 2 fields
83
[NO_PID]: sqlca: code: 0, state: 00000
84
[NO_PID]: ecpg_get_data on line 51: RESULT: 1 offset: -1; array: no
85
[NO_PID]: sqlca: code: 0, state: 00000
86
[NO_PID]: ecpg_get_data on line 51: RESULT: a\\b offset: -1; array: no
87
[NO_PID]: sqlca: code: 0, state: 00000
88
[NO_PID]: ecpg_execute on line 51: query: fetch C; with 0 parameter(s) on connection regress1
89
[NO_PID]: sqlca: code: 0, state: 00000
90
[NO_PID]: ecpg_execute on line 51: using PQexec
91
[NO_PID]: sqlca: code: 0, state: 00000
92
[NO_PID]: ecpg_execute on line 51: correctly got 1 tuples with 2 fields
93
[NO_PID]: sqlca: code: 0, state: 00000
94
[NO_PID]: ecpg_get_data on line 51: RESULT: 1 offset: -1; array: no
95
[NO_PID]: sqlca: code: 0, state: 00000
96
[NO_PID]: ecpg_get_data on line 51: RESULT: a\\b offset: -1; array: no
97
[NO_PID]: sqlca: code: 0, state: 00000
98
[NO_PID]: ecpg_execute on line 51: query: fetch C; with 0 parameter(s) on connection regress1
99
[NO_PID]: sqlca: code: 0, state: 00000
100
[NO_PID]: ecpg_execute on line 51: using PQexec
101
[NO_PID]: sqlca: code: 0, state: 00000
102
[NO_PID]: ecpg_execute on line 51: correctly got 1 tuples with 2 fields
103
[NO_PID]: sqlca: code: 0, state: 00000
104
[NO_PID]: ecpg_get_data on line 51: RESULT: 2 offset: -1; array: no
105
[NO_PID]: sqlca: code: 0, state: 00000
106
[NO_PID]: ecpg_get_data on line 51: RESULT: a\\\\b offset: -1; array: no
107
[NO_PID]: sqlca: code: 0, state: 00000
108
[NO_PID]: ecpg_execute on line 51: query: fetch C; with 0 parameter(s) on connection regress1
109
[NO_PID]: sqlca: code: 0, state: 00000
110
[NO_PID]: ecpg_execute on line 51: using PQexec
111
[NO_PID]: sqlca: code: 0, state: 00000
112
[NO_PID]: ecpg_execute on line 51: correctly got 1 tuples with 2 fields
113
[NO_PID]: sqlca: code: 0, state: 00000
114
[NO_PID]: ecpg_get_data on line 51: RESULT: 2 offset: -1; array: no
115
[NO_PID]: sqlca: code: 0, state: 00000
116
[NO_PID]: ecpg_get_data on line 51: RESULT: a\\b offset: -1; array: no
117
[NO_PID]: sqlca: code: 0, state: 00000
118
[NO_PID]: ecpg_execute on line 51: query: fetch C; with 0 parameter(s) on connection regress1
119
[NO_PID]: sqlca: code: 0, state: 00000
120
[NO_PID]: ecpg_execute on line 51: using PQexec
121
[NO_PID]: sqlca: code: 0, state: 00000
122
[NO_PID]: ecpg_execute on line 51: correctly got 0 tuples with 2 fields
123
[NO_PID]: sqlca: code: 0, state: 00000
124
[NO_PID]: raising sqlcode 100 on line 51: no data found on line 51
125
[NO_PID]: sqlca: code: 100, state: 02000
126
[NO_PID]: ECPGtrans on line 55: action "rollback"; connection "regress1"
127
[NO_PID]: sqlca: code: 0, state: 00000
128
[NO_PID]: ecpg_execute on line 56: query: drop table "My_Table"; with 0 parameter(s) on connection regress1
129
[NO_PID]: sqlca: code: 0, state: 00000
130
[NO_PID]: ecpg_execute on line 56: using PQexec
131
[NO_PID]: sqlca: code: 0, state: 00000
132
[NO_PID]: ecpg_execute on line 56: OK: DROP TABLE
133
[NO_PID]: sqlca: code: 0, state: 00000
134
[NO_PID]: ecpg_finish: connection regress1 closed
135
[NO_PID]: sqlca: code: 0, state: 00000