Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add tests for modifying the docid and languageid fields of an fts table with a non-zero languageid_bits field. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | fts-languageid-bits |
Files: | files | file ages | folders |
SHA1: |
949425d467947c3905cca3e08750fbaf |
User & Date: | dan 2013-06-20 19:55:50.400 |
Context
2013-06-20
| ||
19:55 | Add tests for modifying the docid and languageid fields of an fts table with a non-zero languageid_bits field. (Closed-Leaf check-in: 949425d467 user: dan tags: fts-languageid-bits) | |
18:32 | Fix some issues related to ORDER BY and fts tables with a non-zero languageid_bits setting. (check-in: 81527768ef user: dan tags: fts-languageid-bits) | |
Changes
Changes to test/fts4langid2.test.
︙ | ︙ | |||
310 311 312 313 314 315 316 | INSERT INTO t1 (docid,lid,content) VALUES(3, 5, 'A C'); INSERT INTO t1 (docid,lid,content) VALUES(2, 5, 'B C'); } do_execsql_test 8.2 { SELECT docid FROM t1 ORDER BY docid; } {1 1 2 2 3 3} | < | < | > > > > > > > | 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 | INSERT INTO t1 (docid,lid,content) VALUES(3, 5, 'A C'); INSERT INTO t1 (docid,lid,content) VALUES(2, 5, 'B C'); } do_execsql_test 8.2 { SELECT docid FROM t1 ORDER BY docid; } {1 1 2 2 3 3} do_execsql_test 8.3 { SELECT docid FROM t1 WHERE t1 MATCH 'ghi' ORDER BY docid; } {2 3} do_execsql_test 8.4 { SELECT docid FROM t1 WHERE t1 MATCH 'ghi' ORDER BY docid DESC; } {3 2} # Test that the docid and languageid fields may be updated. # do_execsql_test 8.5 { UPDATE t1 SET docid=docid+3, lid=0 WHERE lid=5; } do_execsql_test 8.6 { SELECT docid FROM t1 ORDER BY docid; } {1 2 3 4 5 6} do_execsql_test 8.7 { SELECT docid FROM t1 WHERE t1 MATCH 'A' } {4 6} do_execsql_test 8.8 { SELECT docid FROM t1 WHERE t1 MATCH 'A' AND lid=5 } {} finish_test |