Index: third_party/sqlite/sqlite-src-3170000/test/like3.test |
diff --git a/third_party/sqlite/sqlite-src-3170000/test/like3.test b/third_party/sqlite/sqlite-src-3170000/test/like3.test |
new file mode 100644 |
index 0000000000000000000000000000000000000000..9280c2c5d2d1c72e6082cbc9b38be3d29b71c8fb |
--- /dev/null |
+++ b/third_party/sqlite/sqlite-src-3170000/test/like3.test |
@@ -0,0 +1,115 @@ |
+# 2015-03-06 |
+# |
+# The author disclaims copyright to this source code. In place of |
+# a legal notice, here is a blessing: |
+# |
+# May you do good and not evil. |
+# May you find forgiveness for yourself and forgive others. |
+# May you share freely, never taking more than you give. |
+# |
+#*********************************************************************** |
+# |
+# This file implements regression tests for SQLite library. The |
+# focus of this file is testing the LIKE and GLOB operators and |
+# in particular the optimizations that occur to help those operators |
+# run faster and that those optimizations work correctly when there |
+# are both strings and blobs being tested. |
+# |
+# Ticket 05f43be8fdda9fbd948d374319b99b054140bc36 shows that the following |
+# SQL was not working correctly: |
+# |
+# CREATE TABLE t1(x TEXT UNIQUE COLLATE nocase); |
+# INSERT INTO t1(x) VALUES(x'616263'); |
+# SELECT 'query-1', x FROM t1 WHERE x LIKE 'a%'; |
+# SELECT 'query-2', x FROM t1 WHERE +x LIKE 'a%'; |
+# |
+# This script verifies that it works right now. |
+# |
+ |
+set testdir [file dirname $argv0] |
+source $testdir/tester.tcl |
+ |
+ifcapable !like_match_blobs { |
+ finish_test |
+ return |
+} |
+ |
+do_execsql_test like3-1.1 { |
+ PRAGMA encoding=UTF8; |
+ CREATE TABLE t1(a,b TEXT COLLATE nocase); |
+ INSERT INTO t1(a,b) |
+ VALUES(1,'abc'), |
+ (2,'ABX'), |
+ (3,'BCD'), |
+ (4,x'616263'), |
+ (5,x'414258'), |
+ (6,x'424344'); |
+ CREATE INDEX t1ba ON t1(b,a); |
+ |
+ SELECT a, b FROM t1 WHERE b LIKE 'aB%' ORDER BY +a; |
+} {1 abc 2 ABX 4 abc 5 ABX} |
+do_execsql_test like3-1.2 { |
+ SELECT a, b FROM t1 WHERE +b LIKE 'aB%' ORDER BY +a; |
+} {1 abc 2 ABX 4 abc 5 ABX} |
+ |
+do_execsql_test like3-2.0 { |
+ CREATE TABLE t2(a, b TEXT); |
+ INSERT INTO t2 SELECT a, b FROM t1; |
+ CREATE INDEX t2ba ON t2(b,a); |
+ SELECT a, b FROM t2 WHERE b GLOB 'ab*' ORDER BY +a; |
+} {1 abc 4 abc} |
+do_execsql_test like3-2.1 { |
+ SELECT a, b FROM t2 WHERE +b GLOB 'ab*' ORDER BY +a; |
+} {1 abc 4 abc} |
+do_execsql_test like3-2.2 { |
+ SELECT a, b FROM t2 WHERE b>=x'6162' AND b GLOB 'ab*' |
+} {4 abc} |
+do_execsql_test like3-2.3 { |
+ SELECT a, b FROM t2 WHERE +b>=x'6162' AND +b GLOB 'ab*' |
+} {4 abc} |
+do_execsql_test like3-2.4 { |
+ SELECT a, b FROM t2 WHERE b GLOB 'ab*' AND b>=x'6162' |
+} {4 abc} |
+do_execsql_test like3-2.5 { |
+ SELECT a, b FROM t2 WHERE +b GLOB 'ab*' AND +b>=x'6162' |
+} {4 abc} |
+ |
+do_execsql_test like3-3.0 { |
+ CREATE TABLE t3(x TEXT PRIMARY KEY COLLATE nocase); |
+ INSERT INTO t3(x) VALUES('aaa'),('abc'),('abd'),('abe'),('acz'); |
+ INSERT INTO t3(x) SELECT CAST(x AS blob) FROM t3; |
+ SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+do_execsql_test like3-3.1 { |
+ SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x DESC; |
+} {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} |
+do_execsql_test like3-3.1ck { |
+ SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x DESC; |
+} {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} |
+do_execsql_test like3-3.2 { |
+ SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x ASC; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+do_execsql_test like3-3.2ck { |
+ SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x ASC; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+ |
+do_execsql_test like3-4.0 { |
+ CREATE TABLE t4(x TEXT COLLATE nocase); |
+ CREATE INDEX t4x ON t4(x DESC); |
+ INSERT INTO t4(x) SELECT x FROM t3; |
+ SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+do_execsql_test like3-4.1 { |
+ SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x DESC; |
+} {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} |
+do_execsql_test like3-4.1ck { |
+ SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x DESC; |
+} {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} |
+do_execsql_test like3-4.2 { |
+ SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x ASC; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+do_execsql_test like3-4.2ck { |
+ SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x ASC; |
+} {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} |
+ |
+finish_test |