/ 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
[26d4dc3f] part of check-in [ec37744c] 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: [ec37744c] user: drh branch: branch-3.28, size: 4366)
02:02
[9d1077b1] part of check-in [c75c3a3b] 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: [c75c3a3b] user: drh branch: trunk, size: 4366)
2017-08-01
19:53
[6c6a420c] part of check-in [3e02474c] 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: [3e02474c] user: drh branch: trunk, size: 3972)
2013-08-20
17:00
[4d253178] part of check-in [e476408e] Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. (check-in: [e476408e] user: drh branch: trunk, size: 3613)
2010-01-12
23:54
[24c23426] part of check-in [0209f171] Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. (check-in: [0209f171] user: drh branch: trunk, size: 3448)
2009-06-10
19:33
[1d167425] part of check-in [78a391dc] 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: [78a391dc] user: drh branch: trunk, size: 2873)
2009-04-06
12:26
[522469ca] part of check-in [d8c6b28a] Make sure the reverse_unordered_selects pragma works even on unindexed tables that are queried without a WHERE clause (CVS 6453) (check-in: [d8c6b28a] user: drh branch: trunk, size: 2214)
2009-02-23
16:52
Added: [ef8d699d] part of check-in [bc078e00] Add the reverse_unordered_selects pragma. (CVS 6314) (check-in: [bc078e00] user: drh branch: trunk, size: 2061)