/ History for test/rowvalue.test
Login

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

History for test/rowvalue.test

2019-12-30
23:50
[8964f95b] part of check-in [f481636f] Back out the NEVER() from check-in [40d10e7aad5b8992] because it is reachable after all. Ticket [892575cdba4e1e36] (check-in: [f481636f] user: drh branch: trunk, size: 19977)
2019-11-04
02:05
[c39cc0be] part of check-in [ea20068e] 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: [ea20068e] user: drh branch: trunk, size: 19709)
2019-10-23
18:09
[92dc2c5f] part of check-in [978b2d20] 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: [978b2d20] user: drh branch: trunk, size: 19126)
2019-10-22
19:51
[167919d9] part of check-in [5c118617] 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: [5c118617] user: drh branch: trunk, size: 18410)
11:29
[e923271b] part of check-in [c7da1c01] Previous check-in to fix [b47e3627ecaadbde] was incomplete. This check-in completes the fix and adds a test cases. (check-in: [c7da1c01] user: drh branch: trunk, size: 18121)
2019-08-09
20:26
[a3e729d5] part of check-in [eaf15d9b] Allow the RHS of a row-value IN operator to use a compound query with an ORDER BY clause. (check-in: [eaf15d9b] user: drh branch: trunk, size: 17595)
2018-11-03
13:11
[b8680f07] part of check-in [dcb8c735] 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: [dcb8c735] user: drh branch: trunk, size: 16925)
2018-05-02
18:00
[ef851a80] part of check-in [5f0e803e] 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: [5f0e803e] user: drh branch: rework-EQP, size: 16561)
2018-02-18
17:50
[32861d6a] part of check-in [2df6bbf1] 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: [2df6bbf1] user: drh branch: trunk, size: 16601)
2018-02-13
19:13
[0bc33483] part of check-in [1f300514] Improved test cases for the [f484b65f3d6230593c34f] bug. (check-in: [1f300514] user: drh branch: trunk, size: 16459)
18:48
[a786af33] part of check-in [f3112e67] 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: [f3112e67] user: drh branch: trunk, size: 16411)
2018-01-23
16:38
[e1bd1690] part of check-in [14dfd96f] 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: [14dfd96f] user: dan branch: trunk, size: 13231)
2017-01-03
08:11
[44f3492f] part of check-in [548532fd] Add test cases for the fix in [f12ed3ce]. No problems discovered. (check-in: [548532fd] user: dan branch: trunk, size: 12063)
2017-01-02
23:43
[f4a60835] part of check-in [b9b96437] Test cases for the row-value UPDATE TRIGGER fix. (check-in: [b9b96437] user: drh branch: rowvalue-update-trigger, size: 11161)
2017-01-01
12:44
[1701fb78] part of check-in [2c4d167c] Detect row-value comparison size mismatches even when the size of one operand is obscured by an unexpanded subquery. (check-in: [2c4d167c] user: drh branch: trunk, size: 10572)
2016-12-16
01:00
[cacc565e] part of check-in [8d646905] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905] user: drh branch: trunk, size: 9853)
2016-12-07
15:38
[3f468a9e] part of check-in [433d16ff] 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: [433d16ff] user: dan branch: trunk, size: 9855)
2016-11-23
19:31
[f4dc97fe] part of check-in [c08aff13] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (check-in: [c08aff13] user: dan branch: trunk, size: 8971)
2016-11-11
15:49
[b5a9c0fa] part of check-in [fba5fddb] Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. (check-in: [fba5fddb] user: dan branch: trunk, size: 8421)
2016-10-27
01:02
[bcd78c91] part of check-in [619f5cc7] 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: [619f5cc7] user: drh branch: trunk, size: 8107)
2016-09-05
12:02
[753eb744] part of check-in [56562a03] Catch vector size mismatch problems during name resolution to avoid later problems. (check-in: [56562a03] user: drh branch: early-vector-size-check, size: 7725)
2016-08-24
12:22
[7d8482dd] part of check-in [f41a0391] Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. (check-in: [f41a0391] user: dan branch: rowvalue, size: 7006)
2016-08-23
19:02
[c2b4d043] part of check-in [838c50a5] Simplify the row value misuse error message. (check-in: [838c50a5] user: drh branch: rowvalue, size: 6700)
2016-08-01
20:14
[56b34d31] part of check-in [3ef75d45] Fix a problem with vector range constraints involving the rowid column. And other issues. (check-in: [3ef75d45] user: dan branch: rowvalue, size: 6715)
16:37
[5f00f33f] part of check-in [1f4dba87] Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. (check-in: [1f4dba87] user: dan branch: rowvalue, size: 6262)
2016-07-30
21:02
[f4c06c37] part of check-in [059d0d05] Fix problems with vector == comparisons and NULL values. (check-in: [059d0d05] user: dan branch: rowvalue, size: 6130)
2016-07-29
20:58
[8656a46f] part of check-in [42607366] Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. (check-in: [42607366] user: dan branch: rowvalue, size: 6013)
2016-07-09
20:23
[979738b3] part of check-in [b2204215] Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. (check-in: [b2204215] user: dan branch: rowvalue, size: 3750) Added