/ File History
Login

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

History of test/join.test

2019-11-03
00:07
The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned. The WHERE clause of the partial index might not be true if the table of the partial index is the right table of a left join. So disable the optimization in that case. Ticket [623eff57e76d45f6] file: [debdadab] check-in: [3be19e11] user: drh branch: trunk, size: 25966
2019-10-29
16:18
Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] file: [832f7c75] check-in: [4d424f30] user: drh branch: trunk, size: 25388
2019-10-10
17:09
Prevent SQLite from assuming that if ((? IS NOT NULL) IS NOT NULL) is true, ? may not be NULL. Fix for [c31034044bb72c89]. file: [b5157538] check-in: [7833feec] user: dan branch: trunk, size: 25389
2019-10-09
21:14
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]. file: [7610c181] check-in: [eb7ed90b] user: dan branch: trunk, size: 24660
2019-08-29
15:50
Fix another case where SQLite assumes that if "~(? AND FALSE)" is true, "?" must be non-null. file: [6ce8296a] check-in: [616f5663] user: dan branch: trunk, size: 24172
2019-08-17
17:07
Ensure the functions that appear to be constant are not factored out of expression that originate on the right-hand side of a LEFT JOIN. Ticket [6710d2f7a13a2997] file: [f505c78a] check-in: [500c9152] user: drh branch: trunk, size: 24034
2019-02-05
14:36
The IS NOT NULL operator does not imply that the operand is never NULL. Fix for ticket [5948e09b8c415bc45da5cf] file: [d53a3662] check-in: [d840e9bb] user: drh branch: trunk, size: 23485
2019-01-17
14:34
Limit the size of SrcList objects to 200 entries (compile-time configurable using -DSQLITE_MAX_SRCLIST=n). The maximum number of tables in a join has always been 64, so this is not a real constraint on capability. Limiting the size of a SrcList prevents DOS attacks (discovered by OSSFuzz) using crazy nexted CTE joins. file: [b6f771f4] check-in: [7cac614d] user: drh branch: trunk, size: 23087
2018-04-10
15:31
Fix a problem causing the LEFT JOIN strength reduction optimization to be incorrectly applied in some cases where the WHERE clause of the query contains a filter expression of the form "lhs.x IS NOT ?". file: [2ad9d7fe] check-in: [1fdaf2c3] user: dan branch: trunk, size: 22902
12:10
Fix a problem causing the LEFT JOIN strength reduction optimization to be incorrectly applied in some cases where the WHERE clause of the query contains a filter expression of the form NOT(x AND y). Ticket [1e39b966]. file: [6fa8e2ba] check-in: [38d319c1] user: dan branch: trunk, size: 22774
2018-03-24
15:47
Yet another fault in the sqlite3ExprImpliesNotNull() routine, causing errors in the LEFT JOIN strength reduction optimization of check-in [dd568c27b1d76563]. file: [730e3e8d] check-in: [e88cf3d4] user: drh branch: trunk, size: 22636
13:24
Bug fix in the LEFT JOIN strength reduction optimization of check-in [dd568c27b1d76563]. The sqlite3ExprImpliesNotNull() routine was mistakenly assuming that a CASE expression must always be NULL if contained any reference to a variable that was NULL. file: [cffed24d] check-in: [cf171abe] user: drh branch: trunk, size: 22512
2017-06-20
17:43
Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL". Fix for ticket [892fc34f173e99d8]. file: [442c462e] check-in: [48346268] user: dan branch: trunk, size: 20660
2017-05-25
00:08
The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. file: [302f164f] check-in: [77fc2301] user: drh branch: trunk, size: 20155
2017-05-23
15:21
Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. file: [a26e4c45] check-in: [44b21e35] user: drh branch: trunk, size: 19573
12:36
Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. file: [89087a32] check-in: [941d8142] user: drh branch: trunk, size: 19180
01:21
When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. file: [5cab75bb] check-in: [92c17850] user: drh branch: trunk, size: 19036
2015-06-08
18:48
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. file: [f9d4a28d] check-in: [0d9edfab] user: dan branch: vtab-left-join, size: 18560
2014-07-18
17:39
SQLite has long accepted some unadvertised and non-standard join syntax. Add a test to ensure that future versions continue to accept this non-standard syntax, to avoid breaking legacy applications that use the undefined syntax. file: [52d4d49f] check-in: [824dde7f] user: drh branch: trunk, size: 17857
2014-03-05
19:13
Avoid running a couple of test cases that use realloc() extensively if SQLITE_MEMDEBUG is defined. file: [559b81eb] check-in: [e406d4bb] user: dan branch: trunk, size: 17363
16:15
Add tests to join.test to verify that it is not possible to use more than 64 tables in a join. file: [533dc4c1] check-in: [ef1a9986] user: dan branch: trunk, size: 17002
2009-10-19
15:52
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]. file: [8d63cc4d] check-in: [6fe63711] user: dan branch: trunk, size: 15985
2009-07-01
16:12
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) file: [a79084b0] check-in: [29b48972] user: danielk1977 branch: trunk, size: 14268
2008-12-05
00:00
Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979) file: [c5696c7e] check-in: [06d206ef] user: drh branch: trunk, size: 14246
2008-08-14
00:19
Do not flatten the right term of a LEFT join. Ticket #3300. (CVS 5565) file: [e0664af7] check-in: [8947c72f] user: drh branch: trunk, size: 12856
2008-07-09
14:47
Add a test case to join.test. No code changes, no bugs found. (CVS 5384) file: [fc6c4e21] check-in: [417aa158] user: danielk1977 branch: trunk, size: 12527
2008-07-08
23:40
Remove obsolete code from select.c, including the "affinity" parameter to the sqlite3Select() module. (CVS 5380) file: [f6aab432] check-in: [cbd3c158] user: drh branch: trunk, size: 12047
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [af044318] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 11326
2006-03-02
04:44
Allow WHERE clause terms on the left table of a LEFT OUTER JOIN to contain aggregate subqueries. Ticket #1697. (CVS 3117) file: [a74f84f8] check-in: [a286e54e] user: drh branch: trunk, size: 11273
2005-06-06
17:11
Avoid ambiguous column name errors when the column name is in the USING clause of a join. Ticket #743. (CVS 2495) file: [db380273] check-in: [6a51bdee] user: drh branch: trunk, size: 10932
16:59
Naming the join columns in the result set of a natural join does not result in an "ambiguous column name" error. Ticket #1217. (CVS 2494) file: [8d17a014] check-in: [265fb607] user: drh branch: trunk, size: 10848
2005-01-21
15:52
Final preparations for the 3.1.0 alpha release. (CVS 2255) file: [e0847127] check-in: [17122c7e] user: drh branch: trunk, size: 10765
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [95ee10ed] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 10751
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [a61c9328] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 10646
2005-01-18
17:40
Make sure USING and NATURAL work on joins even if the columns are renamed using an AS phrase. Ticket #523. (CVS 2233) file: [59e5abff] check-in: [c06add57] user: drh branch: trunk, size: 10590
16:02
Column names coming back from a SELECT are now just the name of the source column without the "table." prefix. In other words, "PRAGMA short_column_names=ON" is now the default. This makes the names of columns behave more like other SQL engines. The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231) file: [76a64509] check-in: [9295050a] user: drh branch: trunk, size: 9971
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [ea8c77b9] check-in: [007be591] user: danielk1977 branch: trunk, size: 10209
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [4bee854e] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 10164
2003-09-27
13:39
Remove support for the Oracle8 outer join syntax. (CVS 1106) file: [9ef6aaba] check-in: [824430b3] user: drh branch: trunk, size: 10082
2003-06-16
00:40
Do not flatten a subquery which is the right term of a LEFT OUTER JOIN if the subquery contains a WHERE clause. Ticket #350. (CVS 1027) file: [54e770b7] check-in: [dd8943e8] user: drh branch: trunk, size: 11312
2003-05-06
20:35
Restrain the flattener in the presence of outer joins. Ticket #306. (CVS 958) file: [16c91ec2] check-in: [6d4b6597] user: drh branch: trunk, size: 10168
2003-02-20
01:48
When the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY make sure that key is NULL if there is no row in the right table that matches the current row in the left table. Tickets #246 and #247. (CVS 873) file: [c97267c1] check-in: [6a45fe3b] user: drh branch: trunk, size: 9383
2002-10-27
19:35
Minimal support for oracle8 outer join syntax. (CVS 771) file: [178b25dc] check-in: [31df3690] user: drh branch: trunk, size: 8640
2002-09-30
12:36
Fix a bug in the left outer join logic. (CVS 758) file: [05d2cd1a] check-in: [6c0f44bd] user: drh branch: trunk, size: 7410
2002-07-31
19:50
Fix for ticket #124: Fix a stack VDBE overflow problem on joins on an INTEGER PRIMARY KEY. (CVS 700) file: [90a620f2] check-in: [fe329e07] user: drh branch: trunk, size: 6808
2002-07-01
12:27
Fix for tickets #90 and #89: Make the AS keyword optional again. (CVS 654) file: [75561ec0] check-in: [1f8a73b1] user: drh branch: trunk, size: 5627
2002-06-28
12:18
Additional test cases added. The following bug fixed: A segfault was occurring if a VIEW consisted of a join with a USING clause. (CVS 651) file: [89bd9954] check-in: [96515b81] user: drh branch: trunk, size: 5617
2002-05-25
00:18
Additional testing of LEFT OUTER JOIN. (CVS 588) file: [ea6a4097] check-in: [d8d04c14] user: drh branch: trunk, size: 5218
2002-05-24
20:31
Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) file: [905f4b13] check-in: [99bd1f5b] user: drh branch: trunk, size: 1873 Added