SQLite

All files named ”test/with2.test”
Login

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

History for test/with2.test

2024-08-20
22:44
[181674a6cc] part of check-in [4fa8235dd5] Fix a name resolution issue with CTEs. (check-in: [4fa8235dd5] user: drh branch: srcitem-opt, size: 16735)
2024-08-17
19:46
[5885f0ef25] part of check-in [a4c59ac3c6] Reduce the size of the SrcItem object by combining fields into a union. (check-in: [a4c59ac3c6] user: drh branch: srcitem-opt, size: 16576)
2021-10-01
20:39
[a1df41b987] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 16571)
2021-08-11
13:48
[f803743b2c] part of check-in [a7ce29a6ef] Do not apply the push-down optimization to CTE subqueries that will be reused in other contexts in where the same optimization is unlikely to be valid. Fix for the bug reported by forum post d496c3d29bc93736. (check-in: [a7ce29a6ef] user: drh branch: trunk, size: 16413)
2021-05-23
17:47
[bbf82609bb] part of check-in [c2066dde53] Do not push a WITH clause onto the processing stack if prior errors have occurred. dbsqlfuzz 6b7a144674e215f06ddfeb9042c873d9ee956ac0. (check-in: [c2066dde53] user: drh branch: trunk, size: 16147)
2021-05-21
21:49
[858070ce1c] part of check-in [94225d6939] If there are errors in a nested CTE, be sure to abandon processing. Do not continue since the parse tree may have been left in a goofy state which could cause use-after-free and segfaults. See forum post aa4a7a3980 for an example. (check-in: [94225d6939] user: drh branch: trunk, size: 15618)
2021-03-19
13:53
[000fb95f1f] part of check-in [d72d865d3e] Correlated CTEs should not generate a materialization subroutine. If they need to be materialized, each use case must be materialized separately. dbsqlfuzz 01b8355086998f0a452cb31208e80b9d29ca739a. (check-in: [d72d865d3e] user: drh branch: trunk, size: 14425)
2021-03-18
18:27
[de3b9070ab] part of check-in [ee86e2f4c5] Disable a test case requiring generate_series when virtual tables are not available. (check-in: [ee86e2f4c5] user: drh branch: trunk, size: 14101)
16:36
[7f890304fa] part of check-in [edbfdcaefa] Remove unnecessary code from sqlite3BtreeClose() and add test cases. (check-in: [edbfdcaefa] user: drh branch: opendup-fix, size: 14060)
2018-01-10
00:40
[e0030e2f02] part of check-in [36b89d728f] Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. (check-in: [36b89d728f] user: drh branch: trunk, size: 9973)
2015-08-24
20:21
[2b40da8836] part of check-in [bed42116ad] Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. (check-in: [bed42116ad] user: drh branch: trunk, size: 9979)
2014-03-21
19:27
[ee227a6635] part of check-in [1f413aca00] Avoid leaking memory in an obscure case where the flattener adds an ORDER BY clause to the recursive part of a recursive query. (check-in: [1f413aca00] user: dan branch: trunk, size: 9971)
2014-01-20
14:17
[2fe78fcd8d] part of check-in [8a973912e9] Do not run the tests in with2.test with SQLITE_OMIT_CTE builds. (check-in: [8a973912e9] user: dan branch: trunk, size: 9410)
2014-01-18
15:59
[67a3347f2d] part of check-in [d38d485e58] Add extra test cases. No changes to code. (check-in: [d38d485e58] user: dan branch: trunk, size: 9365)
08:27
[5f7ea3453c] part of check-in [cccff8a0b4] Avoid spurious "no such table" errors in statements of the form "INSERT INTO tbl WITH xxx AS (...) SELECT * FROM xxx". (check-in: [cccff8a0b4] user: dan branch: trunk, size: 5341)
2014-01-17
20:36
[eaafa54aa7] part of check-in [eecc325afd] Add extra tests to with2.test. (check-in: [eecc325afd] user: dan branch: trunk, size: 4286)
17:40
[21057990b5] part of check-in [a7323838bb] Resolve table names within CTEs in the context in which the CTE is declared, not the context in which it is used. (check-in: [a7323838bb] user: dan branch: trunk, size: 1697)
14:59
Added: [790c4b7ab3] part of check-in [6a549187ed] Fix some problems to do with WITH clauses and name resolution. (check-in: [6a549187ed] user: dan branch: common-table-expr, size: 1270)