/ Check-in [af53c41a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: af53c41a127c314c0608f3fd016d3a26896783745e46cd180976a188400cdb75
User & Date: dan 2019-04-26 17:08:50
Context
2019-04-27
20:16
Fix a minor typo in a comment. No changes to code. check-in: 95209072 user: drh tags: trunk
2019-04-26
17:08
Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. check-in: af53c41a user: dan tags: trunk
2019-04-24
17:04
New test cases in test/fuzzdata8.db. check-in: 7be6222c user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/like3.test.

   178    178     `--SEARCH TABLE t5b USING COVERING INDEX sqlite_autoindex_t5b_1 (x>? AND x<?)
   179    179   }
   180    180   
   181    181   # 2019-02-27
   182    182   # Verify that the LIKE optimization works with an ESCAPE clause when
   183    183   # using PRAGMA case_sensitive_like=ON.
   184    184   #
          185  +ifcapable !icu {
   185    186   do_execsql_test like3-6.100 {
   186    187     DROP TABLE IF EXISTS t1;
   187    188     CREATE TABLE t1(path TEXT COLLATE nocase PRIMARY KEY,a,b,c) WITHOUT ROWID;
   188    189   }
   189    190   do_eqp_test like3-6.110 {
   190    191     SELECT * FROM t1 WHERE path LIKE 'a%';
   191    192   } {
................................................................................
   224    225     `--SEARCH TABLE t2 USING INDEX t2path2 (path>? AND path<?)
   225    226   }
   226    227   do_eqp_test like3-6.240 {
   227    228     SELECT * FROM t2 WHERE path LIKE 'a%' ESCAPE '_';
   228    229   } {
   229    230     QUERY PLAN
   230    231     `--SEARCH TABLE t2 USING INDEX t2path2 (path>? AND path<?)
          232  +}
   231    233   }
   232    234   
   233    235   finish_test