/ File History

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

History of test/in4.test

Enhancements to the code generator for the IN operator that result in much faster queries in some cases, for example when the RHS of the IN operator changes for each row of a large table scan. file: [d2b38cba] check-in: [436e8842] user: drh branch: IN-operator-improvements, size: 8911
The "x IN (?)" optimization in check-ins [2ff3b25f40] and [e68b427afb] is incorrect, as demonstrated by the in4-5.1 test case in this check-in. The "COLLATE binary" that was being added to the RHS of IN was overriding the implicit collating sequence of the LHS. This change defines the EP_Generic expression node property that blocks all affinity or collating sequence information in the expression subtree and adds that property to the expression taken from RHS of the IN operator. file: [41c1c031] check-in: [2ea4a9f7] user: drh branch: trunk, size: 8899
Previous check-in is not quite correct. "x IN (?)" is not exactly the same as "x==?" do to collation and affinity issues. The correct converstion should be to "x==(+? COLLATE binary)". The current check-in fixes this problem and provides test cases. Ticket [e39d032577df69] file: [18202389] check-in: [2ff3b25f] user: drh branch: trunk, size: 7811
Convert expressions of the form "X IN (?)" with exactly one value on the RHS of the IN into equality tests: "X=?". Add test cases to verify that statements work correctly on this corner case. Fix for ticket [e39d032577df6942]. file: [ed42587b] check-in: [e68b427a] user: drh branch: trunk, size: 6342
Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) file: [64f3cc1a] check-in: [1fef16ec] user: drh branch: trunk, size: 3905
Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202) file: [f795d65c] check-in: [f3c09a0c] user: danielk1977 branch: trunk, size: 3914
Added test case to in4.test to try and duplicate crash reported on the mailing list. (CVS 5951) file: [9bfd9226] check-in: [8502fba3] user: shane branch: trunk, size: 2750
Optimize queries that contain "WHERE rowid IN (x, y, z...)" by using an intkey btree to store the (x, y, z...) set instead of an index btree. (CVS 5760) file: [c043f751] check-in: [803a1736] user: danielk1977 branch: trunk, size: 2046 Added