- 95cb5cc Code EP_InnerJoin constraints at the same time that EP_FromJoin constraints by drh ยท 3 years, 7 months ago joinD
- b2cc3cf Merge ON-clause constraint usage fix from trunk into the joinD branch. by drh ยท 3 years, 7 months ago
- 11d63eb Fix ON-clause constraint usage for FULL and RIGHT JOINs. by drh ยท 3 years, 7 months ago
- 3b52f80 New test cases using various join types and Bloom filters. Two cases by drh ยท 3 years, 7 months ago
- b557762 Fix CLI use of wrong allocator for free(). by larrybr ยท 3 years, 7 months ago
- 367c146 In the query planner, do not let tables commute across any outer join. by drh ยท 3 years, 7 months ago
- bc33519 Typos cleared from README.md by larrybr ยท 3 years, 7 months ago
- 8aa7f4d Fix the Bloom filter pull-down optimization so that it jumps to the correct by drh ยท 3 years, 7 months ago
- 207f626 Add assert()s to show that jumps always land an an instruction that is between by drh ยท 3 years, 7 months ago
- 56f38db Remove a testcase() macro taht was made obsolete by [a8da85c57e07721d]. by drh ยท 3 years, 7 months ago
- c35f02d Document (in comments) that the SQLITE_FlttnUnionAll bit has a specific value by drh ยท 3 years, 7 months ago
- 7a88099 Fix a harmless compiler warning in sqlite3TreeViewWinFunc() (a routine that by drh ยท 3 years, 7 months ago
- 3a45d30 Improvement on check-in [a193749730d6cfba] so that the subroutine call to by drh ยท 3 years, 7 months ago
- b94182b Bring the comments on sqlite3FindInIndex() into closer alignment with what by drh ยท 3 years, 7 months ago
- bae50d6 Defensive code in sqlite3TreeViewWindow() to fix a compiler warning. by drh ยท 3 years, 8 months ago
- 7497364 Simplified fix to the problem with subroutine reuse in the RIGHT JOIN no-match by drh ยท 3 years, 8 months ago
- 2aa1086 Preserve the COLLATE operator on an index on an expression when resolving by drh ยท 3 years, 8 months ago
- a25bbaf Further improvements to codeEqualityTerm() for cases when an IN operator with by drh ยท 3 years, 8 months ago
- c64f0e7 Enhance the TreeView debugging output for Expr with opcode TK_IN so as to by drh ยท 3 years, 8 months ago
- 3d56653 Enhance the codeEqualityTerm() routine inside the code generator so that it is by drh ยท 3 years, 8 months ago
- 8e8e9de With TreeView, only show the table columns for a SrcItem if the data source by drh ยท 3 years, 8 months ago
- 0c0d052 Multiple enhancements to the TreeView output for SrcItem, cherrypicked from by drh ยท 3 years, 8 months ago
- de7a820 Minor typo fix in a comment, for the benefit of broken IDE syntax highlighters. by drh ยท 3 years, 8 months ago
- 07fd1bf Fix problem with SQLITE_OMIT_VIRTUALTABLE builds. by dan ยท 3 years, 8 months ago
- 22b541b Fix a harmless typo in a comment. by drh ยท 3 years, 8 months ago
- 6099592 When computing STAT1 values using ANALYZE, if a ratio comes out to be between by drh ยท 3 years, 8 months ago
- 9684d71 Fix a test problem in rbubusy.test causing a crash under some circumstances. by dan ยท 3 years, 8 months ago
- 5487cdc Update corruptL.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds. by dan ยท 3 years, 8 months ago
- 3e4314b Fix a problem with automatic indexes introduced by by drh ยท 3 years, 8 months ago
- 0e464b5 Do not allow the push-down optimization on the right table of a RIGHT JOIN. by drh ยท 3 years, 8 months ago autoindex-fix
- 5eb6e09 The pushDownWhereTerms() routine should be using by drh ยท 3 years, 8 months ago
- a9cdb90 Fix a problem with automatic indexes introduced by by drh ยท 3 years, 8 months ago
- 95fe38f Add a new optimizer disabling bit to disable just the UNION ALL branch of the by drh ยท 3 years, 8 months ago
- 7f41756 Avoid unintended side-effects on Parse.nSelect in the by drh ยท 3 years, 8 months ago
- 1a6bac0 Remove NEVER() on branches formerly thought to unreachable by drh ยท 3 years, 8 months ago
- ecb386b Prevent the ORDER BY LIMIT optimization from running if the innermost loop by drh ยท 3 years, 8 months ago
- 30d2aab In debug builds, add extra code to verify that there are no jumps that try to by drh ยท 3 years, 8 months ago
- 6c7e89b Fix false-positives in sqlite3VdbeNoJumpsOutsideSubrtn(). All tests pass now. by drh ยท 3 years, 8 months ago right-join-subrtn-check
- b77c312 For debug builds, if the RIGHT JOIN body subroutine contains a jump that by drh ยท 3 years, 8 months ago
- d6bb600 Make use of the "%!S" format when running ExplainSubquery. by drh ยท 3 years, 8 months ago
- da653b8 Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by by drh ยท 3 years, 8 months ago
- 67f70be Honor the MATERIALIZED keyword on a common table expression by not flattening by drh ยท 3 years, 8 months ago
- 9b843f0 Add test cases to check the handling of SQLITE_BUSY in rbu. by dan ยท 3 years, 8 months ago
- 1ca14b7 Simplification of data structures in the wildcard expander for by drh ยท 3 years, 8 months ago
- 9c2d7aa Minor simplification to the result-set wildcard expander for SF_NestedFrom. by drh ยท 3 years, 8 months ago
- 8318b55 Merge the latest trunk fixes into the right-join branch. by drh ยท 3 years, 8 months ago
- 1c69bc9 Previous fix to join8.test needs a return. by drh ยท 3 years, 8 months ago
- abb4e75 Disable join8.test if the build lacks support for virtual tables. by drh ยท 3 years, 8 months ago
- 11140ad Add support for RIGHT and FULL JOIN. by drh ยท 3 years, 8 months ago
- 6dab33b Fix harmless compiler warnings. by drh ยท 3 years, 8 months ago
- a74b4c4 Fix a harmless uninitialized variable warning in MSVC. by drh ยท 3 years, 8 months ago
- 7e9a56f Fix harmless compiler warnings in the CLI. by drh ยท 3 years, 8 months ago
- 503ad9c Make sure the code generator knows to invoke row-value subroutines which by drh ยท 3 years, 8 months ago
- 825a6bf Ensure correct fg.isNestedFrom values even on crazy parses. by drh ยท 3 years, 8 months ago
- 18f8600 Avoid materializing columns of SF_NestedFrom subqueries that are never used. by drh ยท 3 years, 8 months ago
- 6403e77 For CLI, fix how columnar mode fills in empty portions of wrapped row outputs. by larrybr ยท 3 years, 8 months ago
- 22b410d Small correction to the new bUsed logic of sqlite3ProcessJoin(). by drh ยท 3 years, 8 months ago
- e60ffa3 Merge window function fix from trunk. by drh ยท 3 years, 8 months ago
- 910e57b Remove an unnecessary assignment operation. by drh ยท 3 years, 8 months ago
- 41150bf Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query. by dan ยท 3 years, 8 months ago
- bc656e2 Comment fixes and improvements in sqlite3ProcessJoin(). by drh ยท 3 years, 8 months ago
- 815b782 Improved tracking of nested SELECT objects used to implement by drh ยท 3 years, 8 months ago
- b465a83 Also show the ENAME_SPAN value in sqlite3TreeViewExprList(), if there is one. by drh ยท 3 years, 8 months ago
- d4e9caf Improved TreeView output for ExprList: Show the ENAME_TAB value, if there by drh ยท 3 years, 8 months ago
- 2627cbd Add a new comment to the body of lookupName(). No code changes. by drh ยท 3 years, 8 months ago
- befbb40 Merge the ALTER TABLE fix from trunk. by drh ยท 3 years, 8 months ago
- cbde37d Fix a problem in ALTER TABLE with handling "table.*" expressions within SELECT statements in triggers. by dan ยท 3 years, 8 months ago
- 4d0d071 Improved comment on the JF_LTORJ constant definition. by drh ยท 3 years, 8 months ago
- 3117b7b Fix a NULL-pointer dereference that can occur on an aggregate query that by drh ยท 3 years, 8 months ago
- e32d6a0 Mark an unreachable "just-in-case" branch as unreachable. by drh ยท 3 years, 8 months ago
- de75638 Add 512 new join test cases derived from PostgreSQL output. by drh ยท 3 years, 8 months ago
- 2e61588 Remove unnecessary cases for the resolver. by drh ยท 3 years, 8 months ago
- d737b16 Add the omitted "finish_test" to the end of joinA.test. by drh ยท 3 years, 8 months ago
- 3b8c754 New test cases for RIGHT and FULL JOIN. by drh ยท 3 years, 8 months ago
- 1c2bf41 Fix the query flattener so that it does not flatten a RIGHT or FULL JOIN into by drh ยท 3 years, 8 months ago
- ec39c96 New test cases, including one that gets a different result than Postgres. by drh ยท 3 years, 8 months ago
- f80bb19 Disable the unused EU4_EXPR mode for the IdList object. by drh ยท 3 years, 8 months ago
- 7466d56 Even more test cases. by drh ยท 3 years, 8 months ago
- 23f240b New test cases for parenthesized NATURAL FULL JOINs. by drh ยท 3 years, 8 months ago
- a20922c New test case demonstrating the ability to invoke OP_NullRow on a cursor by drh ยท 3 years, 8 months ago
- 25f2ce6 Merge the btree bug-fix from trunk. by drh ยท 3 years, 8 months ago
- 7348ca4 Ensure that left-hand side WITHOUT ROWID tables are set to OP_NullRow prior by drh ยท 3 years, 8 months ago
- 2e1bcc9 Fix problems with WHERE clauses that follow multiple FULL JOINs. This by drh ยท 3 years, 8 months ago
- 1942d1f Avoid an assert() failure in allocateSpace() triggered by a corrupt database. dbsqlfuzz f022eb0ce64d27808574d1dcde5cf7d002dabde8. by dan ยท 3 years, 8 months ago
- 41db500 Merge the latest fixes from trunk. by drh ยท 3 years, 8 months ago
- e98b71e Improved comment field in the bytecode generated for OP_Column and OP_Rowid. by drh ยท 3 years, 8 months ago
- 088b615 Improved comment field in the bytecode generated for OP_Column and OP_Rowid. by drh ยท 3 years, 8 months ago
- 01a6c16 New RIGHT JOIN test cases, one of which is currently failing. by drh ยท 3 years, 8 months ago
- a1848a5 Change the row-value initialization subroutine call from within the by drh ยท 3 years, 8 months ago
- d875c7e Do not allow an empty table bypass to jump outside of a right-join body by drh ยท 3 years, 8 months ago
- d973268 Fix the sqlite3SrcListAppendList() routine so that it correctly adds by drh ยท 3 years, 8 months ago
- abf86bd Leave sqlite3ProcessJoin() early if an OOM is encountered in the NATURAL by drh ยท 3 years, 8 months ago
- 79a25ee Fix to the coalesce() function generation in the resolver. by drh ยท 3 years, 8 months ago
- d0453f7 When converting a NATURAL JOIN into a JOIN USING, make sure to insert the by drh ยท 3 years, 8 months ago
- a3e2518 Fix to the logic that computes coalesc() functions to resolve USING terms. by drh ยท 3 years, 8 months ago
- f68621f Deal with OP_Return bypass in the RIGHT JOIN subroutine by adding extra by drh ยท 3 years, 8 months ago
- 2bd9f44 Change OP_Return such that if P3 is 1, the Return is a no-op when the by drh ยท 3 years, 8 months ago
- fe14699 Further improvements to USING() processing for RIGHT and FULL JOINs. All by drh ยท 3 years, 8 months ago
- 6fda176 New test cases, one of which is failing, indicating a bug that needs fixing. by drh ยท 3 years, 8 months ago
- 052953a Fix the USING to ON translation so that it works correctly for a sequence by drh ยท 3 years, 8 months ago