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

COMMITS

/ test/join.test
autosetup
May 11, 2023
D
Add [/info/cec6a06508239c09e363?ln=5525-5531|restriction (5)] to the
drh committed
78b404d
May 1, 2023
D
Do not apply the "AND false" optimization if either operand comes from the
drh committed
908dec7
February 27, 2023
D
Further to [46639f682975dac6], the parameters of a table valued function that
drh committed
baef844
September 20, 2022
D
Do not allow EP_InnerON terms to be used on a outer join.
drh committed
0f51aa3
D
Add new test cases that (current) get an incorrect answer.
drh committed
0cc6f78
D
New test cases for query flattening when there are ON clauses and outer joins.
drh committed
4c5c941
June 23, 2022
D
New test cases for query flattening with LEFT JOIN.
drh committed
521e0b6
D
Add back the ability to flatten a LEFT JOIN subquery - previously removed
drh committed
d198183
June 8, 2022
D
New test cases refute check-in [3f45007d544e5f78].
drh committed
a341bae
May 10, 2022
D
New requirement marks.
drh committed
825ecf9
April 21, 2022
D
Ensure correct fg.isNestedFrom values even on crazy parses.
drh committed
825a6bf
April 12, 2022
D
For the bad join type error message "unknown or unsupported join type"
drh committed
0879d5f
April 8, 2022
D
Preliminary code to support RIGHT JOIN. Everything seems to work, except that
drh committed
a76ac88
April 7, 2022
D
Improved technique for parsing the ON and USING clauses of a join is faster
drh committed
d44f8b2
January 16, 2022
D
Fix test cases so that they all still work even with -DSQLITE_DQS=0.
drh committed
7d44b22
September 30, 2020
D
In the query flattener when substituting expression Y in place of expression X,
drh committed
af37115
January 21, 2020
D
Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds.
dan committed
8c812f9
December 28, 2019
D
Fix an instance where the planner might choose to use the OR-optimization when it adds no benefit. The same quirk causes an assert() to fail. This is not a bug in released versions - without the assert() the library still gets the right answer, it just does so less efficiently than it should.
dan committed
51f2b17
December 22, 2019
D
When constructing the virtual MATCH term of the WHERE clause for a virtual
drh committed
6e827fa
December 18, 2019
D
Continue to back away from the LEFT JOIN optimization of check-in [41c27bc0ff1d3135]
drh committed
396afe6
November 30, 2019
D
Do not allow a term in the WHERE clause of the query to qualify a partial
drh committed
ca7a26b
November 3, 2019
D
The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned.
drh committed
db53539
October 29, 2019
D
Remove the legacy_file_format PRAGMA. In its place, provide the
drh committed
66c4890
October 10, 2019
D
Prevent SQLite from assuming that if ((? IS NOT NULL) IS NOT NULL) is true, ? may not be NULL. Fix for [d51a8696].
dan committed
0287c95
October 9, 2019
D
Avoid assuming that an expression that contains the sub-expression (? IS FALSE) or (? IS TRUE) may only be true if ? is non-null. Fix for [a976c487].
dan committed
da03c1e
August 29, 2019
D
Fix another case where SQLite assumes that if "~(? AND FALSE)" is true, "?" must be non-null.
dan committed
b6a9121
August 17, 2019
D
Ensure the functions that appear to be constant are not factored out of
drh committed
9e9a67a
February 5, 2019
D
The IS NOT NULL operator does not imply that the operand is never NULL.
drh committed
d579367
January 17, 2019
D
Limit the size of SrcList objects to 200 entries (compile-time configurable
drh committed
0ad7aa8
April 10, 2018
D
Fix a problem causing the LEFT JOIN strength reduction optimization to be
dan committed
0493222
D
Fix a problem causing the LEFT JOIN strength reduction optimization to be
dan committed
a1054dc
March 24, 2018
D
Yet another fault in the sqlite3ExprImpliesNotNull() routine, causing errors
drh committed
e3eff26
D
Bug fix in the LEFT JOIN strength reduction optimization of
drh committed
2c49206
June 20, 2017
D
Ensure that the query planner knows that any column of a flattened LEFT JOIN
dan committed
bd11a2a
May 25, 2017
D
The TK_IF_NULL_ROW expression node must be treated as a variable that
drh committed
f43ce0b
May 23, 2017
D
Disable the LEFT JOIN flattening optimization for aggregate queries, as it
drh committed
1d1fc5e
D
Ensure that the expression rewriter inside the query flattener decends into
drh committed
eff0a7b
D
When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW
drh committed
3f1e9e0
June 8, 2015
D
If a query contains "FROM t1 LEFT JOIN t2, t3, t4", ensure that tables t3 and t4 are not scanned before t2. The trunk already does this.
dan committed
35175bf
July 18, 2014
D
SQLite has long accepted some unadvertised and non-standard join syntax.
drh committed
71607c7
March 5, 2014
D
Avoid running a couple of test cases that use realloc() extensively if SQLITE_MEMDEBUG is defined.
dan committed
a6eaa63
D
Add tests to join.test to verify that it is not possible to use more than 64 tables in a join.
dan committed
13ef14a
October 19, 2009
D
When generating WHERE clause terms internally for NATURAL and USING joins, identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64].
dan committed
f7b0b0a
July 1, 2009
D
Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832)
danielk1977 committed
bd1a0a4
December 5, 2008
D
Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979)
drh committed
da55c48
August 14, 2008
D
Do not flatten the right term of a LEFT join. Ticket #3300. (CVS 5565)
drh committed
2b300d5
July 9, 2008
D
Add a test case to join.test. No code changes, no bugs found. (CVS 5384)
danielk1977 committed
1023560
July 8, 2008
D
Remove obsolete code from select.c, including the "affinity" parameter
drh committed
a9671a2
June 20, 2006
D
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)
danielk1977 committed
4b2688a
March 2, 2006
D
Allow WHERE clause terms on the left table of a LEFT OUTER JOIN to
drh committed
41714d6