Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/in4.test
2025-02-27
| ||
21:17 | [e7b1456d42] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 14370) | |
2024-03-17
| ||
16:01 | [bb767ec1cf] part of check-in [0eb2fbb891] Omit the "noop(X)" test SQL function. Accomplish the same thing using the idiom: "coalesce(X,random())". (check-in: [0eb2fbb891] user: drh branch: exp-values-clause2, size: 14370) | |
2024-03-16
| ||
17:04 | [176719161b] part of check-in [dae669245c] Extend the scope expr-is-constant for function to cover the IN-to-EQ optimization. (check-in: [dae669245c] user: drh branch: enhanced-expr-is-const, size: 14371) | |
2021-11-02
| ||
20:52 | [fdd1d8134d] part of check-in [266e9cbada] Proposed fix for a problem associated with OP_SeekScan that results in an incorrect answer. See ticket [5981a8c041a3c2f3]. (check-in: [266e9cbada] user: drh branch: seekscan-fix-20211102, size: 14362) | |
2021-06-25
| ||
14:48 | [e09987d4f2] part of check-in [d4bf5243f2] The OP_ReopenIdx opcode should clear the cursor if the cursor is being reused. This prevents leaving the cursor in an initialized state which could cause problems for a subsequent OP_SeekScan opcode. Fix for ticket [6dcbfd11cf666e21] and the OP_SeekScan optimization of check-in [4a43430fd23f8835]. (check-in: [d4bf5243f2] user: drh branch: trunk, size: 13768) | |
2021-06-13
| ||
19:14 | [addf1416fd] part of check-in [d6803ed8dc] The opcode that preceeds OP_SeekScan is usually OP_IdxGT but can sometimes be OP_IdxGE. Adjust asserts accordingly. Follow-up to [9a2ab6092d644fc3]. dbsqlfuzz e41762333a4d6e90a49e628f488d0873b2dba4c5 (check-in: [d6803ed8dc] user: drh branch: trunk, size: 12960) | |
2021-06-02
| ||
18:50 | [3ce7e79419] part of check-in [a87f8ecd6d] Fix an ALWAYS which can be false. (check-in: [a87f8ecd6d] user: drh branch: seekscan-improvements, size: 11992) | |
17:14 | [3f68dd68bd] part of check-in [d0b9861908] Never use WHERE_IN_SEEKSCAN for the 2nd or subsequent IN operator. (check-in: [d0b9861908] user: drh branch: seekscan-improvements, size: 11567) | |
2021-03-20
| ||
15:11 | [cd08375ba4] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 10401) | |
2021-01-27
| ||
17:15 | [64ac9c767a] part of check-in [390cf60a28] Ensure a cursor used by the SeekScan operator does not point to a valid row on the first iteration of the loop. Possible fix for [ee51301f316c09e]. (check-in: [390cf60a28] user: dan branch: fix-2d6e8400, size: 10407) | |
2020-01-04
| ||
17:42 | [65460600d4] part of check-in [b5900914f7] New test cases in test/in4.test require rtree, so disable those tests on builds that lack the rtree extension. (check-in: [b5900914f7] user: drh branch: trunk, size: 9664) | |
16:55 | [0dbdbed683] part of check-in [95ef68966c] Fix a problem where the loop for the RHS of a LEFT JOIN uses values from an IN() clause as the second or subsequent field of an index. (check-in: [95ef68966c] user: dan branch: trunk, size: 9626) | |
2019-08-27
| ||
17:01 | [0f77b0ff37] part of check-in [7f5168a76a] Omit the "x IN (y)" to "x==y" optimization of check-in [e68b427afbc82e20] (and ticket [e39d032577df6942]) as it causes difficult affinity problems as demonstrated by ticket [dbaf8a6820be1ece] and the original assertion fault is no longer a factor due to countless other changes of the previous 5 years. (check-in: [7f5168a76a] user: drh branch: trunk, size: 9055) | |
2014-08-02
| ||
21:03 | [d2b38cba40] part of check-in [436e884215] 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. (check-in: [436e884215] user: drh branch: IN-operator-improvements, size: 8911) | |
2014-03-20
| ||
17:03 | [41c1c031aa] part of check-in [2ea4a9f75f] 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. (check-in: [2ea4a9f75f] user: drh branch: trunk, size: 8899) | |
14:56 | [1820238900] part of check-in [2ff3b25f40] 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] (check-in: [2ff3b25f40] user: drh branch: trunk, size: 7811) | |
13:26 | [ed42587bed] part of check-in [e68b427afb] 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]. (check-in: [e68b427afb] user: drh branch: trunk, size: 6342) | |
2009-06-05
| ||
17:09 | [64f3cc1acd] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 3905) | |
2009-01-24
| ||
09:56 | [f795d65cbc] part of check-in [f3c09a0cb8] Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202) (check-in: [f3c09a0cb8] user: danielk1977 branch: trunk, size: 3914) | |
2008-11-24
| ||
15:32 | [9bfd9226a8] part of check-in [8502fba37b] Added test case to in4.test to try and duplicate crash reported on the mailing list. (CVS 5951) (check-in: [8502fba37b] user: shane branch: trunk, size: 2750) | |
2008-10-02
| ||
13:50 | Added: [c043f75147] part of check-in [803a1736d5] 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) (check-in: [803a1736d5] user: danielk1977 branch: trunk, size: 2046) | |