/ File History
Login

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

History of test/where.test

2019-04-05
20:47
Add further tests so that veryquick.test covers all vdbe branches. file: [0607caa5] check-in: [cbc67de5] user: dan branch: trunk, size: 39956
2019-02-22
21:33
Check-in [fa792714ae62fa980] is not a valid fix for ticket [df46dfb631f75694], as the new test case in this check-in demonstrates. The fix here causes test cases for the [df46dfb631f75694] bug to fail again, so this check-in is on a branch. A new fix is needed for [df46dfb631f75694]. file: [93738e22] check-in: [0d456456] user: drh branch: tkt-df46dfb631, size: 36965
2018-11-05
07:53
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. file: [8215d220] check-in: [af39661e] user: drh branch: trunk, size: 36567
2018-07-28
21:01
Add a small cost penalty to sorting to bias the query planner in favor of plans that do not require a final sorting pass. file: [480cfc17] check-in: [85b9beb4] user: drh branch: trunk, size: 36170
2018-06-07
16:07
Test cases. file: [6bfcd29d] check-in: [085e8637] user: drh branch: multikey-opt-idea, size: 36168
2018-04-24
18:59
Remove a recently added NEVER() macro from a branch that can be taken in obscure circumstances. file: [f19ea3fa] check-in: [2aa21003] user: dan branch: trunk, size: 36168
17:34
Do not attempt to use terms from the WHERE clause to drive indexes on the right table of a LEFT JOIN. Fix for ticket [4ba5abf65c5b0f9a96a7a40cd18b] file: [b8951995] check-in: [aeb694e3] user: drh branch: trunk, size: 35653
16:41
All the OR optimization to proceed even if the OR is also converted into an IN operator. file: [ad770ad7] check-in: [e252c654] user: drh branch: trunk, size: 35230
2016-02-26
04:04
Remove a debugging "exit" command mistakenly left in the "where.test" module. file: [f0c32556] check-in: [beda0b8c] user: drh branch: trunk, size: 34810
2016-02-25
23:21
Fix an incorrect cost computation for sorting (introduced just a few check-ins ago). Should be NlogN, not NloglogN. file: [c33bf57e] check-in: [2459d323] user: drh branch: trunk, size: 34815
2015-11-05
22:30
Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. file: [9902a3d8] check-in: [997ce6c9] user: drh branch: seekeq-experiment, size: 34698
2015-09-04
12:54
Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. file: [66d4c107] check-in: [3d3df79b] user: drh branch: trunk, size: 34699
2015-05-13
17:54
Add testcase() macros and comments and a few test-cases. file: [1ff3d9f8] check-in: [24263d08] user: drh branch: index-is-operator, size: 34627
2014-02-14
23:49
Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. file: [28b64e93] check-in: [e07a32f3] user: drh branch: trunk, size: 33694
2013-10-04
15:58
Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. file: [701a633e] check-in: [2f394de8] user: drh branch: index-scan-rate, size: 33694
2013-09-03
14:03
Make sure the omit-noop-left-join optimization is not applied if columns of the LEFT JOIN are used in the ORDER BY clause. Ticket [be84e357c035] file: [8d66dfbf] check-in: [0303d6bc] user: drh branch: trunk, size: 33671
2013-06-12
17:08
"make test" now passing. file: [da54153a] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 32713
2013-06-11
02:32
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. file: [cd13d480] check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 32711
2013-05-30
19:29
Futher simplifications to the NGQP. Fix some test cases to use EXPLAIN QUERY PLAN rather than the (now obsolete) sqlite_query_plan global variable. file: [054a6b6f] check-in: [ae985db4] user: drh branch: nextgen-query-plan-exp, size: 32719
2013-02-08
18:48
Loop through the elements on the RHS of an IN operator in reverse order when the ORDER BY clauses specifies DESC. file: [15ac8611] check-in: [f78395c8] user: drh branch: IN-with-ORDERBY, size: 32295
2013-02-07
21:15
Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. file: [55f6780f] check-in: [98bf668a] user: drh branch: IN-with-ORDERBY, size: 31581
2012-12-05
19:04
Disable a couple of tests in where.test when running the "no_optimization" permutation. file: [9714e6f2] check-in: [5e961e37] user: dan branch: trunk, size: 31040
2012-10-03
12:38
Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. file: [41b65069] check-in: [0f9bb901] user: drh branch: qp-enhancements, size: 30958
2012-09-27
23:27
Fix some corner case behavior in the new ORDER BY optimization logic. Remove the SQLITE_OrderByIdx bit from the SQLITE_TESTCTRL_OPTIMIZATIONS mask, since enabling it caused many TH3 tests to fail when the NO_OPT configuration parameter was engaged, and since there really isn't any need to turn that optimization off. The SQLITE_OrderByIdxJoin bit remains. file: [a6bfb5a2] check-in: [98b63371] user: drh branch: qp-enhancements, size: 30954
19:53
More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. file: [ea9659ff] check-in: [0d573320] user: drh branch: qp-enhancements, size: 30954
2012-09-15
18:45
Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. file: [59cf231e] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 30926
2012-04-20
15:24
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. file: [4c9f6998] check-in: [9870e4c4] user: dan branch: trunk, size: 30926
2008-11-03
09:06
Fix a bug reported on the mailing list triggered by the pattern "SELECT , (SELECT ... FROM tbl WHERE rowid > ) FROM ...". (CVS 5855) file: [de337a3f] check-in: [6c918c4e] user: danielk1977 branch: trunk, size: 30780
2008-10-07
23:46
Add the experimental sqlite3_stmt_status() interface. (CVS 5781) file: [12396f15] check-in: [de473efb] user: drh branch: trunk, size: 29799
2008-10-01
08:43
Fix a bug in where.c where a non-temp register was being incorrectly deallocated. Ticket #3408. (CVS 5758) file: [7dcfe573] check-in: [59d2e89e] user: danielk1977 branch: trunk, size: 29565
2008-09-01
15:52
Defer deleting Table objects associated with flattened subqueries until all code has been generated, in case some expression node still references the Table object. Ticket #3346. (CVS 5650) file: [ea8e56f3] check-in: [d04d7033] user: drh branch: trunk, size: 28323
2008-07-15
00:27
Increased test coverage. (CVS 5414) file: [4f1b9a40] check-in: [7cf91e08] user: drh branch: trunk, size: 28325
2008-07-12
14:52
Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) file: [a2b6b45a] check-in: [dcb16024] user: drh branch: trunk, size: 28242
2007-11-29
17:43
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) file: [5ff4a1bd] check-in: [061608c7] user: danielk1977 branch: trunk, size: 28267
2007-06-25
16:29
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) file: [1bcde898] check-in: [044ca1c7] user: danielk1977 branch: trunk, size: 28265
2007-05-14
11:34
Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CVS 3991) file: [5c342d6a] check-in: [5627ff74] user: drh branch: trunk, size: 27868
2007-02-06
23:41
Additional tests to give full coverage testing to ticket #2211. (CVS 3630) file: [1d020f50] check-in: [ecb1f2fd] user: drh branch: trunk, size: 27346
13:26
When optimizing out an ORDER BY clause due to uniqueness constraints, make sure unused terms to the right in the ORDER BY clause to not reference other tables in a join. Ticket #2211. Additional test cases needed before closing this ticket. (CVS 3629) file: [1c28457a] check-in: [912faf18] user: drh branch: trunk, size: 27070
2006-12-20
03:24
The query optimizer does a better job of optimizing out ORDER BY clauses that contain the rowid or which use indices that contain the rowid. Ticket #2116. (CVS 3536) file: [8dcc1b1a] check-in: [f245f5c2] user: drh branch: trunk, size: 25168
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) file: [ee7c9a66] check-in: [ce06c123] user: drh branch: trunk, size: 22327
2005-10-06
16:53
More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) file: [75272841] check-in: [edca8913] user: drh branch: trunk, size: 22344
2005-09-08
10:37
The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) file: [ce21f491] check-in: [21adf4bd] user: drh branch: trunk, size: 22344
2005-09-01
17:47
Fix over-aggressive optimization of ORDER BY as reported on the mailing list. (CVS 2655) file: [1e9b990d] check-in: [efbb4bc8] user: drh branch: trunk, size: 22350
12:16
All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) file: [9a5d0aaf] check-in: [81259a01] user: drh branch: trunk, size: 22368
2005-08-24
03:52
After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) file: [8fcdf3e7] check-in: [9f9a2571] user: drh branch: trunk, size: 22368
2005-07-28
16:51
The new optimizer now passes all regression tests. (CVS 2566) file: [b6ab0f64] check-in: [a2121284] user: drh branch: trunk, size: 20481
2005-07-21
03:48
Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) file: [996cd12c] check-in: [ef3a157f] user: drh branch: trunk, size: 20349
2005-07-15
23:24
Fix bugs in the new query plan instrumention logic. (CVS 2549) file: [2d6e6ebe] check-in: [578490c9] user: drh branch: trunk, size: 20350
2005-06-06
17:27
Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211. (CVS 2496) file: [9de2426d] check-in: [0f7af623] user: drh branch: trunk, size: 20012
2005-01-21
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [ffb790df] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 19888
2005-01-11
18:13
Fix for ticket #1062: Correctly handle redundant terms in a WHERE clause. (CVS 2198) file: [0d7c9dad] check-in: [1bee1bb9] user: drh branch: trunk, size: 19416
2004-12-19
00:11
The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) file: [cbe22fb2] check-in: [e5aa4894] user: drh branch: trunk, size: 18759
2004-12-18
18:40
Improvements to the query optimizer. This is a work in progress. (CVS 2169) file: [e092b5c2] check-in: [9b86993f] user: drh branch: trunk, size: 18758
2004-11-22
19:12
Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) file: [6914a446] check-in: [fc8c1393] user: drh branch: trunk, size: 18756
2004-11-03
16:27
Update tests to work even if some features of the library are disabled. (CVS 2050) file: [8a016d44] check-in: [b11fc9b3] user: drh branch: trunk, size: 17305
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [40dcffcb] check-in: [e97c3313] user: drh branch: trunk, size: 17523
2004-05-21
03:01
Eliminate the OP_SortMakeRec and OP_SortCallback opcodes. Sort using the standard record format. (CVS 1426) file: [9c5752b8] check-in: [25643a01] user: drh branch: trunk, size: 17517
02:14
Most sorting problems are fixed. Dead code has been removed. 3 test failures remain but will be fixed by the new function API once it gets implemented. (CVS 1425) file: [c69c5080] check-in: [3b55095e] user: drh branch: trunk, size: 17525
2004-05-19
14:56
Change opcode names and comments to better describe the operation of the incrKey flag. OP_MoveTo becomes OP_MoveGe. (CVS 1407) file: [32135ef3] check-in: [8f249c45] user: drh branch: trunk, size: 17476
13:13
Bug fixes in where.c. The where.test test works again. (CVS 1406) file: [45a816fc] check-in: [7c31e257] user: drh branch: trunk, size: 17475
2003-06-15
23:42
Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) file: [cb3a2ed0] check-in: [c9734c27] user: drh branch: trunk, size: 17475
2003-04-19
17:27
Modify the optimizer so that it does not assume that functions are constant. (CVS 920) file: [d719129a] check-in: [767f1af2] user: drh branch: trunk, size: 17446
16:34
Bug in WHERE clause processing fixed. Ticket #298. (CVS 919) file: [94adbfe5] check-in: [9b619c98] user: drh branch: trunk, size: 16954
2003-04-17
12:44
Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) file: [c473910a] check-in: [98ef6110] user: drh branch: trunk, size: 16878
2002-12-04
22:29
Fix a bug in the reverse scan logic that comes up when the table being scanned is empty. Add additional tests for the reverse scan. (CVS 797) file: [ffaa9161] check-in: [0051c87d] user: drh branch: trunk, size: 16539
21:50
Fixes to the logic that decides if the ORDER BY can be ignored due to the use of an index. Tests updated. (CVS 796) file: [9e6e7e0a] check-in: [bfb9a2aa] user: drh branch: trunk, size: 14509
2002-10-22
23:38
Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) file: [9c1c2c13] check-in: [3b68aa25] user: drh branch: trunk, size: 11692
2002-08-14
03:03
Disable sorting by indices if there is a COLLATE subclause in the ORDER BY clause. (CVS 713) file: [c7aba40a] check-in: [2438da79] user: drh branch: trunk, size: 11368
2002-06-19
14:27
The query optimizer now attempts to satisfy an ORDER BY clause using an index. Sorting is still used if there are no suitable indices. (CVS 628) file: [1f87bec6] check-in: [f09e19b4] user: drh branch: trunk, size: 11051
2002-06-14
22:38
Make the LIMIT clause work even if the destination of the SELECT is something other than a callback. (Ticket #66) (CVS 619) file: [367d7911] check-in: [699cf362] user: drh branch: trunk, size: 8395
2002-06-09
01:55
Added tests for the new IN operator optimizer and fixed a bug that the new tests found. This completes the implementation of enhancement #63. (CVS 612) file: [fe33c2f9] check-in: [2a710e18] user: drh branch: trunk, size: 8395
2002-04-30
19:20
Fix for ticket #31: Do not attempt the flattening optimization if the subselect does not contain a FROM clause. Handle the special case where a WHERE clause is constant. (CVS 548) file: [1d85a7eb] check-in: [24e4cf73] user: drh branch: trunk, size: 6514
2001-12-22
14:49
Bug fixing in the new integer primary key code. (CVS 334) file: [032d581c] check-in: [29cab124] user: drh branch: trunk, size: 6153
2001-11-08
00:45
The new code for taking advantage of inequalities in WHERE clauses is in place. It appears to work. (CVS 305) file: [20b19475] check-in: [262bcd17] user: drh branch: trunk, size: 6142
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [43d5ac94] check-in: [4e926efe] user: drh branch: trunk, size: 4085
2001-08-19
18:19
Add index access methods to the DBBE in preparation for adding a new DBBE for the btree.c module. (CVS 236) file: [75595782] check-in: [c15f6ffc] user: drh branch: trunk, size: 4628
2000-06-12
12:20
:-) (CVS 93) file: [bbab5a30] check-in: [3c0540e6] user: drh branch: trunk, size: 4628 Added