Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/where.test
autosetup
February 6, 2023
D
Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.
dan committed
e734207
January 30, 2023
D
Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reduce
drh committed
f7af9ba
December 7, 2022
D
Fix a (harmless) off-by-one error in code generation that comes up when
drh committed
b54f71e
December 3, 2022
D
Tuning the query planner by adjusting the weights that predict the relative
drh committed
1edd0a0
May 10, 2022
D
Fix a bug in the sqlite3WhereMalloc() routines that were added by
drh committed
cc212e4
April 11, 2022
D
Fix handling of "continue" and "break" from inside the loop for the right
drh committed
6134b2d
November 23, 2021
D
Exclude two recently added tests in where.test from valgrind runs. They fail due to the subtly different handling of real numbers under valgrind.
dan committed
619a5f5
July 19, 2021
D
More precision in comparing integers and floating point values while
drh committed
de32461
March 20, 2021
D
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh committed
8210233
September 1, 2020
D
Improvements to the IN-early-out optimization so that it works more
drh committed
fa17e13
June 15, 2020
D
Provide "sqlite_schema" as an alternative name to the table that holds the
drh committed
346a70c
August 22, 2019
D
Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that they
drh committed
3e36480
August 8, 2019
D
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
drh committed
175b8f0
April 5, 2019
D
Add further tests so that veryquick.test covers all vdbe branches.
dan committed
6cf3009
February 22, 2019
D
Check-in [fa792714ae62fa980] is not a valid fix for ticket
drh committed
bc0a55c
November 5, 2018
D
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part
drh committed
383bb4f
July 28, 2018
D
Add a small cost penalty to sorting to bias the query planner in favor of
drh committed
f559ed3
June 7, 2018
D
Test cases.
drh committed
056f539
April 24, 2018
D
Remove a recently added NEVER() macro from a branch that can be taken in
dan committed
ccb9eb7
D
Do not attempt to use terms from the WHERE clause to drive indexes on the
drh committed
c447595
D
All the OR optimization to proceed even if the OR is also converted into
drh committed
cb23e5d
February 26, 2016
D
Remove a debuggin "exit" command mistakenly left in the "where.test" module.
drh committed
c9eaeef
February 25, 2016
D
Fix an incorrect cost computation for sorting (introduced just a few
drh committed
8c098e6
November 5, 2015
D
Improvements and simplifications to the equality seek logic. Tests are
drh committed
b1d607d
September 4, 2015
D
Continue to support the (broken) legacy syntax of allowing strings for
drh committed
edb04ed
May 13, 2015
D
Add testcase() macros and comments and a few test-cases.
drh committed
e0cc3c2
February 14, 2014
D
Seek past NULLs in a top-constrained search. Avoid checking for NULLs in
drh committed
cfc6ca4
October 4, 2013
D
Fix test cases so that they work when the query planner uses index size
drh committed
165674d
September 3, 2013
D
Make sure the omit-noop-left-join optimization is not applied if columns
drh committed
67a5ec7
June 12, 2013
D
"make test" now passing.
drh committed
4fe425a
June 11, 2013
D
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer
drh committed
8a4380d
May 30, 2013
D
Futher simplifications to the NGQP. Fix some test cases to use
drh committed
6fa978d
February 8, 2013
D
Loop through the elements on the RHS of an IN operator in reverse order when
drh committed
2d96b93
February 7, 2013
D
Allow an index to be used for sorting even if prior terms of the index
drh committed
1b8fc65
December 5, 2012
D
Disable a couple of tests in where.test when running the "no_optimization" permutation.
dan committed
e825831
October 3, 2012
D
Fix a query planner problem that only occurs when covering-index-scan is
drh committed
6f0e400
September 27, 2012
D
Fix some corner case behavior in the new ORDER BY optimization logic.
drh committed
a9e3fc0
D
More test cases an bug fixes for the ORDER BY optimization of joins. All
drh committed
5343b2d
September 15, 2012
D
Attempt to use a covering index even on a full table scan, under the theory
drh committed
3f4d1d1
April 20, 2012
D
Fix for 2a5629202f. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values.
dan committed
99f8fb6
November 3, 2008
D
Fix a bug reported on the mailing list triggered by the pattern "SELECT <col>, (SELECT ... FROM tbl WHERE rowid > <col>) FROM ...". (CVS 5855)
danielk1977 committed
3072c5e
October 7, 2008
D
Add the experimental sqlite3_stmt_status() interface. (CVS 5781)
drh committed
d1d3848
October 1, 2008
D
Fix a bug in where.c where a non-temp register was being incorrectly deallocated. Ticket #3408. (CVS 5758)
danielk1977 committed
2d60549
September 1, 2008
D
Defer deleting Table objects associated with flattened subqueries until
drh committed
588a9a1
July 15, 2008
D
Increased test coverage. (CVS 5414)
drh committed
85e9e22
July 12, 2008
D
Remove leftover debugging commands (breakpoint and btree_breakpoint) from
drh committed
e8f52c5
November 29, 2007
D
When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580)
danielk1977 committed
21de2e7
June 25, 2007
D
Fix for #2445. A bug in the lookupName() logic that could cause a crash when a WHERE clause used an alias to refer to an expression in the result-set of the SELECT, and that expression was itself a reference to a table column. (CVS 4122)
danielk1977 committed
c9cf6e3
May 14, 2007
D
Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CVS 3991)
drh committed
4f07e5f
February 6, 2007
D
Additional tests to give full coverage testing to ticket #2211. (CVS 3630)
drh committed
32ffdb7