index
:
sqlite
master
sqlite mirror
about
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
test
/
where.test
Commit message (
Expand
)
Author
Age
*
Remove unnecessary "www." prefixes on domain names in URLs.
drh
2025-04-10
*
Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.
dan
2023-02-06
*
Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reduce
drh
2023-01-30
*
Fix a (harmless) off-by-one error in code generation that comes up when
drh
2022-12-07
*
Tuning the query planner by adjusting the weights that predict the relative
drh
2022-12-03
*
Fix a bug in the sqlite3WhereMalloc() routines that were added by
drh
2022-05-10
*
Fix handling of "continue" and "break" from inside the loop for the right
drh
2022-04-11
*
Exclude two recently added tests in where.test from valgrind runs. They fail ...
dan
2021-11-23
*
More precision in comparing integers and floating point values while
drh
2021-07-19
*
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh
2021-03-20
*
Improvements to the IN-early-out optimization so that it works more
drh
2020-09-01
*
Provide "sqlite_schema" as an alternative name to the table that holds the
drh
2020-06-15
*
Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that they
drh
2019-08-22
*
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
drh
2019-08-08
*
Add further tests so that veryquick.test covers all vdbe branches.
dan
2019-04-05
*
Check-in [fa792714ae62fa980] is not a valid fix for ticket
drh
2019-02-22
*
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part
drh
2018-11-05
*
Add a small cost penalty to sorting to bias the query planner in favor of
drh
2018-07-28
*
Test cases.
drh
2018-06-07
*
Remove a recently added NEVER() macro from a branch that can be taken in
dan
2018-04-24
*
Do not attempt to use terms from the WHERE clause to drive indexes on the
drh
2018-04-24
*
All the OR optimization to proceed even if the OR is also converted into
drh
2018-04-24
*
Remove a debuggin "exit" command mistakenly left in the "where.test" module.
drh
2016-02-26
*
Fix an incorrect cost computation for sorting (introduced just a few
drh
2016-02-25
*
Improvements and simplifications to the equality seek logic. Tests are
drh
2015-11-05
*
Continue to support the (broken) legacy syntax of allowing strings for
drh
2015-09-04
*
Add testcase() macros and comments and a few test-cases.
drh
2015-05-13
*
Seek past NULLs in a top-constrained search. Avoid checking for NULLs in
drh
2014-02-14
*
Fix test cases so that they work when the query planner uses index size
drh
2013-10-04
*
Make sure the omit-noop-left-join optimization is not applied if columns
drh
2013-09-03
*
"make test" now passing.
drh
2013-06-12
*
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer
drh
2013-06-11
*
Futher simplifications to the NGQP. Fix some test cases to use
drh
2013-05-30
*
Loop through the elements on the RHS of an IN operator in reverse order when
drh
2013-02-08
*
Allow an index to be used for sorting even if prior terms of the index
drh
2013-02-07
*
Disable a couple of tests in where.test when running the "no_optimization" pe...
dan
2012-12-05
*
Fix a query planner problem that only occurs when covering-index-scan is
drh
2012-10-03
*
Fix some corner case behavior in the new ORDER BY optimization logic.
drh
2012-09-27
*
More test cases an bug fixes for the ORDER BY optimization of joins. All
drh
2012-09-27
*
Attempt to use a covering index even on a full table scan, under the theory
drh
2012-09-15
*
Fix for 2a5629202f. When considering whether or not a UNIQUE index may be use...
dan
2012-04-20
*
Fix a bug reported on the mailing list triggered by the pattern "SELECT <col>...
danielk1977
2008-11-03
*
Add the experimental sqlite3_stmt_status() interface. (CVS 5781)
drh
2008-10-07
*
Fix a bug in where.c where a non-temp register was being incorrectly dealloca...
danielk1977
2008-10-01
*
Defer deleting Table objects associated with flattened subqueries until
drh
2008-09-01
*
Increased test coverage. (CVS 5414)
drh
2008-07-15
*
Remove leftover debugging commands (breakpoint and btree_breakpoint) from
drh
2008-07-12
*
When using an index to scan a database table, read column data from the index...
danielk1977
2007-11-29
*
Fix for #2445. A bug in the lookupName() logic that could cause a crash when ...
danielk1977
2007-06-25
*
Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CV...
drh
2007-05-14
[next]