1connected
2
3-- TEST using SQLExecute after SQLPrepare
4
5Query: SELECT {fn CONCAT(?, ?) }
6Param 1: foo
7Param 2: bar
8Result set:
9foobar
10
11Query: SELECT {fn LOCATE(?, ?, 2) }
12Param 1: needle
13Param 2: this is a needle in an ol' haystack
14Result set:
1511
16
17Query: SELECT {fn LOCATE({fn SUBSTRING(?, 2, 4)}, {fn SUBSTRING(?, 3)}, 3) }
18Param 1: needle
19Param 2: this is a needle in an ol' haystack
20Result set:
2110
22
23Query: SELECT 'x' || {fn SPACE(10) } || 'x'
24Result set:
25x          x
26
27Query: { call length(?) }
28Param 1: foobar
29Result set:
306
31
32Query: { call right(?, ?) }
33Param 1: foobar
34Param 2: 3
35Result set:
36bar
37
38Query: { ? = call length('foo') }
39Param 1 is an OUT parameter
40Result set:
41
42OUT param: 3
43
44Query: { ? = call concat(?::text, ?::text) }
45Param 1 is an OUT parameter
46Param 2: foo
47Param 3: bar
48Result set:
49
50OUT param: foobar
51
52Query: SELECT {d '2014-12-21' } + '1 day'::interval
53Result set:
542014-12-22 00:00:00
55
56Query: SELECT {t '20:30:40' } + '1 hour 1 minute 1 second'::interval
57Result set:
5821:31:41
59
60Query: SELECT {ts '2014-12-21 20:30:40' } + '1 day 1 hour 1 minute 1 second'::interval
61Result set:
622014-12-22 21:31:41
63
64Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
65Param 1 is an OUT parameter
66Param 2: 2017-02-23 11:34:46
67Param 3 is an I-O parameter
68Param 4: 3.4
69Param 5 is an OUT parameter
70Result set:
716.7999999999999998	7	2017-02-24 11:34:46
72OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
73
74Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
75Param 1 (e) is an OUT parameter
76Param 2 (a) is an OUT parameter
77Param 3 (b): 2017-02-23 11:34:46
78Param 4 (c) is an I-O parameter
79Param 5 (d): 3.4
80Result set:
816.7999999999999998	7	2017-02-24 11:34:46
82OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
83
84Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
85Param 1 (b): 2017-02-23 11:34:46
86Param 2 (c) is an I-O parameter
87Param 3 (d): 3.4
88Param 4 (e) is an OUT parameter
89Param 5 (a) is an OUT parameter
90Result set:
916.7999999999999998	7	2017-02-24 11:34:46
92OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
93
94-- TEST using SQLExecDirect
95
96Query: SELECT {fn CONCAT(?, ?) }
97Param 1: foo
98Param 2: bar
99Result set:
100foobar
101
102Query: SELECT {fn LOCATE(?, ?, 2) }
103Param 1: needle
104Param 2: this is a needle in an ol' haystack
105Result set:
10611
107
108Query: SELECT {fn LOCATE({fn SUBSTRING(?, 2, 4)}, {fn SUBSTRING(?, 3)}, 3) }
109Param 1: needle
110Param 2: this is a needle in an ol' haystack
111Result set:
11210
113
114Query: SELECT 'x' || {fn SPACE(10) } || 'x'
115Result set:
116x          x
117
118Query: { call length(?) }
119Param 1: foobar
120Result set:
1216
122
123Query: { call right(?, ?) }
124Param 1: foobar
125Param 2: 3
126Result set:
127bar
128
129Query: { ? = call length('foo') }
130Param 1 is an OUT parameter
131Result set:
132
133OUT param: 3
134
135Query: { ? = call concat(?::text, ?::text) }
136Param 1 is an OUT parameter
137Param 2: foo
138Param 3: bar
139Result set:
140
141OUT param: foobar
142
143Query: SELECT {d '2014-12-21' } + '1 day'::interval
144Result set:
1452014-12-22 00:00:00
146
147Query: SELECT {t '20:30:40' } + '1 hour 1 minute 1 second'::interval
148Result set:
14921:31:41
150
151Query: SELECT {ts '2014-12-21 20:30:40' } + '1 day 1 hour 1 minute 1 second'::interval
152Result set:
1532014-12-22 21:31:41
154
155Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
156Param 1 is an OUT parameter
157Param 2: 2017-02-23 11:34:46
158Param 3 is an I-O parameter
159Param 4: 3.4
160Param 5 is an OUT parameter
161Result set:
1626.7999999999999998	7	2017-02-24 11:34:46
163OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
164
165Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
166Param 1 (e) is an OUT parameter
167Param 2 (a) is an OUT parameter
168Param 3 (b): 2017-02-23 11:34:46
169Param 4 (c) is an I-O parameter
170Param 5 (d): 3.4
171Result set:
1726.7999999999999998	7	2017-02-24 11:34:46
173OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
174
175Query: {call a_b_c_d_e(?, ?, ?, ?, ?)}
176Param 1 (b): 2017-02-23 11:34:46
177Param 2 (c) is an I-O parameter
178Param 3 (d): 3.4
179Param 4 (e) is an OUT parameter
180Param 5 (a) is an OUT parameter
181Result set:
1826.7999999999999998	7	2017-02-24 11:34:46
183OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46
184disconnecting
185