/ Check-in [bf98a2de]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Add extra test cases to verify the fix in [64ca1a835].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bf98a2de7ed41a8acca89d7369b353f12182cfb4
User & Date: dan 2016-07-21 18:02:20
Context
2016-07-22
10:09
Fix a problem with upper case module names in the "sqldiff --vtab" command. check-in: 87e25fc4 user: dan tags: trunk
2016-07-21
18:02
Add extra test cases to verify the fix in [64ca1a835]. check-in: bf98a2de user: dan tags: trunk
16:43
Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). check-in: 1b1ad0b2 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/fts5/test/fts5rank.test.

    96     96   #
    97     97   #   ... MATCH 'x OR y' ORDER BY rank;
    98     98   #
    99     99   # if there were zero occurrences of token 'y' in the dataset. The
   100    100   # following tests verify that that problem has been addressed.
   101    101   #
   102    102   foreach_detail_mode $::testprefix {
   103         -  do_execsql_test 3.0 {
          103  +  do_execsql_test 3.1.0 {
   104    104       CREATE VIRTUAL TABLE y1 USING fts5(z, detail=%DETAIL%);
   105    105       INSERT INTO y1 VALUES('test xyz');
   106    106       INSERT INTO y1 VALUES('test test xyz test');
   107    107       INSERT INTO y1 VALUES('test test xyz');
   108    108     }
   109    109   
   110         -  do_execsql_test 3.1 {
          110  +  do_execsql_test 3.1.1 {
   111    111       SELECT rowid FROM y1('test OR tset');
   112    112     } {1 2 3}
   113    113   
   114         -  do_execsql_test 3.2 {
          114  +  do_execsql_test 3.1.2 {
   115    115       SELECT rowid FROM y1('test OR tset') ORDER BY bm25(y1)
   116    116     } {2 3 1}
   117    117   
   118         -  do_execsql_test 3.3 {
          118  +  do_execsql_test 3.1.3 {
   119    119       SELECT rowid FROM y1('test OR tset') ORDER BY +rank
   120    120     } {2 3 1}
   121    121   
   122         -  do_execsql_test 3.4 {
          122  +  do_execsql_test 3.1.4 {
   123    123       SELECT rowid FROM y1('test OR tset') ORDER BY rank
   124    124     } {2 3 1}
          125  +
          126  +  do_execsql_test 3.1.5 {
          127  +    SELECT rowid FROM y1('test OR xyz') ORDER BY rank
          128  +  } {3 2 1}
          129  +
          130  +
          131  +  do_execsql_test 3.2.1 {
          132  +    CREATE VIRTUAL TABLE z1 USING fts5(a, detail=%DETAIL%);
          133  +    INSERT INTO z1 VALUES('wrinkle in time');
          134  +    SELECT * FROM z1 WHERE z1 MATCH 'wrinkle in time OR a wrinkle in time';
          135  +  } {{wrinkle in time}}
   125    136   }
          137  +
          138  +do_execsql_test 4.1 {
          139  +  DROP TABLE IF EXISTS VTest;
          140  +  CREATE virtual TABLE VTest USING FTS5(
          141  +    Title, AUthor, tokenize ='porter unicode61 remove_diacritics 1', 
          142  +    columnsize='1', detail=full
          143  +  );
          144  +  INSERT INTO VTest (Title, Author) VALUES ('wrinkle in time', 'Bill Smith');
          145  +
          146  +  SELECT * FROM VTest WHERE 
          147  +  VTest MATCH 'wrinkle in time OR a wrinkle in time' ORDER BY rank;
          148  +} {{wrinkle in time} {Bill Smith}}
          149  +
          150  +
   126    151   
   127    152   
   128    153   finish_test
   129    154