| Ticket Hash: | 9861b74ab9bf250b8850c577ebad87d6e0a1f645 | ||
| Title: | Fts3 offsets() function may report SQLITE_CORRUPT with empty string. | ||
| Status: | Closed | Type: | Code_Defect |
| Severity: | Important | Priority: | Immediate |
| Subsystem: | Unknown | Resolution: | Overcome_By_Events |
| Last Modified: | 2011-10-13 18:25:15 | ||
| Version Found In: | 3.6.23 | ||
| Description: | ||||
The last statement in this script returns SQLITE_CORRUPT.
CREATE VIRTUAL TABLE ft USING fts3(one, two);
INSERT INTO ft VALUES('', 'foo');
INSERT INTO ft VALUES('foo', 'foo');
SELECT offsets(ft) FROM ft WHERE ft MATCH 'foo';
drh added on 2011-10-13 18:25:15: | ||||