/ Check-in [0bdb7ae1]
Login

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

Overview
Comment:Test cases for the improved LIKE/GLOB matcher.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0bdb7ae126d3909344640813489ee68ecad041c4
User & Date: drh 2016-12-02 02:19:24
Context
2016-12-02
17:08
Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. check-in: 768c9859 user: drh tags: trunk
14:15
Fix a potential integer overflow during out-of-bound date computations. Closed-Leaf check-in: 3c58b173 user: drh tags: date-overflow-fix
02:19
Test cases for the improved LIKE/GLOB matcher. check-in: 0bdb7ae1 user: drh tags: trunk
2016-12-01
19:58
Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. check-in: a427c405 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/like.test.

   976    976   do_execsql_test like-13.3 {
   977    977     SELECT char(0x304d) LIKE char(0x6d);
   978    978   } {0}
   979    979   do_execsql_test like-13.4 {
   980    980     SELECT char(0x4d) LIKE char(0x6d);
   981    981   } {1}
   982    982   
   983         -
          983  +# Performance testing for patterns with many wildcards.  These LIKE and GLOB
          984  +# patterns were quite slow with SQLite 3.15.2 and earlier.
          985  +#
          986  +do_test like-14.1 {
          987  +  set x [lindex [time {
          988  +    db one {SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaz'GLOB'*a*a*a*a*a*a*a*a*y'}
          989  +  }] 0]
          990  +  puts -nonewline " ($x ms - want less than 1000) "
          991  +  expr {$x<1000}
          992  +} {1}
          993  +ifcapable !icu {
          994  +  do_test like-14.2 {
          995  +    set x [lindex [time {
          996  +      db one {SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaz'LIKE'%a%a%a%a%a%a%a%a%y'}
          997  +    }] 0]
          998  +    puts -nonewline " ($x ms - want less than 1000) "
          999  +    expr {$x<1000}
         1000  +  } {1}
         1001  +}
   984   1002   
   985   1003   finish_test