2
2
[NO_PID]: sqlca: code: 0, state: 00000
3
3
[NO_PID]: ECPGconnect: opening database regress1 on <DEFAULT> port <DEFAULT>
4
4
[NO_PID]: sqlca: code: 0, state: 00000
5
[NO_PID]: ECPGsetcommit on line 17: action "off"; connection "regress1"
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 19: query: create table indicator_test ( "id" int primary key , "str" text not null , val int null ); with 0 parameter(s) on connection regress1
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 19: using PQexec
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 19: OK: CREATE TABLE
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ECPGtrans on line 23: action "commit work"; connection "regress1"
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_execute on line 25: query: insert into indicator_test ( id , str , val ) values ( 1 , 'Hello' , 0 ); with 0 parameter(s) on connection regress1
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 25: using PQexec
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 25: OK: INSERT 0 1
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 28: query: insert into indicator_test ( id , str , val ) values ( 2 , 'Hi there' , $1 ); with 1 parameter(s) on connection regress1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 28: using PQexecParams
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: free_params on line 28: parameter 1 = null
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 28: OK: INSERT 0 1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 30: query: insert into indicator_test ( id , str , val ) values ( 3 , 'Good evening' , $1 ); with 1 parameter(s) on connection regress1
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 30: using PQexecParams
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: free_params on line 30: parameter 1 = 5
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ecpg_execute on line 30: OK: INSERT 0 1
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ECPGtrans on line 31: action "commit work"; connection "regress1"
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_execute on line 34: query: select val from indicator_test where id = 1; with 0 parameter(s) on connection regress1
5
[NO_PID]: ECPGsetcommit on line 16: action "off"; connection "regress1"
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 18: query: create table indicator_test ( "id" int primary key , "str" text not null , val int null ); with 0 parameter(s) on connection regress1
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 18: using PQexec
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 18: OK: CREATE TABLE
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ECPGtrans on line 22: action "commit work"; connection "regress1"
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_execute on line 24: query: insert into indicator_test ( id , str , val ) values ( 1 , 'Hello' , 0 ); with 0 parameter(s) on connection regress1
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 24: using PQexec
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 24: OK: INSERT 0 1
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 27: query: insert into indicator_test ( id , str , val ) values ( 2 , 'Hi there' , $1 ); with 1 parameter(s) on connection regress1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 27: using PQexecParams
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: free_params on line 27: parameter 1 = null
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 27: OK: INSERT 0 1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 29: query: insert into indicator_test ( id , str , val ) values ( 3 , 'Good evening' , $1 ); with 1 parameter(s) on connection regress1
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 29: using PQexecParams
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: free_params on line 29: parameter 1 = 5
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ecpg_execute on line 29: OK: INSERT 0 1
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ECPGtrans on line 30: action "commit work"; connection "regress1"
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_execute on line 33: query: select val from indicator_test where id = 1; with 0 parameter(s) on connection regress1
40
[NO_PID]: sqlca: code: 0, state: 00000
41
[NO_PID]: ecpg_execute on line 33: using PQexec
42
[NO_PID]: sqlca: code: 0, state: 00000
43
[NO_PID]: ecpg_execute on line 33: correctly got 1 tuples with 1 fields
44
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ecpg_get_data on line 33: RESULT: 0 offset: -1; array: yes
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ecpg_execute on line 34: query: select val from indicator_test where id = 2; with 0 parameter(s) on connection regress1
40
48
[NO_PID]: sqlca: code: 0, state: 00000
41
49
[NO_PID]: ecpg_execute on line 34: using PQexec
42
50
[NO_PID]: sqlca: code: 0, state: 00000
43
51
[NO_PID]: ecpg_execute on line 34: correctly got 1 tuples with 1 fields
44
52
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ecpg_get_data on line 34: RESULT: 0 offset: -1; array: yes
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ecpg_execute on line 35: query: select val from indicator_test where id = 2; with 0 parameter(s) on connection regress1
48
[NO_PID]: sqlca: code: 0, state: 00000
49
[NO_PID]: ecpg_execute on line 35: using PQexec
50
[NO_PID]: sqlca: code: 0, state: 00000
51
[NO_PID]: ecpg_execute on line 35: correctly got 1 tuples with 1 fields
52
[NO_PID]: sqlca: code: 0, state: 00000
53
[NO_PID]: ecpg_get_data on line 35: RESULT: offset: -1; array: yes
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_execute on line 37: query: select val from indicator_test where id = 3; with 0 parameter(s) on connection regress1
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_execute on line 37: using PQexec
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_execute on line 37: correctly got 1 tuples with 1 fields
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ecpg_get_data on line 37: RESULT: 5 offset: -1; array: yes
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_execute on line 42: query: update indicator_test set val = $1 where id = 1; with 1 parameter(s) on connection regress1
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_execute on line 42: using PQexecParams
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: free_params on line 42: parameter 1 = null
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: ecpg_execute on line 42: OK: UPDATE 1
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_execute on line 43: query: select val from indicator_test where id = 1; with 0 parameter(s) on connection regress1
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_execute on line 43: using PQexec
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_execute on line 43: correctly got 1 tuples with 1 fields
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ecpg_get_data on line 43: RESULT: offset: -1; array: yes
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_execute on line 46: query: drop table indicator_test; with 0 parameter(s) on connection regress1
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_execute on line 46: using PQexec
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_execute on line 46: OK: DROP TABLE
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ECPGtrans on line 47: action "commit work"; connection "regress1"
53
[NO_PID]: ecpg_get_data on line 34: RESULT: offset: -1; array: yes
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_execute on line 36: query: select val from indicator_test where id = 3; with 0 parameter(s) on connection regress1
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_execute on line 36: using PQexec
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_execute on line 36: correctly got 1 tuples with 1 fields
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ecpg_get_data on line 36: RESULT: 5 offset: -1; array: yes
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_execute on line 41: query: update indicator_test set val = $1 where id = 1; with 1 parameter(s) on connection regress1
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_execute on line 41: using PQexecParams
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: free_params on line 41: parameter 1 = null
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: ecpg_execute on line 41: OK: UPDATE 1
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_execute on line 42: query: select val from indicator_test where id = 1; with 0 parameter(s) on connection regress1
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_execute on line 42: using PQexec
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_execute on line 42: correctly got 1 tuples with 1 fields
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ecpg_get_data on line 42: RESULT: offset: -1; array: yes
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_execute on line 45: query: drop table indicator_test; with 0 parameter(s) on connection regress1
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_execute on line 45: using PQexec
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_execute on line 45: OK: DROP TABLE
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ECPGtrans on line 46: action "commit work"; connection "regress1"
86
86
[NO_PID]: sqlca: code: 0, state: 00000
87
87
[NO_PID]: ecpg_finish: connection regress1 closed
88
88
[NO_PID]: sqlca: code: 0, state: 00000