SQLite

All files named ”test/rowvalue4.test”
Login

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

History for test/rowvalue4.test

2024-07-03
20:10
[bac9326d1e] part of check-in [c10a1b99d4] Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output. (check-in: [c10a1b99d4] user: drh branch: in-bloom, size: 10157)
2021-03-20
15:11
[441e7e366a] 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: 10101)
2018-12-24
12:09
[02e35f7762] part of check-in [06de44ec9e] Do not generate subroutines for non-static SELECT and EXISTS expressions. Fix up some test cases to account for the minor changes in EXPLAIN QUERY PLAN output. (check-in: [06de44ec9e] user: drh branch: reuse-subqueries, size: 10203)
2018-06-08
21:21
[2b20468da3] part of check-in [30e874661d] Only choose to scan an IN operator rather than use an index if we have real STAT1 data to suggest it is advantageous. (check-in: [30e874661d] user: drh branch: in-scan-vs-index, size: 10189)
2018-05-02
18:00
[cbd1cead27] 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: 10183)
2016-09-05
12:12
[4b556d7de1] part of check-in [ae127bcc0a] Do vector comparison size checking early - at name resolution time - to forestall future problems. (check-in: [ae127bcc0a] user: drh branch: rowvalue, size: 10344)
12:02
[9b60544dcd] 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: 10222)
09:44
[29494f1c66] part of check-in [42670935ab] Fix a crash that could occur under certain circumstances if the vectors on either side of a comparison operator were of a different size. (check-in: [42670935ab] user: dan branch: rowvalue, size: 10368)
2016-08-23
19:02
[9b40c9be9b] part of check-in [838c50a5bf] Simplify the row value misuse error message. (check-in: [838c50a5bf] user: drh branch: rowvalue, size: 10246)
2016-08-20
15:01
[318cdd40e6] part of check-in [203f07c5e1] Fix a segfault that could occur if a query that used a vector comparison contained certain types of syntax errors. (check-in: [203f07c5e1] user: dan branch: rowvalue, size: 10282)
2016-08-11
12:01
[ed3f797409] part of check-in [8278be06fa] Fix some problems with handling "no such collation sequence" errors. (check-in: [8278be06fa] user: dan branch: rowvalue, size: 9811)
2016-08-08
18:42
[8d3b26c7ab] part of check-in [bb60651163] Fix the EXPLAIN QUERY PLAN output for row value range constaints that use an index. (check-in: [bb60651163] user: dan branch: rowvalue, size: 9304)
2016-08-03
18:00
[1f0fa2d6e4] part of check-in [3c2f908f5b] Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. (check-in: [3c2f908f5b] user: dan branch: rowvalue, size: 8462)
16:39
[b902e05354] part of check-in [1559f4c434] Fix another problem involving vector range constraints and mixed ASC/DESC indexes. (check-in: [1559f4c434] user: dan branch: rowvalue, size: 7816)
16:14
[86a04529ab] part of check-in [18af74abc8] Fix stat4-based cost estimates for vector range constraints. (check-in: [18af74abc8] user: dan branch: rowvalue, size: 7631)
2016-08-02
18:50
[9aa6a5efe6] part of check-in [092b1c5ff5] Add tests and fixes for vector operations that use sub-queries with different combinations of LIMIT, OFFSET and ORDER BY clauses. (check-in: [092b1c5ff5] user: dan branch: rowvalue, size: 5323)
17:07
[9e720652d4] 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: 3727)
2016-07-28
19:47
Added: [4480898d62] part of check-in [cc3f6542be] Fix further issues with multi-column IN(...) operators. Also some error handling cases surrounding row values. (check-in: [cc3f6542be] user: dan branch: rowvalue, size: 1510)