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 | SQL archive |
| Timelines: | family | ancestors | fts-languageid-bits |
| Files: | files | file ages | folders |
| SHA1: |
949425d467947c3905cca3e08750fbaf |
| User & Date: | dan 2013-06-20 19:55:50 |
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: 949425d4 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: 81527768 user: dan tags: fts-languageid-bits | |
Changes
Changes to test/fts4langid2.test.
310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 |
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.2 {
SELECT docid FROM t1 WHERE t1 MATCH 'ghi' ORDER BY docid;
} {2 3}
do_execsql_test 8.2 {
SELECT docid FROM t1 WHERE t1 MATCH 'ghi' ORDER BY docid DESC;
} {3 2}
finish_test
|
< | < | > > > > > > > |
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
|