|
sl@0
|
1 |
# 2003 September 6
|
|
sl@0
|
2 |
#
|
|
sl@0
|
3 |
# Portions Copyright (c) 2007-2008 Nokia Corporation and/or its subsidiaries. All rights reserved.
|
|
sl@0
|
4 |
#
|
|
sl@0
|
5 |
# The author disclaims copyright to this source code. In place of
|
|
sl@0
|
6 |
# a legal notice, here is a blessing:
|
|
sl@0
|
7 |
#
|
|
sl@0
|
8 |
# May you do good and not evil.
|
|
sl@0
|
9 |
# May you find forgiveness for yourself and forgive others.
|
|
sl@0
|
10 |
# May you share freely, never taking more than you give.
|
|
sl@0
|
11 |
#
|
|
sl@0
|
12 |
#***********************************************************************
|
|
sl@0
|
13 |
# This file implements regression tests for SQLite library. The
|
|
sl@0
|
14 |
# focus of this script testing the sqlite_bind API.
|
|
sl@0
|
15 |
#
|
|
sl@0
|
16 |
# $Id: bind.test,v 1.44 2008/07/09 01:39:44 drh Exp $
|
|
sl@0
|
17 |
#
|
|
sl@0
|
18 |
|
|
sl@0
|
19 |
set testdir [file dirname $argv0]
|
|
sl@0
|
20 |
source $testdir/tester.tcl
|
|
sl@0
|
21 |
|
|
sl@0
|
22 |
proc sqlite_step {stmt N VALS COLS} {
|
|
sl@0
|
23 |
upvar VALS vals
|
|
sl@0
|
24 |
upvar COLS cols
|
|
sl@0
|
25 |
set vals [list]
|
|
sl@0
|
26 |
set cols [list]
|
|
sl@0
|
27 |
|
|
sl@0
|
28 |
set rc [sqlite3_step $stmt]
|
|
sl@0
|
29 |
for {set i 0} {$i < [sqlite3_column_count $stmt]} {incr i} {
|
|
sl@0
|
30 |
lappend cols [sqlite3_column_name $stmt $i]
|
|
sl@0
|
31 |
}
|
|
sl@0
|
32 |
for {set i 0} {$i < [sqlite3_data_count $stmt]} {incr i} {
|
|
sl@0
|
33 |
lappend vals [sqlite3_column_text $stmt $i]
|
|
sl@0
|
34 |
}
|
|
sl@0
|
35 |
|
|
sl@0
|
36 |
return $rc
|
|
sl@0
|
37 |
}
|
|
sl@0
|
38 |
|
|
sl@0
|
39 |
do_test bind-1.1 {
|
|
sl@0
|
40 |
set DB [sqlite3_connection_pointer db]
|
|
sl@0
|
41 |
execsql {CREATE TABLE t1(a,b,c);}
|
|
sl@0
|
42 |
set VM [sqlite3_prepare $DB {INSERT INTO t1 VALUES(:1,?,:abc)} -1 TAIL]
|
|
sl@0
|
43 |
set TAIL
|
|
sl@0
|
44 |
} {}
|
|
sl@0
|
45 |
do_test bind-1.1.1 {
|
|
sl@0
|
46 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
47 |
} 3
|
|
sl@0
|
48 |
do_test bind-1.1.2 {
|
|
sl@0
|
49 |
sqlite3_bind_parameter_name $VM 1
|
|
sl@0
|
50 |
} {:1}
|
|
sl@0
|
51 |
do_test bind-1.1.3 {
|
|
sl@0
|
52 |
sqlite3_bind_parameter_name $VM 2
|
|
sl@0
|
53 |
} {}
|
|
sl@0
|
54 |
do_test bind-1.1.4 {
|
|
sl@0
|
55 |
sqlite3_bind_parameter_name $VM 3
|
|
sl@0
|
56 |
} {:abc}
|
|
sl@0
|
57 |
do_test bind-1.2 {
|
|
sl@0
|
58 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
59 |
} {SQLITE_DONE}
|
|
sl@0
|
60 |
do_test bind-1.3 {
|
|
sl@0
|
61 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
62 |
} {1 {} {} {}}
|
|
sl@0
|
63 |
do_test bind-1.4 {
|
|
sl@0
|
64 |
sqlite3_reset $VM
|
|
sl@0
|
65 |
sqlite_bind $VM 1 {test value 1} normal
|
|
sl@0
|
66 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
67 |
} SQLITE_DONE
|
|
sl@0
|
68 |
do_test bind-1.5 {
|
|
sl@0
|
69 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
70 |
} {1 {} {} {} 2 {test value 1} {} {}}
|
|
sl@0
|
71 |
do_test bind-1.6 {
|
|
sl@0
|
72 |
sqlite3_reset $VM
|
|
sl@0
|
73 |
sqlite_bind $VM 3 {'test value 2'} normal
|
|
sl@0
|
74 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
75 |
} SQLITE_DONE
|
|
sl@0
|
76 |
do_test bind-1.7 {
|
|
sl@0
|
77 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
78 |
} {1 {} {} {} 2 {test value 1} {} {} 3 {test value 1} {} {'test value 2'}}
|
|
sl@0
|
79 |
do_test bind-1.8 {
|
|
sl@0
|
80 |
sqlite3_reset $VM
|
|
sl@0
|
81 |
set sqlite_static_bind_value 123
|
|
sl@0
|
82 |
sqlite_bind $VM 1 {} static
|
|
sl@0
|
83 |
sqlite_bind $VM 2 {abcdefg} normal
|
|
sl@0
|
84 |
sqlite_bind $VM 3 {} null
|
|
sl@0
|
85 |
execsql {DELETE FROM t1}
|
|
sl@0
|
86 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
87 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
88 |
} {1 123 abcdefg {}}
|
|
sl@0
|
89 |
do_test bind-1.9 {
|
|
sl@0
|
90 |
sqlite3_reset $VM
|
|
sl@0
|
91 |
sqlite_bind $VM 1 {456} normal
|
|
sl@0
|
92 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
93 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
94 |
} {1 123 abcdefg {} 2 456 abcdefg {}}
|
|
sl@0
|
95 |
|
|
sl@0
|
96 |
do_test bind-1.10 {
|
|
sl@0
|
97 |
set rc [catch {
|
|
sl@0
|
98 |
sqlite3_prepare db {INSERT INTO t1 VALUES($abc:123,?,:abc)} -1 TAIL
|
|
sl@0
|
99 |
} msg]
|
|
sl@0
|
100 |
lappend rc $msg
|
|
sl@0
|
101 |
} {1 {(1) near ":123": syntax error}}
|
|
sl@0
|
102 |
do_test bind-1.11 {
|
|
sl@0
|
103 |
set rc [catch {
|
|
sl@0
|
104 |
sqlite3_prepare db {INSERT INTO t1 VALUES(@abc:xyz,?,:abc)} -1 TAIL
|
|
sl@0
|
105 |
} msg]
|
|
sl@0
|
106 |
lappend rc $msg
|
|
sl@0
|
107 |
} {1 {(1) near ":xyz": syntax error}}
|
|
sl@0
|
108 |
|
|
sl@0
|
109 |
do_test bind-1.99 {
|
|
sl@0
|
110 |
sqlite3_finalize $VM
|
|
sl@0
|
111 |
} SQLITE_OK
|
|
sl@0
|
112 |
|
|
sl@0
|
113 |
# Prepare the statement in different ways depending on whether or not
|
|
sl@0
|
114 |
# the $var processing is compiled into the library.
|
|
sl@0
|
115 |
#
|
|
sl@0
|
116 |
ifcapable {tclvar} {
|
|
sl@0
|
117 |
do_test bind-2.1 {
|
|
sl@0
|
118 |
execsql {
|
|
sl@0
|
119 |
DELETE FROM t1;
|
|
sl@0
|
120 |
}
|
|
sl@0
|
121 |
set VM [sqlite3_prepare $DB {INSERT INTO t1 VALUES($one,$::two,$x(-z-))}\
|
|
sl@0
|
122 |
-1 TX]
|
|
sl@0
|
123 |
set TX
|
|
sl@0
|
124 |
} {}
|
|
sl@0
|
125 |
set v1 {$one}
|
|
sl@0
|
126 |
set v2 {$::two}
|
|
sl@0
|
127 |
set v3 {$x(-z-)}
|
|
sl@0
|
128 |
}
|
|
sl@0
|
129 |
ifcapable {!tclvar} {
|
|
sl@0
|
130 |
do_test bind-2.1 {
|
|
sl@0
|
131 |
execsql {
|
|
sl@0
|
132 |
DELETE FROM t1;
|
|
sl@0
|
133 |
}
|
|
sl@0
|
134 |
set VM [sqlite3_prepare $DB {INSERT INTO t1 VALUES(:one,:two,:_)} -1 TX]
|
|
sl@0
|
135 |
set TX
|
|
sl@0
|
136 |
} {}
|
|
sl@0
|
137 |
set v1 {:one}
|
|
sl@0
|
138 |
set v2 {:two}
|
|
sl@0
|
139 |
set v3 {:_}
|
|
sl@0
|
140 |
}
|
|
sl@0
|
141 |
|
|
sl@0
|
142 |
do_test bind-2.1.1 {
|
|
sl@0
|
143 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
144 |
} 3
|
|
sl@0
|
145 |
do_test bind-2.1.2 {
|
|
sl@0
|
146 |
sqlite3_bind_parameter_name $VM 1
|
|
sl@0
|
147 |
} $v1
|
|
sl@0
|
148 |
do_test bind-2.1.3 {
|
|
sl@0
|
149 |
sqlite3_bind_parameter_name $VM 2
|
|
sl@0
|
150 |
} $v2
|
|
sl@0
|
151 |
do_test bind-2.1.4 {
|
|
sl@0
|
152 |
sqlite3_bind_parameter_name $VM 3
|
|
sl@0
|
153 |
} $v3
|
|
sl@0
|
154 |
do_test bind-2.1.5 {
|
|
sl@0
|
155 |
sqlite3_bind_parameter_index $VM $v1
|
|
sl@0
|
156 |
} 1
|
|
sl@0
|
157 |
do_test bind-2.1.6 {
|
|
sl@0
|
158 |
sqlite3_bind_parameter_index $VM $v2
|
|
sl@0
|
159 |
} 2
|
|
sl@0
|
160 |
do_test bind-2.1.7 {
|
|
sl@0
|
161 |
sqlite3_bind_parameter_index $VM $v3
|
|
sl@0
|
162 |
} 3
|
|
sl@0
|
163 |
do_test bind-2.1.8 {
|
|
sl@0
|
164 |
sqlite3_bind_parameter_index $VM {:hi}
|
|
sl@0
|
165 |
} 0
|
|
sl@0
|
166 |
|
|
sl@0
|
167 |
# 32 bit Integers
|
|
sl@0
|
168 |
do_test bind-2.2 {
|
|
sl@0
|
169 |
sqlite3_bind_int $VM 1 123
|
|
sl@0
|
170 |
sqlite3_bind_int $VM 2 456
|
|
sl@0
|
171 |
sqlite3_bind_int $VM 3 789
|
|
sl@0
|
172 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
173 |
sqlite3_reset $VM
|
|
sl@0
|
174 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
175 |
} {1 123 456 789}
|
|
sl@0
|
176 |
do_test bind-2.3 {
|
|
sl@0
|
177 |
sqlite3_bind_int $VM 2 -2000000000
|
|
sl@0
|
178 |
sqlite3_bind_int $VM 3 2000000000
|
|
sl@0
|
179 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
180 |
sqlite3_reset $VM
|
|
sl@0
|
181 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
182 |
} {1 123 456 789 2 123 -2000000000 2000000000}
|
|
sl@0
|
183 |
do_test bind-2.4 {
|
|
sl@0
|
184 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
185 |
} {integer integer integer integer integer integer}
|
|
sl@0
|
186 |
do_test bind-2.5 {
|
|
sl@0
|
187 |
execsql {
|
|
sl@0
|
188 |
DELETE FROM t1;
|
|
sl@0
|
189 |
}
|
|
sl@0
|
190 |
} {}
|
|
sl@0
|
191 |
|
|
sl@0
|
192 |
# 64 bit Integers
|
|
sl@0
|
193 |
do_test bind-3.1 {
|
|
sl@0
|
194 |
sqlite3_bind_int64 $VM 1 32
|
|
sl@0
|
195 |
sqlite3_bind_int64 $VM 2 -2000000000000
|
|
sl@0
|
196 |
sqlite3_bind_int64 $VM 3 2000000000000
|
|
sl@0
|
197 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
198 |
sqlite3_reset $VM
|
|
sl@0
|
199 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
200 |
} {1 32 -2000000000000 2000000000000}
|
|
sl@0
|
201 |
do_test bind-3.2 {
|
|
sl@0
|
202 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
203 |
} {integer integer integer}
|
|
sl@0
|
204 |
do_test bind-3.3 {
|
|
sl@0
|
205 |
execsql {
|
|
sl@0
|
206 |
DELETE FROM t1;
|
|
sl@0
|
207 |
}
|
|
sl@0
|
208 |
} {}
|
|
sl@0
|
209 |
|
|
sl@0
|
210 |
# Doubles
|
|
sl@0
|
211 |
do_test bind-4.1 {
|
|
sl@0
|
212 |
sqlite3_bind_double $VM 1 1234.1234
|
|
sl@0
|
213 |
sqlite3_bind_double $VM 2 0.00001
|
|
sl@0
|
214 |
sqlite3_bind_double $VM 3 123456789
|
|
sl@0
|
215 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
216 |
sqlite3_reset $VM
|
|
sl@0
|
217 |
set x [execsql {SELECT rowid, * FROM t1}]
|
|
sl@0
|
218 |
regsub {1e-005} $x {1e-05} y
|
|
sl@0
|
219 |
set y
|
|
sl@0
|
220 |
} {1 1234.1234 1e-05 123456789.0}
|
|
sl@0
|
221 |
do_test bind-4.2 {
|
|
sl@0
|
222 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
223 |
} {real real real}
|
|
sl@0
|
224 |
do_test bind-4.3 {
|
|
sl@0
|
225 |
execsql {
|
|
sl@0
|
226 |
DELETE FROM t1;
|
|
sl@0
|
227 |
}
|
|
sl@0
|
228 |
} {}
|
|
sl@0
|
229 |
#
|
|
sl@0
|
230 |
#Symbian OS: this test is failing due to problems in printf format spec implementation
|
|
sl@0
|
231 |
#
|
|
sl@0
|
232 |
if {$::tcl_platform(platform)!="symbian"} {
|
|
sl@0
|
233 |
do_test bind-4.4 {
|
|
sl@0
|
234 |
sqlite3_bind_double $VM 1 NaN
|
|
sl@0
|
235 |
sqlite3_bind_double $VM 2 1e300
|
|
sl@0
|
236 |
sqlite3_bind_double $VM 3 -1e-300
|
|
sl@0
|
237 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
238 |
sqlite3_reset $VM
|
|
sl@0
|
239 |
set x [execsql {SELECT rowid, * FROM t1}]
|
|
sl@0
|
240 |
regsub {1e-005} $x {1e-05} y
|
|
sl@0
|
241 |
set y
|
|
sl@0
|
242 |
} {1 {} 1e+300 -1e-300}
|
|
sl@0
|
243 |
#
|
|
sl@0
|
244 |
#Symbian OS: this test is commented because depends on 4.4
|
|
sl@0
|
245 |
#
|
|
sl@0
|
246 |
do_test bind-4.5 {
|
|
sl@0
|
247 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
248 |
} {null real real}
|
|
sl@0
|
249 |
}
|
|
sl@0
|
250 |
do_test bind-4.6 {
|
|
sl@0
|
251 |
execsql {
|
|
sl@0
|
252 |
DELETE FROM t1;
|
|
sl@0
|
253 |
}
|
|
sl@0
|
254 |
} {}
|
|
sl@0
|
255 |
|
|
sl@0
|
256 |
# NULL
|
|
sl@0
|
257 |
do_test bind-5.1 {
|
|
sl@0
|
258 |
sqlite3_bind_null $VM 1
|
|
sl@0
|
259 |
sqlite3_bind_null $VM 2
|
|
sl@0
|
260 |
sqlite3_bind_null $VM 3
|
|
sl@0
|
261 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
262 |
sqlite3_reset $VM
|
|
sl@0
|
263 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
264 |
} {1 {} {} {}}
|
|
sl@0
|
265 |
do_test bind-5.2 {
|
|
sl@0
|
266 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
267 |
} {null null null}
|
|
sl@0
|
268 |
do_test bind-5.3 {
|
|
sl@0
|
269 |
execsql {
|
|
sl@0
|
270 |
DELETE FROM t1;
|
|
sl@0
|
271 |
}
|
|
sl@0
|
272 |
} {}
|
|
sl@0
|
273 |
|
|
sl@0
|
274 |
# UTF-8 text
|
|
sl@0
|
275 |
do_test bind-6.1 {
|
|
sl@0
|
276 |
sqlite3_bind_text $VM 1 hellothere 5
|
|
sl@0
|
277 |
sqlite3_bind_text $VM 2 ".." 1
|
|
sl@0
|
278 |
sqlite3_bind_text $VM 3 world\000 -1
|
|
sl@0
|
279 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
280 |
sqlite3_reset $VM
|
|
sl@0
|
281 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
282 |
} {1 hello . world}
|
|
sl@0
|
283 |
do_test bind-6.2 {
|
|
sl@0
|
284 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
285 |
} {text text text}
|
|
sl@0
|
286 |
do_test bind-6.3 {
|
|
sl@0
|
287 |
execsql {
|
|
sl@0
|
288 |
DELETE FROM t1;
|
|
sl@0
|
289 |
}
|
|
sl@0
|
290 |
} {}
|
|
sl@0
|
291 |
|
|
sl@0
|
292 |
# Make sure zeros in a string work.
|
|
sl@0
|
293 |
#
|
|
sl@0
|
294 |
do_test bind-6.4 {
|
|
sl@0
|
295 |
db eval {DELETE FROM t1}
|
|
sl@0
|
296 |
sqlite3_bind_text $VM 1 hello\000there\000 12
|
|
sl@0
|
297 |
sqlite3_bind_text $VM 2 hello\000there\000 11
|
|
sl@0
|
298 |
sqlite3_bind_text $VM 3 hello\000there\000 -1
|
|
sl@0
|
299 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
300 |
sqlite3_reset $VM
|
|
sl@0
|
301 |
execsql {SELECT * FROM t1}
|
|
sl@0
|
302 |
} {hello hello hello}
|
|
sl@0
|
303 |
set enc [db eval {PRAGMA encoding}]
|
|
sl@0
|
304 |
if {$enc=="UTF-8"} {
|
|
sl@0
|
305 |
do_test bind-6.5 {
|
|
sl@0
|
306 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
307 |
} {68656C6C6F00746865726500 68656C6C6F007468657265 68656C6C6F}
|
|
sl@0
|
308 |
} elseif {$enc=="UTF-16le"} {
|
|
sl@0
|
309 |
do_test bind-6.5 {
|
|
sl@0
|
310 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
311 |
} {680065006C006C006F000000740068006500720065000000 680065006C006C006F00000074006800650072006500 680065006C006C006F00}
|
|
sl@0
|
312 |
} elseif {$enc=="UTF-16be"} {
|
|
sl@0
|
313 |
do_test bind-6.5 {
|
|
sl@0
|
314 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
315 |
} {00680065006C006C006F0000007400680065007200650000 00680065006C006C006F000000740068006500720065 00680065006C006C006F}
|
|
sl@0
|
316 |
} else {
|
|
sl@0
|
317 |
do_test bind-6.5 {
|
|
sl@0
|
318 |
set "Unknown database encoding: $::enc"
|
|
sl@0
|
319 |
} {}
|
|
sl@0
|
320 |
}
|
|
sl@0
|
321 |
do_test bind-6.6 {
|
|
sl@0
|
322 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
323 |
} {text text text}
|
|
sl@0
|
324 |
do_test bind-6.7 {
|
|
sl@0
|
325 |
execsql {
|
|
sl@0
|
326 |
DELETE FROM t1;
|
|
sl@0
|
327 |
}
|
|
sl@0
|
328 |
} {}
|
|
sl@0
|
329 |
|
|
sl@0
|
330 |
# UTF-16 text
|
|
sl@0
|
331 |
ifcapable {utf16} {
|
|
sl@0
|
332 |
do_test bind-7.1 {
|
|
sl@0
|
333 |
sqlite3_bind_text16 $VM 1 [encoding convertto unicode hellothere] 10
|
|
sl@0
|
334 |
sqlite3_bind_text16 $VM 2 [encoding convertto unicode ""] 0
|
|
sl@0
|
335 |
sqlite3_bind_text16 $VM 3 [encoding convertto unicode world] 10
|
|
sl@0
|
336 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
337 |
sqlite3_reset $VM
|
|
sl@0
|
338 |
execsql {SELECT rowid, * FROM t1}
|
|
sl@0
|
339 |
} {1 hello {} world}
|
|
sl@0
|
340 |
do_test bind-7.2 {
|
|
sl@0
|
341 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
342 |
} {text text text}
|
|
sl@0
|
343 |
do_test bind-7.3 {
|
|
sl@0
|
344 |
db eval {DELETE FROM t1}
|
|
sl@0
|
345 |
sqlite3_bind_text16 $VM 1 [encoding convertto unicode hi\000yall\000] 16
|
|
sl@0
|
346 |
sqlite3_bind_text16 $VM 2 [encoding convertto unicode hi\000yall\000] 14
|
|
sl@0
|
347 |
sqlite3_bind_text16 $VM 3 [encoding convertto unicode hi\000yall\000] -1
|
|
sl@0
|
348 |
sqlite_step $VM N VALUES COLNAMES
|
|
sl@0
|
349 |
sqlite3_reset $VM
|
|
sl@0
|
350 |
execsql {SELECT * FROM t1}
|
|
sl@0
|
351 |
} {hi hi hi}
|
|
sl@0
|
352 |
if {$enc=="UTF-8"} {
|
|
sl@0
|
353 |
do_test bind-7.4 {
|
|
sl@0
|
354 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
355 |
} {68690079616C6C00 68690079616C6C 6869}
|
|
sl@0
|
356 |
} elseif {$enc=="UTF-16le"} {
|
|
sl@0
|
357 |
do_test bind-7.4 {
|
|
sl@0
|
358 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
359 |
} {680069000000790061006C006C000000 680069000000790061006C006C00 68006900}
|
|
sl@0
|
360 |
} elseif {$enc=="UTF-16be"} {
|
|
sl@0
|
361 |
do_test bind-7.4 {
|
|
sl@0
|
362 |
execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
|
|
sl@0
|
363 |
} {00680069000000790061006C006C0000 00680069000000790061006C006C 00680069}
|
|
sl@0
|
364 |
}
|
|
sl@0
|
365 |
do_test bind-7.5 {
|
|
sl@0
|
366 |
execsql {SELECT typeof(a), typeof(b), typeof(c) FROM t1}
|
|
sl@0
|
367 |
} {text text text}
|
|
sl@0
|
368 |
}
|
|
sl@0
|
369 |
do_test bind-7.99 {
|
|
sl@0
|
370 |
execsql {DELETE FROM t1;}
|
|
sl@0
|
371 |
} {}
|
|
sl@0
|
372 |
|
|
sl@0
|
373 |
# Test that the 'out of range' error works.
|
|
sl@0
|
374 |
do_test bind-8.1 {
|
|
sl@0
|
375 |
catch { sqlite3_bind_null $VM 0 }
|
|
sl@0
|
376 |
} {1}
|
|
sl@0
|
377 |
do_test bind-8.2 {
|
|
sl@0
|
378 |
sqlite3_errmsg $DB
|
|
sl@0
|
379 |
} {bind or column index out of range}
|
|
sl@0
|
380 |
ifcapable {utf16} {
|
|
sl@0
|
381 |
do_test bind-8.3 {
|
|
sl@0
|
382 |
encoding convertfrom unicode [sqlite3_errmsg16 $DB]
|
|
sl@0
|
383 |
} {bind or column index out of range}
|
|
sl@0
|
384 |
}
|
|
sl@0
|
385 |
do_test bind-8.4 {
|
|
sl@0
|
386 |
sqlite3_bind_null $VM 1
|
|
sl@0
|
387 |
sqlite3_errmsg $DB
|
|
sl@0
|
388 |
} {not an error}
|
|
sl@0
|
389 |
do_test bind-8.5 {
|
|
sl@0
|
390 |
catch { sqlite3_bind_null $VM 4 }
|
|
sl@0
|
391 |
} {1}
|
|
sl@0
|
392 |
do_test bind-8.6 {
|
|
sl@0
|
393 |
sqlite3_errmsg $DB
|
|
sl@0
|
394 |
} {bind or column index out of range}
|
|
sl@0
|
395 |
ifcapable {utf16} {
|
|
sl@0
|
396 |
do_test bind-8.7 {
|
|
sl@0
|
397 |
encoding convertfrom unicode [sqlite3_errmsg16 $DB]
|
|
sl@0
|
398 |
} {bind or column index out of range}
|
|
sl@0
|
399 |
}
|
|
sl@0
|
400 |
|
|
sl@0
|
401 |
do_test bind-8.8 {
|
|
sl@0
|
402 |
catch { sqlite3_bind_blob $VM 0 "abc" 3 }
|
|
sl@0
|
403 |
} {1}
|
|
sl@0
|
404 |
do_test bind-8.9 {
|
|
sl@0
|
405 |
catch { sqlite3_bind_blob $VM 4 "abc" 3 }
|
|
sl@0
|
406 |
} {1}
|
|
sl@0
|
407 |
do_test bind-8.10 {
|
|
sl@0
|
408 |
catch { sqlite3_bind_text $VM 0 "abc" 3 }
|
|
sl@0
|
409 |
} {1}
|
|
sl@0
|
410 |
ifcapable {utf16} {
|
|
sl@0
|
411 |
do_test bind-8.11 {
|
|
sl@0
|
412 |
catch { sqlite3_bind_text16 $VM 4 "abc" 2 }
|
|
sl@0
|
413 |
} {1}
|
|
sl@0
|
414 |
}
|
|
sl@0
|
415 |
do_test bind-8.12 {
|
|
sl@0
|
416 |
catch { sqlite3_bind_int $VM 0 5 }
|
|
sl@0
|
417 |
} {1}
|
|
sl@0
|
418 |
do_test bind-8.13 {
|
|
sl@0
|
419 |
catch { sqlite3_bind_int $VM 4 5 }
|
|
sl@0
|
420 |
} {1}
|
|
sl@0
|
421 |
do_test bind-8.14 {
|
|
sl@0
|
422 |
catch { sqlite3_bind_double $VM 0 5.0 }
|
|
sl@0
|
423 |
} {1}
|
|
sl@0
|
424 |
do_test bind-8.15 {
|
|
sl@0
|
425 |
catch { sqlite3_bind_double $VM 4 6.0 }
|
|
sl@0
|
426 |
} {1}
|
|
sl@0
|
427 |
|
|
sl@0
|
428 |
do_test bind-8.99 {
|
|
sl@0
|
429 |
sqlite3_finalize $VM
|
|
sl@0
|
430 |
} SQLITE_OK
|
|
sl@0
|
431 |
|
|
sl@0
|
432 |
do_test bind-9.1 {
|
|
sl@0
|
433 |
execsql {
|
|
sl@0
|
434 |
CREATE TABLE t2(a,b,c,d,e,f);
|
|
sl@0
|
435 |
}
|
|
sl@0
|
436 |
set rc [catch {
|
|
sl@0
|
437 |
sqlite3_prepare $DB {
|
|
sl@0
|
438 |
INSERT INTO t2(a) VALUES(?0)
|
|
sl@0
|
439 |
} -1 TAIL
|
|
sl@0
|
440 |
} msg]
|
|
sl@0
|
441 |
lappend rc $msg
|
|
sl@0
|
442 |
} {1 {(1) variable number must be between ?1 and ?999}}
|
|
sl@0
|
443 |
do_test bind-9.2 {
|
|
sl@0
|
444 |
set rc [catch {
|
|
sl@0
|
445 |
sqlite3_prepare $DB {
|
|
sl@0
|
446 |
INSERT INTO t2(a) VALUES(?1000)
|
|
sl@0
|
447 |
} -1 TAIL
|
|
sl@0
|
448 |
} msg]
|
|
sl@0
|
449 |
lappend rc $msg
|
|
sl@0
|
450 |
} {1 {(1) variable number must be between ?1 and ?999}}
|
|
sl@0
|
451 |
do_test bind-9.3.1 {
|
|
sl@0
|
452 |
set VM [
|
|
sl@0
|
453 |
sqlite3_prepare $DB {
|
|
sl@0
|
454 |
INSERT INTO t2(a,b) VALUES(?1,?999)
|
|
sl@0
|
455 |
} -1 TAIL
|
|
sl@0
|
456 |
]
|
|
sl@0
|
457 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
458 |
} {999}
|
|
sl@0
|
459 |
catch {sqlite3_finalize $VM}
|
|
sl@0
|
460 |
do_test bind-9.3.2 {
|
|
sl@0
|
461 |
set VM [
|
|
sl@0
|
462 |
sqlite3_prepare $DB {
|
|
sl@0
|
463 |
INSERT INTO t2(a,b) VALUES(?2,?998)
|
|
sl@0
|
464 |
} -1 TAIL
|
|
sl@0
|
465 |
]
|
|
sl@0
|
466 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
467 |
} {998}
|
|
sl@0
|
468 |
catch {sqlite3_finalize $VM}
|
|
sl@0
|
469 |
do_test bind-9.4 {
|
|
sl@0
|
470 |
set VM [
|
|
sl@0
|
471 |
sqlite3_prepare $DB {
|
|
sl@0
|
472 |
INSERT INTO t2(a,b,c,d) VALUES(?1,?997,?,?)
|
|
sl@0
|
473 |
} -1 TAIL
|
|
sl@0
|
474 |
]
|
|
sl@0
|
475 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
476 |
} {999}
|
|
sl@0
|
477 |
do_test bind-9.5 {
|
|
sl@0
|
478 |
sqlite3_bind_int $VM 1 1
|
|
sl@0
|
479 |
sqlite3_bind_int $VM 997 999
|
|
sl@0
|
480 |
sqlite3_bind_int $VM 998 1000
|
|
sl@0
|
481 |
sqlite3_bind_int $VM 999 1001
|
|
sl@0
|
482 |
sqlite3_step $VM
|
|
sl@0
|
483 |
} SQLITE_DONE
|
|
sl@0
|
484 |
do_test bind-9.6 {
|
|
sl@0
|
485 |
sqlite3_finalize $VM
|
|
sl@0
|
486 |
} SQLITE_OK
|
|
sl@0
|
487 |
do_test bind-9.7 {
|
|
sl@0
|
488 |
execsql {SELECT * FROM t2}
|
|
sl@0
|
489 |
} {1 999 1000 1001 {} {}}
|
|
sl@0
|
490 |
|
|
sl@0
|
491 |
ifcapable {tclvar} {
|
|
sl@0
|
492 |
do_test bind-10.1 {
|
|
sl@0
|
493 |
set VM [
|
|
sl@0
|
494 |
sqlite3_prepare $DB {
|
|
sl@0
|
495 |
INSERT INTO t2(a,b,c,d,e,f) VALUES(:abc,$abc,:abc,$ab,$abc,:abc)
|
|
sl@0
|
496 |
} -1 TAIL
|
|
sl@0
|
497 |
]
|
|
sl@0
|
498 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
499 |
} 3
|
|
sl@0
|
500 |
set v1 {$abc}
|
|
sl@0
|
501 |
set v2 {$ab}
|
|
sl@0
|
502 |
}
|
|
sl@0
|
503 |
ifcapable {!tclvar} {
|
|
sl@0
|
504 |
do_test bind-10.1 {
|
|
sl@0
|
505 |
set VM [
|
|
sl@0
|
506 |
sqlite3_prepare $DB {
|
|
sl@0
|
507 |
INSERT INTO t2(a,b,c,d,e,f) VALUES(:abc,:xyz,:abc,:xy,:xyz,:abc)
|
|
sl@0
|
508 |
} -1 TAIL
|
|
sl@0
|
509 |
]
|
|
sl@0
|
510 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
511 |
} 3
|
|
sl@0
|
512 |
set v1 {:xyz}
|
|
sl@0
|
513 |
set v2 {:xy}
|
|
sl@0
|
514 |
}
|
|
sl@0
|
515 |
do_test bind-10.2 {
|
|
sl@0
|
516 |
sqlite3_bind_parameter_index $VM :abc
|
|
sl@0
|
517 |
} 1
|
|
sl@0
|
518 |
do_test bind-10.3 {
|
|
sl@0
|
519 |
sqlite3_bind_parameter_index $VM $v1
|
|
sl@0
|
520 |
} 2
|
|
sl@0
|
521 |
do_test bind-10.4 {
|
|
sl@0
|
522 |
sqlite3_bind_parameter_index $VM $v2
|
|
sl@0
|
523 |
} 3
|
|
sl@0
|
524 |
do_test bind-10.5 {
|
|
sl@0
|
525 |
sqlite3_bind_parameter_name $VM 1
|
|
sl@0
|
526 |
} :abc
|
|
sl@0
|
527 |
do_test bind-10.6 {
|
|
sl@0
|
528 |
sqlite3_bind_parameter_name $VM 2
|
|
sl@0
|
529 |
} $v1
|
|
sl@0
|
530 |
do_test bind-10.7 {
|
|
sl@0
|
531 |
sqlite3_bind_parameter_name $VM 3
|
|
sl@0
|
532 |
} $v2
|
|
sl@0
|
533 |
do_test bind-10.7.1 {
|
|
sl@0
|
534 |
sqlite3_bind_parameter_name 0 1 ;# Ignore if VM is NULL
|
|
sl@0
|
535 |
} {}
|
|
sl@0
|
536 |
do_test bind-10.7.2 {
|
|
sl@0
|
537 |
sqlite3_bind_parameter_name $VM 0 ;# Ignore if index too small
|
|
sl@0
|
538 |
} {}
|
|
sl@0
|
539 |
do_test bind-10.7.3 {
|
|
sl@0
|
540 |
sqlite3_bind_parameter_name $VM 4 ;# Ignore if index is too big
|
|
sl@0
|
541 |
} {}
|
|
sl@0
|
542 |
do_test bind-10.8 {
|
|
sl@0
|
543 |
sqlite3_bind_int $VM 1 1
|
|
sl@0
|
544 |
sqlite3_bind_int $VM 2 2
|
|
sl@0
|
545 |
sqlite3_bind_int $VM 3 3
|
|
sl@0
|
546 |
sqlite3_step $VM
|
|
sl@0
|
547 |
} SQLITE_DONE
|
|
sl@0
|
548 |
do_test bind-10.8.1 {
|
|
sl@0
|
549 |
# Binding attempts after program start should fail
|
|
sl@0
|
550 |
set rc [catch {
|
|
sl@0
|
551 |
sqlite3_bind_int $VM 1 1
|
|
sl@0
|
552 |
} msg]
|
|
sl@0
|
553 |
lappend rc $msg
|
|
sl@0
|
554 |
} {1 {}}
|
|
sl@0
|
555 |
do_test bind-10.9 {
|
|
sl@0
|
556 |
sqlite3_finalize $VM
|
|
sl@0
|
557 |
} SQLITE_OK
|
|
sl@0
|
558 |
do_test bind-10.10 {
|
|
sl@0
|
559 |
execsql {SELECT * FROM t2}
|
|
sl@0
|
560 |
} {1 999 1000 1001 {} {} 1 2 1 3 2 1}
|
|
sl@0
|
561 |
|
|
sl@0
|
562 |
# Ticket #918
|
|
sl@0
|
563 |
#
|
|
sl@0
|
564 |
do_test bind-10.11 {
|
|
sl@0
|
565 |
# catch {sqlite3_finalize $VM}
|
|
sl@0
|
566 |
set VM [
|
|
sl@0
|
567 |
sqlite3_prepare $DB {
|
|
sl@0
|
568 |
INSERT INTO t2(a,b,c,d,e,f) VALUES(:abc,?,?4,:pqr,:abc,?4)
|
|
sl@0
|
569 |
} -1 TAIL
|
|
sl@0
|
570 |
]
|
|
sl@0
|
571 |
sqlite3_bind_parameter_count $VM
|
|
sl@0
|
572 |
} 5
|
|
sl@0
|
573 |
do_test bind-10.11.1 {
|
|
sl@0
|
574 |
sqlite3_bind_parameter_index 0 :xyz ;# ignore NULL VM arguments
|
|
sl@0
|
575 |
} 0
|
|
sl@0
|
576 |
do_test bind-10.12 {
|
|
sl@0
|
577 |
sqlite3_bind_parameter_index $VM :xyz
|
|
sl@0
|
578 |
} 0
|
|
sl@0
|
579 |
do_test bind-10.13 {
|
|
sl@0
|
580 |
sqlite3_bind_parameter_index $VM {}
|
|
sl@0
|
581 |
} 0
|
|
sl@0
|
582 |
do_test bind-10.14 {
|
|
sl@0
|
583 |
sqlite3_bind_parameter_index $VM :pqr
|
|
sl@0
|
584 |
} 5
|
|
sl@0
|
585 |
do_test bind-10.15 {
|
|
sl@0
|
586 |
sqlite3_bind_parameter_index $VM ?4
|
|
sl@0
|
587 |
} 4
|
|
sl@0
|
588 |
do_test bind-10.16 {
|
|
sl@0
|
589 |
sqlite3_bind_parameter_name $VM 1
|
|
sl@0
|
590 |
} :abc
|
|
sl@0
|
591 |
do_test bind-10.17 {
|
|
sl@0
|
592 |
sqlite3_bind_parameter_name $VM 2
|
|
sl@0
|
593 |
} {}
|
|
sl@0
|
594 |
do_test bind-10.18 {
|
|
sl@0
|
595 |
sqlite3_bind_parameter_name $VM 3
|
|
sl@0
|
596 |
} {}
|
|
sl@0
|
597 |
do_test bind-10.19 {
|
|
sl@0
|
598 |
sqlite3_bind_parameter_name $VM 4
|
|
sl@0
|
599 |
} {?4}
|
|
sl@0
|
600 |
do_test bind-10.20 {
|
|
sl@0
|
601 |
sqlite3_bind_parameter_name $VM 5
|
|
sl@0
|
602 |
} :pqr
|
|
sl@0
|
603 |
catch {sqlite3_finalize $VM}
|
|
sl@0
|
604 |
|
|
sl@0
|
605 |
# Make sure we catch an unterminated "(" in a Tcl-style variable name
|
|
sl@0
|
606 |
#
|
|
sl@0
|
607 |
ifcapable tclvar {
|
|
sl@0
|
608 |
do_test bind-11.1 {
|
|
sl@0
|
609 |
catchsql {SELECT * FROM sqlite_master WHERE name=$abc(123 and sql NOT NULL;}
|
|
sl@0
|
610 |
} {1 {unrecognized token: "$abc(123"}}
|
|
sl@0
|
611 |
}
|
|
sl@0
|
612 |
|
|
sl@0
|
613 |
if {[execsql {pragma encoding}]=="UTF-8"} {
|
|
sl@0
|
614 |
# Test the ability to bind text that contains embedded '\000' characters.
|
|
sl@0
|
615 |
# Make sure we can recover the entire input string.
|
|
sl@0
|
616 |
#
|
|
sl@0
|
617 |
do_test bind-12.1 {
|
|
sl@0
|
618 |
execsql {
|
|
sl@0
|
619 |
CREATE TABLE t3(x BLOB);
|
|
sl@0
|
620 |
}
|
|
sl@0
|
621 |
set VM [sqlite3_prepare $DB {INSERT INTO t3 VALUES(?)} -1 TAIL]
|
|
sl@0
|
622 |
sqlite_bind $VM 1 not-used blob10
|
|
sl@0
|
623 |
sqlite3_step $VM
|
|
sl@0
|
624 |
sqlite3_finalize $VM
|
|
sl@0
|
625 |
execsql {
|
|
sl@0
|
626 |
SELECT typeof(x), length(x), quote(x),
|
|
sl@0
|
627 |
length(cast(x AS BLOB)), quote(cast(x AS BLOB)) FROM t3
|
|
sl@0
|
628 |
}
|
|
sl@0
|
629 |
} {text 3 'abc' 10 X'6162630078797A007071'}
|
|
sl@0
|
630 |
do_test bind-12.2 {
|
|
sl@0
|
631 |
sqlite3_create_function $DB
|
|
sl@0
|
632 |
execsql {
|
|
sl@0
|
633 |
SELECT quote(cast(x_coalesce(x) AS blob)) FROM t3
|
|
sl@0
|
634 |
}
|
|
sl@0
|
635 |
} {X'6162630078797A007071'}
|
|
sl@0
|
636 |
}
|
|
sl@0
|
637 |
|
|
sl@0
|
638 |
# Test the operation of sqlite3_clear_bindings
|
|
sl@0
|
639 |
#
|
|
sl@0
|
640 |
do_test bind-13.1 {
|
|
sl@0
|
641 |
set VM [sqlite3_prepare $DB {SELECT ?,?,?} -1 TAIL]
|
|
sl@0
|
642 |
sqlite3_step $VM
|
|
sl@0
|
643 |
list [sqlite3_column_type $VM 0] [sqlite3_column_type $VM 1] \
|
|
sl@0
|
644 |
[sqlite3_column_type $VM 2]
|
|
sl@0
|
645 |
} {NULL NULL NULL}
|
|
sl@0
|
646 |
do_test bind-13.2 {
|
|
sl@0
|
647 |
sqlite3_reset $VM
|
|
sl@0
|
648 |
sqlite3_bind_int $VM 1 1
|
|
sl@0
|
649 |
sqlite3_bind_int $VM 2 2
|
|
sl@0
|
650 |
sqlite3_bind_int $VM 3 3
|
|
sl@0
|
651 |
sqlite3_step $VM
|
|
sl@0
|
652 |
list [sqlite3_column_type $VM 0] [sqlite3_column_type $VM 1] \
|
|
sl@0
|
653 |
[sqlite3_column_type $VM 2]
|
|
sl@0
|
654 |
} {INTEGER INTEGER INTEGER}
|
|
sl@0
|
655 |
do_test bind-13.3 {
|
|
sl@0
|
656 |
sqlite3_reset $VM
|
|
sl@0
|
657 |
sqlite3_step $VM
|
|
sl@0
|
658 |
list [sqlite3_column_type $VM 0] [sqlite3_column_type $VM 1] \
|
|
sl@0
|
659 |
[sqlite3_column_type $VM 2]
|
|
sl@0
|
660 |
} {INTEGER INTEGER INTEGER}
|
|
sl@0
|
661 |
do_test bind-13.4 {
|
|
sl@0
|
662 |
sqlite3_reset $VM
|
|
sl@0
|
663 |
sqlite3_clear_bindings $VM
|
|
sl@0
|
664 |
sqlite3_step $VM
|
|
sl@0
|
665 |
list [sqlite3_column_type $VM 0] [sqlite3_column_type $VM 1] \
|
|
sl@0
|
666 |
[sqlite3_column_type $VM 2]
|
|
sl@0
|
667 |
} {NULL NULL NULL}
|
|
sl@0
|
668 |
sqlite3_finalize $VM
|
|
sl@0
|
669 |
|
|
sl@0
|
670 |
finish_test
|