aboutsummaryrefslogtreecommitdiff
path: root/test/where.test
Commit message (Expand)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
* Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.dan2023-02-06
* Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reducedrh2023-01-30
* Fix a (harmless) off-by-one error in code generation that comes up whendrh2022-12-07
* Tuning the query planner by adjusting the weights that predict the relativedrh2022-12-03
* Fix a bug in the sqlite3WhereMalloc() routines that were added bydrh2022-05-10
* Fix handling of "continue" and "break" from inside the loop for the rightdrh2022-04-11
* Exclude two recently added tests in where.test from valgrind runs. They fail ...dan2021-11-23
* More precision in comparing integers and floating point values whiledrh2021-07-19
* Revise tests cases to align with the new EXPLAIN QUERY PLAN output.drh2021-03-20
* Improvements to the IN-early-out optimization so that it works moredrh2020-09-01
* Provide "sqlite_schema" as an alternative name to the table that holds thedrh2020-06-15
* Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that theydrh2019-08-22
* Remove support for STAT3. The sqlite_stat3 tables are ignored, if theydrh2019-08-08
* Add further tests so that veryquick.test covers all vdbe branches.dan2019-04-05
* Check-in [fa792714ae62fa980] is not a valid fix for ticketdrh2019-02-22
* Disable the IS NOT NULL optimization when the IS NOT NULL operator is partdrh2018-11-05
* Add a small cost penalty to sorting to bias the query planner in favor ofdrh2018-07-28
* Test cases.drh2018-06-07
* Remove a recently added NEVER() macro from a branch that can be taken indan2018-04-24
* Do not attempt to use terms from the WHERE clause to drive indexes on thedrh2018-04-24
* All the OR optimization to proceed even if the OR is also converted intodrh2018-04-24
* Remove a debuggin "exit" command mistakenly left in the "where.test" module.drh2016-02-26
* Fix an incorrect cost computation for sorting (introduced just a fewdrh2016-02-25
* Improvements and simplifications to the equality seek logic. Tests aredrh2015-11-05
* Continue to support the (broken) legacy syntax of allowing strings fordrh2015-09-04
* Add testcase() macros and comments and a few test-cases.drh2015-05-13
* Seek past NULLs in a top-constrained search. Avoid checking for NULLs indrh2014-02-14
* Fix test cases so that they work when the query planner uses index sizedrh2013-10-04
* Make sure the omit-noop-left-join optimization is not applied if columnsdrh2013-09-03
* "make test" now passing.drh2013-06-12
* Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closerdrh2013-06-11
* Futher simplifications to the NGQP. Fix some test cases to usedrh2013-05-30
* Loop through the elements on the RHS of an IN operator in reverse order whendrh2013-02-08
* Allow an index to be used for sorting even if prior terms of the indexdrh2013-02-07
* Disable a couple of tests in where.test when running the "no_optimization" pe...dan2012-12-05
* Fix a query planner problem that only occurs when covering-index-scan isdrh2012-10-03
* Fix some corner case behavior in the new ORDER BY optimization logic.drh2012-09-27
* More test cases an bug fixes for the ORDER BY optimization of joins. Alldrh2012-09-27
* Attempt to use a covering index even on a full table scan, under the theorydrh2012-09-15
* Fix for 2a5629202f. When considering whether or not a UNIQUE index may be use...dan2012-04-20
* Fix a bug reported on the mailing list triggered by the pattern "SELECT <col>...danielk19772008-11-03
* Add the experimental sqlite3_stmt_status() interface. (CVS 5781)drh2008-10-07
* Fix a bug in where.c where a non-temp register was being incorrectly dealloca...danielk19772008-10-01
* Defer deleting Table objects associated with flattened subqueries untildrh2008-09-01
* Increased test coverage. (CVS 5414)drh2008-07-15
* Remove leftover debugging commands (breakpoint and btree_breakpoint) fromdrh2008-07-12
* When using an index to scan a database table, read column data from the index...danielk19772007-11-29
* Fix for #2445. A bug in the lookupName() logic that could cause a crash when ...danielk19772007-06-25
* Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CV...drh2007-05-14