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: show standard_conforming_strings; 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: correctly got 1 tuples with 1 fields
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_get_data on line 22: RESULT: off offset: -1; array: yes
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 26: query: insert into "My_Table" values ( 1 , 'a\\\\b' ); with 0 parameter(s) on connection regress1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ECPGnoticeReceiver: nonstandard use of \\ in a string literal
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: raising sqlcode 0
26
[NO_PID]: sqlca: code: 0, state: 22P06
27
[NO_PID]: ecpg_execute on line 26: using PQexec
28
[NO_PID]: sqlca: code: 0, state: 22P06
29
[NO_PID]: ecpg_execute on line 26: OK: INSERT 0 1
30
[NO_PID]: sqlca: code: 0, state: 22P06
31
SQL error: nonstandard use of \\ in a string literal
32
[NO_PID]: ecpg_execute on line 28: query: insert into "My_Table" values ( 1 , E'a\\\\b' ); with 0 parameter(s) on connection regress1
33
[NO_PID]: sqlca: code: 0, state: 00000
34
[NO_PID]: ecpg_execute on line 28: using PQexec
35
[NO_PID]: sqlca: code: 0, state: 00000
36
[NO_PID]: ecpg_execute on line 28: OK: INSERT 0 1
37
[NO_PID]: sqlca: code: 0, state: 00000
38
[NO_PID]: ecpg_execute on line 30: query: set standard_conforming_strings to on; 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: SET
43
[NO_PID]: sqlca: code: 0, state: 00000
44
[NO_PID]: ecpg_execute on line 33: query: insert into "My_Table" values ( 2 , 'a\\\\b' ); with 0 parameter(s) on connection regress1
45
[NO_PID]: sqlca: code: 0, state: 00000
46
[NO_PID]: ecpg_execute on line 33: using PQexec
47
[NO_PID]: sqlca: code: 0, state: 00000
48
[NO_PID]: ecpg_execute on line 33: OK: INSERT 0 1
49
[NO_PID]: sqlca: code: 0, state: 00000
50
[NO_PID]: ecpg_execute on line 35: query: insert into "My_Table" values ( 2 , E'a\\\\b' ); with 0 parameter(s) on connection regress1
51
[NO_PID]: sqlca: code: 0, state: 00000
52
[NO_PID]: ecpg_execute on line 35: using PQexec
53
[NO_PID]: sqlca: code: 0, state: 00000
54
[NO_PID]: ecpg_execute on line 35: OK: INSERT 0 1
55
[NO_PID]: sqlca: code: 0, state: 00000
56
[NO_PID]: ECPGtrans on line 37: action "begin"; connection "regress1"
57
[NO_PID]: sqlca: code: 0, state: 00000
58
[NO_PID]: ecpg_execute on line 40: query: declare C cursor for select * from "My_Table"; with 0 parameter(s) on connection regress1
59
[NO_PID]: sqlca: code: 0, state: 00000
60
[NO_PID]: ecpg_execute on line 40: using PQexec
61
[NO_PID]: sqlca: code: 0, state: 00000
62
[NO_PID]: ecpg_execute on line 40: OK: DECLARE CURSOR
63
[NO_PID]: sqlca: code: 0, state: 00000
64
[NO_PID]: ecpg_execute on line 46: query: fetch C; with 0 parameter(s) on connection regress1
65
[NO_PID]: sqlca: code: 0, state: 00000
66
[NO_PID]: ecpg_execute on line 46: using PQexec
67
[NO_PID]: sqlca: code: 0, state: 00000
68
[NO_PID]: ecpg_execute on line 46: correctly got 1 tuples with 2 fields
69
[NO_PID]: sqlca: code: 0, state: 00000
70
[NO_PID]: ecpg_get_data on line 46: RESULT: 1 offset: -1; array: yes
71
[NO_PID]: sqlca: code: 0, state: 00000
72
[NO_PID]: ecpg_get_data on line 46: RESULT: a\\b offset: -1; array: yes
73
[NO_PID]: sqlca: code: 0, state: 00000
74
[NO_PID]: ecpg_execute on line 46: query: fetch C; with 0 parameter(s) on connection regress1
75
[NO_PID]: sqlca: code: 0, state: 00000
76
[NO_PID]: ecpg_execute on line 46: using PQexec
77
[NO_PID]: sqlca: code: 0, state: 00000
78
[NO_PID]: ecpg_execute on line 46: correctly got 1 tuples with 2 fields
79
[NO_PID]: sqlca: code: 0, state: 00000
80
[NO_PID]: ecpg_get_data on line 46: RESULT: 1 offset: -1; array: yes
81
[NO_PID]: sqlca: code: 0, state: 00000
82
[NO_PID]: ecpg_get_data on line 46: RESULT: a\\b offset: -1; array: yes
83
[NO_PID]: sqlca: code: 0, state: 00000
84
[NO_PID]: ecpg_execute on line 46: query: fetch C; with 0 parameter(s) on connection regress1
85
[NO_PID]: sqlca: code: 0, state: 00000
86
[NO_PID]: ecpg_execute on line 46: using PQexec
87
[NO_PID]: sqlca: code: 0, state: 00000
88
[NO_PID]: ecpg_execute on line 46: correctly got 1 tuples with 2 fields
89
[NO_PID]: sqlca: code: 0, state: 00000
90
[NO_PID]: ecpg_get_data on line 46: RESULT: 2 offset: -1; array: yes
91
[NO_PID]: sqlca: code: 0, state: 00000
92
[NO_PID]: ecpg_get_data on line 46: RESULT: a\\\\b offset: -1; array: yes
93
[NO_PID]: sqlca: code: 0, state: 00000
94
[NO_PID]: ecpg_execute on line 46: query: fetch C; with 0 parameter(s) on connection regress1
95
[NO_PID]: sqlca: code: 0, state: 00000
96
[NO_PID]: ecpg_execute on line 46: using PQexec
97
[NO_PID]: sqlca: code: 0, state: 00000
98
[NO_PID]: ecpg_execute on line 46: correctly got 1 tuples with 2 fields
99
[NO_PID]: sqlca: code: 0, state: 00000
100
[NO_PID]: ecpg_get_data on line 46: RESULT: 2 offset: -1; array: yes
101
[NO_PID]: sqlca: code: 0, state: 00000
102
[NO_PID]: ecpg_get_data on line 46: RESULT: a\\b offset: -1; array: yes
103
[NO_PID]: sqlca: code: 0, state: 00000
104
[NO_PID]: ecpg_execute on line 46: query: fetch C; with 0 parameter(s) on connection regress1
105
[NO_PID]: sqlca: code: 0, state: 00000
106
[NO_PID]: ecpg_execute on line 46: using PQexec
107
[NO_PID]: sqlca: code: 0, state: 00000
108
[NO_PID]: ecpg_execute on line 46: correctly got 0 tuples with 2 fields
109
[NO_PID]: sqlca: code: 0, state: 00000
110
[NO_PID]: raising sqlcode 100 on line 46: no data found on line 46
111
[NO_PID]: sqlca: code: 100, state: 02000
112
[NO_PID]: ECPGtrans on line 50: action "rollback"; connection "regress1"
113
[NO_PID]: sqlca: code: 0, state: 00000
114
[NO_PID]: ecpg_execute on line 51: query: drop table "My_Table"; with 0 parameter(s) on connection regress1
115
[NO_PID]: sqlca: code: 0, state: 00000
116
[NO_PID]: ecpg_execute on line 51: using PQexec
117
[NO_PID]: sqlca: code: 0, state: 00000
118
[NO_PID]: ecpg_execute on line 51: OK: DROP TABLE
119
[NO_PID]: sqlca: code: 0, state: 00000
120
[NO_PID]: ecpg_finish: connection regress1 closed
121
[NO_PID]: sqlca: code: 0, state: 00000