/ Check-in [0c8b9b21]
Login

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

Overview
Comment:Fix FTS3 test cases due to the flattener change of the previous check-in.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:0c8b9b211f4285e2ab77cf5e0820088ef10e05c4
User & Date: drh 2016-09-27 00:03:25
Context
2016-09-27
00:09
Update requirements marks due to improvements in the wording of documentation. No changes to code. check-in: bf903b2e user: drh tags: trunk
00:03
Fix FTS3 test cases due to the flattener change of the previous check-in. check-in: 0c8b9b21 user: drh tags: trunk
2016-09-26
14:39
When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?) WHERE y=?", ensure that the final WHERE clause is "x=? AND y=?" instead of "y=? AND x=?". Although it is still not guaranteed, this makes the order in which WHERE clause terms are processed comport more closely to users expectations. check-in: cf7f9e6d user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/fts3aux1.test.

   113    113   # Now show that using "term='braid'" means the virtual table returns
   114    114   # only 1 row to SQLite, but "+term='braid'" means all 19 are returned.
   115    115   #
   116    116   do_test 2.1.2.1 {
   117    117     set cnt 0
   118    118     execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND term='braid' }
   119    119     set cnt
   120         -} {2}
          120  +} {1}
   121    121   do_test 2.1.2.2 {
   122    122     set cnt 0
   123    123     execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND +term='braid' }
   124    124     set cnt
   125         -} {38}
          125  +} {19}
   126    126   
   127    127   # Similar to the test immediately above, but using a term ("breakfast") that 
   128    128   # is not featured in the dataset.
   129    129   #
   130    130   do_test 2.1.3.1 {
   131    131     set cnt 0
   132    132     execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND term='breakfast' }
   133    133     set cnt
   134    134   } {0}
   135    135   do_test 2.1.3.2 {
   136    136     set cnt 0
   137    137     execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND +term='breakfast' }
   138    138     set cnt
   139         -} {38}
          139  +} {19}
   140    140   
   141    141   do_execsql_test 2.1.4.1 { SELECT * FROM terms_v WHERE term='braid' } {braid 1 1}
   142    142   do_execsql_test 2.1.4.2 { SELECT * FROM terms_v WHERE +term='braid'} {braid 1 1}
   143    143   do_execsql_test 2.1.4.3 { SELECT * FROM terms_v WHERE term='breakfast'  } {}
   144    144   do_execsql_test 2.1.4.4 { SELECT * FROM terms_v WHERE +term='breakfast' } {}
   145    145   
   146    146   do_execsql_test 2.1.4.5 { SELECT * FROM terms_v WHERE term='cba'  } {}