en Copyright 2015 Java http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#d96ab995 Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().FossilOrigin-Name: 21afb81d0a73af39aacd9329b1441faa2b535a52a52036daec89fd303a8b344f List of files: /sqlite-3.40.0/test/bestindex1.test Wed, 02 Feb 2022 19:15:53 +0000 drh <> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#bd24e8fa Preserve and return to the user any error message returned by a failed xConnect() call on an eponymous virtual table that prevents a query from being compiled.FossilOrigin-Name: bbbbeb59a6a14b94dcbaf218cbcfbd39feba4a1df5b37c0e1a955391393eeec4 List of files: /sqlite-3.40.0/test/bestindex1.test Thu, 08 Jul 2021 18:29:25 +0000 dan <Dan Kennedy> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#8210233c Revise tests cases to align with the new EXPLAIN QUERY PLAN output.FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c List of files: /sqlite-3.40.0/test/bestindex1.test Sat, 20 Mar 2021 15:11:29 +0000 drh <> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#35808435 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.FossilOrigin-Name: f5752517f590b37bfc0267650f5800320e22a8ecaba34aa6893281ce8d268026 List of files: /sqlite-3.40.0/test/bestindex1.test Fri, 29 Mar 2019 13:17:50 +0000 dan <dan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#b3f0276b Fix test cases so that they work with the new EXPLAIN QUERY PLAN outputformat. Only some of the cases have been fixed. This is an incrementalcheck-in.FossilOrigin-Name: 5f0e803e33aa557865d5fc830d9202d628de9a94c9757058ca48f1a560702cd3 List of files: /sqlite-3.40.0/test/bestindex1.test Wed, 02 May 2018 18:00:17 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#8349c11d In EXPLAIN QUERY PLAN output, do not show an EXECUTE LIST SUBQUERY line forIN operators where the RHS is a list and not a subquery, since in that casethere is no SUBQUERY to execute.FossilOrigin-Name: 8bc0207abdeeb3ffac003703e78826759f07994698f6cdf40c89c3443ba22a47 List of files: /sqlite-3.40.0/test/bestindex1.test Tue, 24 Apr 2018 01:10:12 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#ba26faa3 Fix a problem in the code generator for joins on virtual tables where theouter loop of the join uses the IN operator.FossilOrigin-Name: 6c56b3a04778bc62ca50307ad838dd301cd91ac2 List of files: /sqlite-3.40.0/test/bestindex1.test Sat, 09 Apr 2016 18:04:28 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#c5644346 Disable the bestindex*.test modules when building without virtual table support.FossilOrigin-Name: e0bac2f3eed900d3a26de339fb7d5963f9b47724 List of files: /sqlite-3.40.0/test/bestindex1.test Wed, 09 Mar 2016 11:59:16 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#9cc24c80 Enhance test_bestindex.c so that it can be used to test plans generated by xBestIndex.FossilOrigin-Name: 3c15a9bf45cd7dae2fbd99123b8dd75ce278d6e4 List of files: /sqlite-3.40.0/test/bestindex1.test Wed, 02 Mar 2016 16:01:41 +0000 dan <dan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#a3a44dd3 Allow test_bestindex.c to set the omit flag for a constraint.FossilOrigin-Name: 759b9d5b22aa60cc1d6b606f81eb7366c28cbcbe List of files: /sqlite-3.40.0/test/bestindex1.test Tue, 01 Mar 2016 18:24:36 +0000 dan <dan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/bestindex1.test#8e4251b6 Add test code useful for testing the planners use of teh virtual table xBestIndex() method.FossilOrigin-Name: de034c0db66298454ae8418949d58eb6e223c0de List of files: /sqlite-3.40.0/test/bestindex1.test Tue, 01 Mar 2016 18:07:43 +0000 dan <dan@noemail.net>