SQLite

All files named ”test/in5.test”
Login

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

History for test/in5.test

2024-04-20
19:19
[4fd79c70df] part of check-in [500c67f134] Slight performance improvement for the new code on this branch. (check-in: [500c67f134] user: dan branch: vector-in-fix, size: 7922)
2019-08-17
19:13
[b32ce7f4a9] part of check-in [43e8b14314] When populating an ephemeral b-tree for the RHS of an IN(...) clause, avoid applying an affinity to a value that may be used later on for some other purpose. Fix for [c7a117190]. (check-in: [43e8b14314] user: dan branch: trunk, size: 7388)
2017-04-24
14:16
[7ae37fcd4a] part of check-in [1c1b086223] When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. (check-in: [1c1b086223] user: dan branch: trunk, size: 6907)
2016-09-16
16:30
[6c006e0bcd] part of check-in [a92aee5520] Fix a problem causing incorrect code to be generated for IN constraints like "a IN (1, 2, 3)" where column "a" is a rowid column with an extra UNIQUE index created on it. Ticket [0eab1ac759]. (check-in: [a92aee5520] user: dan branch: trunk, size: 6607)
2016-03-09
15:14
[acc710c12a] part of check-in [d91e57e49f] Add another test case for bug [5e3c8867]. (check-in: [d91e57e49f] user: dan branch: trunk, size: 5938)
2014-11-14
15:28
[1de657472f] part of check-in [55e453aadb] Do not automatically remove the DISTINCT keyword from "a IN (SELECT DISTINCT ...)" expressions. Fix for [db87229497]. (check-in: [55e453aadb] user: dan branch: trunk, size: 5133)
2014-02-06
03:31
[9d8c15bfc9] part of check-in [715fac7749] Use OpenHash instead of OpenEphemeral for the RHS of IN operators if the result is not needed for sorting. (check-in: [715fac7749] user: drh branch: subquery-codegen-refactor, size: 3680)
2012-09-18
19:29
Added: [99f9a40af0] part of check-in [5ded9b6838] Enhance IN processing to allow efficient use of indices with numeric affinities. Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. (check-in: [5ded9b6838] user: drh branch: trunk, size: 3659)