Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Test cases for ticket [587791f92620090e] |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
ca0e3a83a1c015b346a791e6de03904d |
User & Date: | drh 2019-09-17 13:30:30.042 |
Context
2019-09-17
| ||
21:28 | Do not change the OP_String8 opcode into OP_String until *after* any necessary encoding conversions are accomplished. Otherwise, a rerun of the prepared statement after an OOM can result in errors. Test case in TH3. (check-in: 8efd62594e user: drh tags: trunk) | |
13:30 | Test cases for ticket [587791f92620090e] (check-in: ca0e3a83a1 user: drh tags: trunk) | |
03:16 | Fix the instr() SQL function so that it makes a copy of its argument before changing the datatype, since the datatype affects processing. Also fix the sqlite3_value_text() routine so that it always works even for values obtained form sqlite3_value_dup(). Ticket [587791f92620090e] (check-in: 3fb40f5180 user: drh tags: trunk) | |
Changes
Changes to test/instr.test.
︙ | ︙ | |||
252 253 254 255 256 257 258 259 260 | SELECT instr(X'', 'abc') } 0 do_execsql_test instr-1.64 { CREATE TABLE x1(a, b); INSERT INTO x1 VALUES(X'', 'abc'); SELECT instr(a, b) FROM x1; } 0 finish_test | > > > > > > > > > > > > > > > > > > > > > | 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 | SELECT instr(X'', 'abc') } 0 do_execsql_test instr-1.64 { CREATE TABLE x1(a, b); INSERT INTO x1 VALUES(X'', 'abc'); SELECT instr(a, b) FROM x1; } 0 # 2019-09-16 ticket https://www.sqlite.org/src/info/587791f92620090e # do_execsql_test instr-2.0 { DROP TABLE IF EXISTS t0; CREATE TABLE t0(c0 PRIMARY KEY, c1); INSERT INTO t0(c0) VALUES (x'bb'), (0); SELECT COUNT(*) FROM t0 WHERE INSTR(x'aabb', t0.c0) ORDER BY t0.c0, t0.c1; } {1} do_execsql_test instr-2.1 { SELECT quote(c0) FROM t0 WHERE INSTR(x'aabb', t0.c0) ORDER BY t0.c0, t0.c1; } {X'BB'} do_execsql_test instr-2.2 { DROP TABLE IF EXISTS t1; CREATE TABLE t1(x); INSERT INTO t1(x) VALUES('text'),(x'bb'); SELECT quote(x) FROM t1 WHERE instr(x'aabb',x); } {X'BB'} do_execsql_test instr-2.3 { SELECT quote(x) FROM t1 WHERE x>'zzz' AND instr(x'aabb',x); } {X'BB'} finish_test |