SQLite

All files named ”test/whereA.test”
Login

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

History for test/whereA.test

2020-10-02
12:11
[26d4dc3fd1] part of check-in [ec37744c6e] For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: [ec37744c6e] user: drh branch: branch-3.28, size: 4366)
02:02
[9d1077b117] part of check-in [c75c3a3b75] Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: [c75c3a3b75] user: drh branch: trunk, size: 4366)
2017-08-01
19:53
[6c6a420ca7] part of check-in [3e02474c7b] Split the OP_Last opcode into OP_Last and OP_SeekEnd. Use OP_SeekEnd to position a cursor prior to appending. Ticket [cb91bf4290c211d]. (check-in: [3e02474c7b] user: drh branch: trunk, size: 3972)
2013-08-20
17:00
[4d253178d1] part of check-in [e476408e3c] Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. (check-in: [e476408e3c] user: drh branch: trunk, size: 3613)
2010-01-12
23:54
[24c234263c] part of check-in [0209f17180] Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. (check-in: [0209f17180] user: drh branch: trunk, size: 3448)
2009-06-10
19:33
[1d16742546] part of check-in [78a391dca0] Do not let the reverse_unordered_selects pragma force the use of an index that would not otherwise be used. Ticket #3904. Also: remove an test which is always true. (CVS 6745) (check-in: [78a391dca0] user: drh branch: trunk, size: 2873)
2009-04-06
12:26
[522469ca01] part of check-in [d8c6b28a73] Make sure the reverse_unordered_selects pragma works even on unindexed tables that are queried without a WHERE clause (CVS 6453) (check-in: [d8c6b28a73] user: drh branch: trunk, size: 2214)
2009-02-23
16:52
Added: [ef8d699d87] part of check-in [bc078e0007] Add the reverse_unordered_selects pragma. (CVS 6314) (check-in: [bc078e0007] user: drh branch: trunk, size: 2061)