Import SQLite 3.10.2.

third_party/sqlite/src/test/like.test

 # 2005 August 13
 #
 # 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 727 matching lines @@
   do_test like-10.3 {
     count {
       SELECT a FROM t10 WHERE d LIKE '12%' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
   do_test like-10.4 {
     count {
       SELECT a FROM t10 WHERE e LIKE '12%' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
-  do_test like-10.5 {
-    count {
-      SELECT a FROM t10 WHERE f LIKE '12%' ORDER BY +a;
-    }
-  } {12 123 scan 3 like 0}
+  ifcapable like_match_blobs {
+    do_test like-10.5a {
+      count {
+        SELECT a FROM t10 WHERE f LIKE '12%' ORDER BY +a;
+      }
+    } {12 123 scan 4 like 0}
+  } else {
+    do_test like-10.5b {
+      count {
+        SELECT a FROM t10 WHERE f LIKE '12%' ORDER BY +a;
+      }
+    } {12 123 scan 3 like 0}
+  }
   do_test like-10.6 {
     count {
       SELECT a FROM t10 WHERE a LIKE '12%' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
   do_test like-10.10 {
     execsql {
       CREATE TABLE t10b(
         a INTEGER PRIMARY KEY,
         b INTEGER UNIQUE,
@@ skipping 16 matching lines @@
   do_test like-10.12 {
     count {
       SELECT a FROM t10b WHERE d GLOB '12*' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
   do_test like-10.13 {
     count {
       SELECT a FROM t10b WHERE e GLOB '12*' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
-  do_test like-10.14 {
-    count {
-      SELECT a FROM t10b WHERE f GLOB '12*' ORDER BY +a;
-    }
-  } {12 123 scan 3 like 0}
+  ifcapable like_match_blobs {
+    do_test like-10.14 {
+      count {
+        SELECT a FROM t10b WHERE f GLOB '12*' ORDER BY +a;
+      }
+    } {12 123 scan 4 like 0}
+  } else {
+    do_test like-10.14 {
+      count {
+        SELECT a FROM t10b WHERE f GLOB '12*' ORDER BY +a;
+      }
+    } {12 123 scan 3 like 0}
+  }
   do_test like-10.15 {
     count {
       SELECT a FROM t10b WHERE a GLOB '12*' ORDER BY +a;
     }
   } {12 123 scan 5 like 6}
 }
 
 # LIKE and GLOB where the default collating sequence is not appropriate
 # but an index with the appropriate collating sequence exists.
 #
@@ skipping 137 matching lines @@
 } {/SCAN/}
 do_execsql_test like-12.15 {
   EXPLAIN QUERY PLAN
   SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
 } {/SEARCH/}
 do_execsql_test like-12.16 {
   EXPLAIN QUERY PLAN
   SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
 } {/SCAN/}
 
+# Ticket [https://www.sqlite.org/src/tktview/80369eddd5c94d49f7fbbcf5]
+# 2016-01-20
+#
+do_execsql_test like-13.1 {
+  SELECT char(0x304d) LIKE char(0x306d);
+} {0}
+do_execsql_test like-13.2 {
+  SELECT char(0x4d) LIKE char(0x306d);
+} {0}
+do_execsql_test like-13.3 {
+  SELECT char(0x304d) LIKE char(0x6d);
+} {0}
+do_execsql_test like-13.4 {
+  SELECT char(0x4d) LIKE char(0x6d);
+} {1}
+
+
 
 finish_test