SQLite

All files named ”test/rowvalue3.test”
Login

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

History for test/rowvalue3.test

2025-04-10
10:18
[103e9a224c] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 6706)
2022-06-01
20:08
[1347e25ca1] part of check-in [5f0582b90f] New test cases for row values and RIGHT JOIN. (check-in: [5f0582b90f] user: drh branch: trunk, size: 6710)
2016-11-17
13:13
[3068f50875] part of check-in [005d5b8706] Disable the query flattener optimization for SELECT statements that are on the RHS of vector IN operators. This is a hack that fixes the bug described in ticket [da7841375186386c]. A better solution that does not disable the query flattener is needed, but this will server for the time being. (check-in: [005d5b8706] user: drh branch: trunk, size: 6685)
2016-08-23
19:02
[01399b7bf1] part of check-in [838c50a5bf] Simplify the row value misuse error message. (check-in: [838c50a5bf] user: drh branch: rowvalue, size: 6212)
2016-08-02
17:07
[dbe9352608] part of check-in [e2ad30c8b5] Fix a problem with vector range constraints and mixed ASC/DESC indexes. (check-in: [e2ad30c8b5] user: dan branch: rowvalue, size: 6214)
2016-07-29
18:12
[5127afb441] part of check-in [4dfebff292] Change the way "(a, b) = (SELECT *)" expressions are handled in where.c if there is an index on one of the columns only. (check-in: [4dfebff292] user: dan branch: rowvalue, size: 6469)
2016-07-27
19:33
[587c105601] part of check-in [719a3b2035] Fix some problems with multi-column IN(SELECT...) processing. (check-in: [719a3b2035] user: dan branch: rowvalue, size: 6326)
2016-07-26
18:06
[eeec47b4de] part of check-in [061b800603] Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. (check-in: [061b800603] user: dan branch: rowvalue, size: 2687)
2016-07-23
20:24
Added: [72a9fe5ad3] part of check-in [e2fd6f49b1] Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause). (check-in: [e2fd6f49b1] user: dan branch: rowvalue, size: 1683)