/ All files named "test/bestindex1.test"
Login

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

History for test/bestindex1.test

2019-03-29
13:17
[705b57d7] part of check-in [f5752517] Fix a fairly obscure problem causing the planner to sometimes choose sub-optimal plans for a query with a single virtual table in the FROM clause, and at least one IN(...) constraint in the WHERE clause. (check-in: [f5752517] user: dan branch: trunk, size: 8363)
2018-05-02
18:00
[852170bd] 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: 6559)
2018-04-24
01:10
[a9b83161] part of check-in [8bc0207a] In EXPLAIN QUERY PLAN output, do not show an EXECUTE LIST SUBQUERY line for IN operators where the RHS is a list and not a subquery, since in that case there is no SUBQUERY to execute. (check-in: [8bc0207a] user: drh branch: trunk, size: 6541)
2016-04-09
18:04
[0cf1bd2d] part of check-in [6c56b3a0] Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: [6c56b3a0] user: drh branch: trunk, size: 6683)
2016-03-09
11:59
[d5ba89a7] part of check-in [e0bac2f3] Disable the bestindex*.test modules when building without virtual table support. (check-in: [e0bac2f3] user: drh branch: trunk, size: 4222)
2016-03-02
16:13
[e228fe1e] part of check-in [d2d28251] Add an extra test for the change on this branch. (check-in: [d2d28251] user: dan branch: vtab-IN-opt, size: 4180)
16:01
[ca4a6457] part of check-in [3c15a9bf] Enhance test_bestindex.c so that it can be used to test plans generated by xBestIndex. (check-in: [3c15a9bf] user: dan branch: trunk, size: 4003)
2016-03-01
22:48
[41c76342] part of check-in [1d41c161] New test cases and infrastructure for testing the xBestIndex method of virtual tables. (check-in: [1d41c161] user: drh branch: trunk, size: 1332)
18:24
[8d8ae7e9] part of check-in [759b9d5b] Allow test_bestindex.c to set the omit flag for a constraint. (check-in: [759b9d5b] user: dan branch: test-bestindex, size: 1339)
18:07
Added: [a7213b26] part of check-in [de034c0d] Add test code useful for testing the planners use of teh virtual table xBestIndex() method. (check-in: [de034c0d] user: dan branch: test-bestindex, size: 1334)