Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/rowvalue.test
|
2025-04-16
| ||
| 10:53 | [0b02364316] part of check-in [ba7d5bad32] Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. (check-in: [ba7d5bad32] user: drh branch: branch-3.49, size: 24886) | |
|
2025-04-15
| ||
| 21:59 | [9c873b2f6e] part of check-in [d22475b81c] Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. Reported by forum post b9647a113b. Problem introduced by [723f1be3d4a905a6], part of ticket [da78413751863]. (check-in: [d22475b81c] user: drh branch: trunk, size: 24870) | |
|
2025-04-10
| ||
| 10:18 | [6f70e62912] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 24086) | |
|
2022-07-15
| ||
| 12:16 | [baf4fa3ec1] part of check-in [0620e419a9] Fix the whereKeyStats() routine (part of STAT4 processing only) so that it is able to cope with row-value comparisons against the primary key index of a WITHOUT ROWID table. Forum post 3607259d3c. (check-in: [0620e419a9] user: drh branch: trunk, size: 24102) | |
|
2022-06-01
| ||
| 20:08 | [ff1ffa31ce] part of check-in [5f0582b90f] New test cases for row values and RIGHT JOIN. (check-in: [5f0582b90f] user: drh branch: trunk, size: 23249) | |
| 13:01 | [00668659c2] part of check-in [570efa45dd] Fix a typo in a comment in a test case. No changes to code. (check-in: [570efa45dd] user: drh branch: row-value-right-join, size: 22566) | |
|
2022-02-04
| ||
| 13:05 | [228b312f85] part of check-in [9f67ad00cd] For the MULTI-INDEX-OR optimization, when pushing down WHERE clause terms from the main query into the various OR-term subqueries, do not push down slices of a vector comparison, since the right-hand operand of the comparison might have only been initialized in a different OR branch that was not taken. dbsqlfuzz 80a9fade844b4fb43564efc972bcb2c68270f5d1. (check-in: [9f67ad00cd] user: drh branch: trunk, size: 22566) | |
|
2022-01-21
| ||
| 16:41 | [02214016f7] part of check-in [4db5217a28] When computing a vector to be used as a key for an index lookup, do not check for NULL values and abort until after all key values have been computed, in case one of the later key values involves some initialization that is needed by a LEFT JOIN. Fix for the problem identified by Forum post ab95010d410a0a55. (check-in: [4db5217a28] user: drh branch: trunk, size: 21928) | |
|
2021-06-03
| ||
| 18:56 | [37effea4dd] part of check-in [4a587c3492] Fix a case where combining row-value UPDATE FROM syntax with window functions over aggregates can cause an error. dbsqlfuzz ae4516bff08d736f203f09934e2f4d31e0b3e7ce (check-in: [4a587c3492] user: dan branch: trunk, size: 21411) | |
|
2021-03-20
| ||
| 15:11 | [466efbb7bb] 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: 20553) | |
|
2021-03-19
| ||
| 16:29 | [6795850abf] part of check-in [959272c275] Dbsqlfuzz found a new way to make that branch in codeVectorCompare reachable. (check-in: [959272c275] user: drh branch: trunk, size: 20583) | |
|
2021-02-03
| ||
| 12:35 | [b5436c7673] part of check-in [06b15b17be] Fix an assert() that might be off-by-one in the case of a prior errors in the parse. (check-in: [06b15b17be] user: drh branch: trunk, size: 20331) | |
|
2019-12-30
| ||
| 23:50 | [8964f95b25] part of check-in [f481636f1a] Back out the NEVER() from check-in [40d10e7aad5b8992] because it is reachable after all. Ticket [892575cdba4e1e36] (check-in: [f481636f1a] user: drh branch: trunk, size: 19977) | |
|
2019-11-04
| ||
| 02:05 | [c39cc0be5e] part of check-in [ea20068e6d] Fix a false-postive in the sqlite3ExprImpliesNonNullRow() decision routine, that resulted in an incorrect LEFT JOIN strength reduction when the WHERE clause contained a row-value comparison. Ticket [02aa2bd02f97d0f2] (check-in: [ea20068e6d] user: drh branch: trunk, size: 19709) | |
|
2019-10-23
| ||
| 18:09 | [92dc2c5fad] part of check-in [978b2d20cf] When a vector comparison appears in the WHERE clause and the constraint side has a COLLATE clause on the first term of the vector, be sure to honor that COLLATE clause. Ticket [135c9da7513e5a97]. (check-in: [978b2d20cf] user: drh branch: trunk, size: 19126) | |
|
2019-10-22
| ||
| 19:51 | [167919d94f] part of check-in [5c118617cf] Disqualify row-value comparisons for use by an index if the right-hand side has an affinity that does not match the index. Fix for ticket [6ef984af8972c2eb] (check-in: [5c118617cf] user: drh branch: trunk, size: 18410) | |
| 11:29 | [e923271bc7] part of check-in [c7da1c01f1] Previous check-in to fix [b47e3627ecaadbde] was incomplete. This check-in completes the fix and adds a test cases. (check-in: [c7da1c01f1] user: drh branch: trunk, size: 18121) | |
|
2019-08-09
| ||
| 20:26 | [a3e729d5c1] part of check-in [eaf15d9bae] Allow the RHS of a row-value IN operator to use a compound query with an ORDER BY clause. (check-in: [eaf15d9bae] user: drh branch: trunk, size: 17595) | |
|
2018-11-03
| ||
| 13:11 | [b8680f07d1] part of check-in [dcb8c73594] Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: [dcb8c73594] user: drh branch: trunk, size: 16925) | |
|
2018-05-02
| ||
| 18:00 | [ef851a80f7] part of check-in [5f0e803e33] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 16561) | |
|
2018-02-18
| ||
| 17:50 | [32861d6a93] part of check-in [2df6bbf1b8] Fix a memory leak in the processing of nested row values. This problem has existed every since row values support was added (version 3.15.0, 2016-10-14) but was only just now detected by OSSFuzz. (check-in: [2df6bbf1b8] user: drh branch: trunk, size: 16601) | |
|
2018-02-13
| ||
| 19:13 | [0bc33483f2] part of check-in [1f300514e6] Improved test cases for the [f484b65f3d6230593c34f] bug. (check-in: [1f300514e6] user: drh branch: trunk, size: 16459) | |
| 18:48 | [a786af333a] part of check-in [f3112e67cd] Fix an incorrect table lookup used to find the appropriate search operator for a WHERE clause on a row-value inequality. The incorrect table lookup was causing an incorrect answer for the less-than operator. Fix for ticket [f484b65f3d6230593c34f11] (check-in: [f3112e67cd] user: drh branch: trunk, size: 16411) | |
|
2018-01-23
| ||
| 16:38 | [e1bd1690d8] part of check-in [14dfd96f9b] Fix a bug causing spurious "sub-select returns N columns expected 1" errors in join queries with a term like "(a, b) IN (SELECT ...)" in the WHERE clause. Ticket [7310e2fb3d046a5f5]. (check-in: [14dfd96f9b] user: dan branch: trunk, size: 13231) | |
|
2017-01-03
| ||
| 08:11 | [44f3492f41] part of check-in [548532fdcf] Add test cases for the fix in [f12ed3ce]. No problems discovered. (check-in: [548532fdcf] user: dan branch: trunk, size: 12063) | |
|
2017-01-02
| ||
| 23:43 | [f4a60835c9] part of check-in [b9b964373c] Test cases for the row-value UPDATE TRIGGER fix. (check-in: [b9b964373c] user: drh branch: rowvalue-update-trigger, size: 11161) | |
|
2017-01-01
| ||
| 12:44 | [1701fb7861] part of check-in [2c4d167ccd] Detect row-value comparison size mismatches even when the size of one operand is obscured by an unexpanded subquery. (check-in: [2c4d167ccd] user: drh branch: trunk, size: 10572) | |
|
2016-12-16
| ||
| 01:00 | [cacc565ed7] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 9853) | |
|
2016-12-07
| ||
| 15:38 | [3f468a9e37] part of check-in [433d16ff3a] Prevent the flattening or where-term push-down optimizations from obscuring misuses of SQL row values that can lead to crashes or assert() failures. (check-in: [433d16ff3a] user: dan branch: trunk, size: 9855) | |
|
2016-11-23
| ||
| 19:31 | [f4dc97fe52] part of check-in [c08aff13ea] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (check-in: [c08aff13ea] user: dan branch: trunk, size: 8971) | |
|
2016-11-11
| ||
| 15:49 | [b5a9c0fa34] part of check-in [fba5fddb1c] Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. (check-in: [fba5fddb1c] user: dan branch: trunk, size: 8421) | |
|
2016-10-27
| ||
| 01:02 | [bcd78c91fe] part of check-in [619f5cc717] Make sure left-join markings are transferred to the virtual scalar subexpressions when decomposing a vector comparison in the ON clause of a LEFT JOIN. Fix for ticket [fef4bb4bd9185ec8f]. (check-in: [619f5cc717] user: drh branch: trunk, size: 8107) | |
|
2016-09-05
| ||
| 12:02 | [753eb744b7] part of check-in [56562a0346] Catch vector size mismatch problems during name resolution to avoid later problems. (check-in: [56562a0346] user: drh branch: early-vector-size-check, size: 7725) | |
|
2016-08-24
| ||
| 12:22 | [7d8482dde9] part of check-in [f41a0391b7] Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. (check-in: [f41a0391b7] user: dan branch: rowvalue, size: 7006) | |
|
2016-08-23
| ||
| 19:02 | [c2b4d043f4] part of check-in [838c50a5bf] Simplify the row value misuse error message. (check-in: [838c50a5bf] user: drh branch: rowvalue, size: 6700) | |
|
2016-08-01
| ||
| 20:14 | [56b34d31d9] part of check-in [3ef75d45eb] Fix a problem with vector range constraints involving the rowid column. And other issues. (check-in: [3ef75d45eb] user: dan branch: rowvalue, size: 6715) | |
| 16:37 | [5f00f33fb1] part of check-in [1f4dba87da] Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. (check-in: [1f4dba87da] user: dan branch: rowvalue, size: 6262) | |
|
2016-07-30
| ||
| 21:02 | [f4c06c37d8] part of check-in [059d0d0535] Fix problems with vector == comparisons and NULL values. (check-in: [059d0d0535] user: dan branch: rowvalue, size: 6130) | |
|
2016-07-29
| ||
| 20:58 | [8656a46fac] part of check-in [42607366bf] Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. (check-in: [42607366bf] user: dan branch: rowvalue, size: 6013) | |
|
2016-07-09
| ||
| 20:23 | Added: [979738b3d4] part of check-in [b2204215b2] Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. (check-in: [b2204215b2] user: dan branch: rowvalue, size: 3750) | |