/ File History
Login

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

History of test/rowvalue.test

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