Import SQLite 3.10.2.

third_party/sqlite/src/test/where8.test

 # 2008 December 23
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 46 matching lines @@
 } {}
 
 do_test where8-1.2 { 
   execsql_status2 { SELECT c FROM t1 WHERE a = 1 OR b = 'nine' }
 } {I IX 0 0 6}
 
 do_test where8-1.3 { 
   execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b = 'two' }
 } {IX X II 0 0 6}
 
-do_test where8-1.4 { 
-  execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 't*' }
-} {IX X III II 0 0 9}
-
-do_test where8-1.5 { 
-  execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 'f*' }
-} {IX X V IV 0 0 9}
+ifcapable like_match_blobs {
+  do_test where8-1.4a { 
+    execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 't*' }
+  } {IX X III II 0 0 10}
+  do_test where8-1.5a { 
+    execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 'f*' }
+  } {IX X V IV 0 0 10}
+} else {
+  do_test where8-1.4b { 
+    execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 't*' }
+  } {IX X III II 0 0 9}
+  do_test where8-1.5 { 
+    execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 'f*' }
+  } {IX X V IV 0 0 9}
+}
 
 do_test where8-1.6 { 
   execsql_status { SELECT c FROM t1 WHERE a = 1 OR b = 'three' ORDER BY rowid }
 } {I III 0 1}
 
 do_test where8-1.7 { 
   execsql_status { SELECT c FROM t1 WHERE a = 1 OR b = 'three' ORDER BY a }
 } {I III 0 1}
 
 do_test where8-1.8 {
@@ skipping 667 matching lines @@
 # The OR optimization and WITHOUT ROWID
 #
 do_execsql_test where8-6.1 {
   CREATE TABLE t600(a PRIMARY KEY, b) WITHOUT rowid;
   CREATE INDEX t600b ON t600(b);
   INSERT INTO t600 VALUES('state','screen'),('exact','dolphin'),('green','mercury');
   SELECT a, b, '|' FROM t600 WHERE a=='state' OR b='mercury' ORDER BY +a;
 } {green mercury | state screen |}
 
 finish_test