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]: ecpg_execute on line 36: query: create table empl ( idnum integer , name char ( 20 ) , accs smallint , byte bytea ); with 0 parameter(s) on connection regress1
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 36: using PQexec
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 36: OK: CREATE TABLE
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 44: query: insert into empl values ( 1 , 'first user' , 320 , $1 ); with 1 parameter(s) on connection regress1
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ecpg_execute on line 44: using PQexecParams
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: free_params on line 44: parameter 1 = \001\155\000\212
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 44: OK: INSERT 0 1
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 52: query: declare C cursor for select name , accs , byte from empl where idnum = $1 ; with 1 parameter(s) on connection regress1
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 52: using PQexecParams
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: free_params on line 52: parameter 1 = 1
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: ecpg_execute on line 52: OK: DECLARE CURSOR
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 53: query: fetch C; with 0 parameter(s) on connection regress1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 53: using PQexec
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 53: correctly got 1 tuples with 3 fields
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: ecpg_get_data on line 53: RESULT: first user offset: -1; array: yes
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ecpg_get_data on line 53: RESULT: 320 offset: -1; array: yes
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ecpg_get_data on line 53: RESULT: \001m\000\212 offset: -1; array: yes
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_execute on line 64: query: declare B binary cursor for select name , accs , byte from empl where idnum = $1 ; with 1 parameter(s) on connection regress1
40
[NO_PID]: sqlca: code: 0, state: 00000
41
[NO_PID]: ecpg_execute on line 64: using PQexecParams
42
[NO_PID]: sqlca: code: 0, state: 00000
43
[NO_PID]: free_params on line 64: parameter 1 = 1
44
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ecpg_execute on line 64: OK: DECLARE CURSOR
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ecpg_execute on line 65: query: fetch B; with 0 parameter(s) on connection regress1
48
[NO_PID]: sqlca: code: 0, state: 00000
49
[NO_PID]: ecpg_execute on line 65: using PQexec
50
[NO_PID]: sqlca: code: 0, state: 00000
51
[NO_PID]: ecpg_execute on line 65: correctly got 1 tuples with 3 fields
52
[NO_PID]: sqlca: code: 0, state: 00000
53
[NO_PID]: ecpg_get_data on line 65: RESULT: BINARY offset: -1; array: yes
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_get_data on line 65: RESULT: BINARY offset: -1; array: yes
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_get_data on line 65: RESULT: BINARY offset: -1; array: yes
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_execute on line 72: query: close B; with 0 parameter(s) on connection regress1
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ecpg_execute on line 72: using PQexec
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_execute on line 72: OK: CLOSE CURSOR
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_execute on line 81: query: declare A binary cursor for select byte from empl where idnum = $1 ; with 1 parameter(s) on connection regress1
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: ecpg_execute on line 81: using PQexecParams
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: free_params on line 81: parameter 1 = 1
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_execute on line 81: OK: DECLARE CURSOR
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_execute on line 82: query: fetch A; with 0 parameter(s) on connection regress1
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_execute on line 82: using PQexec
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ecpg_execute on line 82: correctly got 1 tuples with 1 fields
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_store_result on line 82: allocating memory for 1 tuples
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_get_data on line 82: RESULT: BINARY offset: -1; array: yes
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_execute on line 89: query: close A; with 0 parameter(s) on connection regress1
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ecpg_execute on line 89: using PQexec
86
[NO_PID]: sqlca: code: 0, state: 00000
87
[NO_PID]: ecpg_execute on line 89: OK: CLOSE CURSOR
88
[NO_PID]: sqlca: code: 0, state: 00000
89
[NO_PID]: ecpg_finish: connection regress1 closed
90
[NO_PID]: sqlca: code: 0, state: 00000