/ Check-in [c461c0fe]
Login

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

Overview
Comment:Add an extra test to verify that the FTS notindexed option is working.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:c461c0fe051d33cc8b4fede4eca13cd71f28126a
User & Date: dan 2014-05-28 10:00:38
Context
2014-05-28
20:22
Add the ".shell" and the ".system" commands (aliases for the same thing) to the command-line shell. check-in: d018a34a user: drh tags: trunk
10:00
Add an extra test to verify that the FTS notindexed option is working. check-in: c461c0fe user: dan tags: trunk
03:23
Revise how OSTRACE reports logically boolean results in the Win32 VFS. check-in: c405f971 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/fts4noti.test.

   205    205   } {}
   206    206   do_execsql_test 6.2.4 {
   207    207     SELECT * FROM t1 WHERE t1 MATCH '6021';
   208    208   } { Restaurant 6021 }
   209    209   do_execsql_test 6.2.5 {
   210    210     SELECT * FROM t1 WHERE t1 MATCH '60*';
   211    211   } { Restaurant 6021 }
          212  +
          213  +do_execsql_test 6.3.1 {
          214  +  DROP TABLE t1;
          215  +  CREATE VIRTUAL TABLE t1 USING fts4(abc, ab, a, notindexed=abc);
          216  +  CREATE VIRTUAL TABLE t2 USING fts4(a, ab, abc, notindexed=abc);
          217  +
          218  +  INSERT INTO t1 VALUES('no', 'yes', 'yep');
          219  +  INSERT INTO t2 VALUES('yep', 'yes', 'no');
          220  +
          221  +  SELECT count(*) FROM t1 WHERE t1 MATCH 'no';
          222  +  SELECT count(*) FROM t1 WHERE t1 MATCH 'yes';
          223  +  SELECT count(*) FROM t1 WHERE t1 MATCH 'yep';
          224  +
          225  +  SELECT count(*) FROM t2 WHERE t2 MATCH 'no';
          226  +  SELECT count(*) FROM t2 WHERE t2 MATCH 'yes';
          227  +  SELECT count(*) FROM t2 WHERE t2 MATCH 'yep';
          228  +} {0 1 1 0 1 1}
   212    229   
   213    230   finish_test
   214    231   
   215    232   
   216    233