/ All files named "test/altertab3.test"
Login

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

History for test/altertab3.test

2020-11-02
00:40
[1db384eb] part of check-in [6646d789] Fix an another OSS-Fuzz discovered assertion fault due to ALTER TABLE and strange triggers. (check-in: [6646d789] user: drh branch: trunk, size: 16683)
2020-10-31
16:33
[b1a3c15f] part of check-in [3e6af890] Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs. (check-in: [3e6af890] user: dan branch: trunk, size: 16401)
2020-07-29
16:18
[822b6498] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 15722)
2020-07-14
19:51
[d0d51e65] part of check-in [4f6d8d0e] Support UPDATE...FROM statements in trigger programs. (check-in: [4f6d8d0e] user: dan branch: update-from, size: 15723)
2019-12-30
06:55
[155b8dc2] part of check-in [a9e0354c] In ALTER TABLE, rename columns and tables in expressions that are optimized out by the "AND 0" optimization. Doing this also fixes an otherwise harmless assert() failure. (check-in: [a9e0354c] user: dan branch: trunk, size: 15383)
2019-12-27
20:54
[d58d4120] part of check-in [d29edef9] Do not attempt to unwind the WITH stack in the Parse object following an error. This fixes a separate case to [de6e6d68], but also causes an assertion fault at select.c:4666 for test case altertab3-22.4. (check-in: [d29edef9] user: dan branch: better-error-handling-1, size: 14488)
2019-12-20
14:18
[10c32d62] part of check-in [365dd8b6] Fix a potential problem with ALTER TABLE commands on schemas that contains a triggers or view featuring a sub-query that uses an ON clause with a join that is not a LEFT JOIN. (check-in: [365dd8b6] user: dan branch: trunk, size: 14030)
2019-12-09
19:29
[231881a8] part of check-in [c7309ed3] Add a NEVER() to the ALTER TABLE fix in check-in [1d2e53a39b87e364] (check-in: [c7309ed3] user: drh branch: trunk, size: 13674)
08:13
[3faf56b3] part of check-in [1d2e53a3] Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself. (check-in: [1d2e53a3] user: dan branch: trunk, size: 13685)
2019-12-05
14:31
[18111c21] part of check-in [7e5ad8e0] Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE. (check-in: [7e5ad8e0] user: dan branch: trunk, size: 12992)
2019-12-04
15:08
[923db557] part of check-in [54410f0e] Ensure that an ALWAYS() in the rename logic really is always true, even for faulty inputs. (check-in: [54410f0e] user: drh branch: trunk, size: 12715)
14:26
[1456b08b] part of check-in [75b04a4b] Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. (check-in: [75b04a4b] user: dan branch: trunk, size: 12346)
2019-10-28
13:54
[f40013d3] part of check-in [0b0a3048] Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63. (check-in: [0b0a3048] user: dan branch: trunk, size: 10409)
2019-08-08
15:24
[c755ef31] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 9631)
2019-08-05
13:19
[9b868b9f] part of check-in [2ac0e42f] Fix a problem with renaming a table when a view or trigger within the schema uses a FILTER with an aggregate function that is not currently registered with the database. (check-in: [2ac0e42f] user: dan branch: trunk, size: 9632)
2019-08-01
10:58
[0f1e2801] part of check-in [8168021f] Fix a problem in ALTER TABLE triggered by views or triggers that include the construction "ORDER BY true" or "ORDER BY false". (check-in: [8168021f] user: dan branch: trunk, size: 9110)
2019-07-22
11:38
[8e6db08e] part of check-in [bd37ce3f] Fix a problem with renaming tables when the schema contains an invocation of a currently unregistered aggregate with a FILTER clause. (check-in: [bd37ce3f] user: dan branch: trunk, size: 8698)
2019-07-19
14:32
[b20c9c42] part of check-in [ff290feb] Fix a problem with renaming a table when the schema contains an invocation of a window function that is not currently registered. (check-in: [ff290feb] user: dan branch: trunk, size: 8316)
11:20
[45b86673] part of check-in [348e7f19] Fix a problem with renaming tables when the schema contains WINDOW definitions with (illegal) non-numeric expressions as part of a PRECEDING or FOLLOWING clause. (check-in: [348e7f19] user: dan branch: trunk, size: 8028)
10:31
[4f9dbe76] part of check-in [ee076c28] Fix a faulty assert() in walker.c that could fail when processing an ALTER TABLE statement on a schema containing invalid table references that are part of a WINDOW definition. (check-in: [ee076c28] user: dan branch: trunk, size: 6972)
2019-06-15
15:27
[7a241982] part of check-in [0bbceebb] Add extra test case for one of the problems fixed by the previous commit. (check-in: [0bbceebb] user: dan branch: trunk, size: 5997)
2019-06-13
13:52
[3d9f15e9] part of check-in [eaa34626] Fix a minor error in a test script, and harmless compiler warnings in the CLI code. (check-in: [eaa34626] user: drh branch: trunk, size: 5533)
2019-06-11
12:03
[6909f4f3] part of check-in [f2c8179f] Have the ALTER TABLE code handle the case where an entire expression that includes a sub-select is excluded from a view, trigger or index. (check-in: [f2c8179f] user: dan branch: trunk, size: 5525)
2019-06-10
19:17
[47cdbc49] part of check-in [71643deb] Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. (check-in: [71643deb] user: dan branch: trunk, size: 5213)
15:34
[a8f64e28] part of check-in [567b1309] Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()). Fix for [fd76310a]. (check-in: [567b1309] user: dan branch: trunk, size: 4797)
2019-04-29
11:27
[2433d0cc] part of check-in [c621fc66] Fix a stack overflow that could occur when renaming a table that has a trigger containing a window function invocation that itself contains a specific syntax error. (check-in: [c621fc66] user: dan branch: trunk, size: 4471)
2019-04-12
12:10
[40f2ce9b] part of check-in [56b66418] Fix minor problems in tcl test scripts. (check-in: [56b66418] user: dan branch: trunk, size: 3596)
2019-03-20
16:58
[b917c2a2] part of check-in [b9e2393c] Fix a potential dangling pointer deference in an ALTER TABLE run on a schema that contains constructs of the form "PRIMARY KEY(column COLLATE collation)". (check-in: [b9e2393c] user: dan branch: trunk, size: 3546)
2019-03-15
16:17
[35aadf59] part of check-in [0f2129f5] Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a]. (check-in: [0f2129f5] user: dan branch: trunk, size: 2972)
2019-02-11
11:34
[1df6d9c6] part of check-in [8824115a] Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds. (check-in: [8824115a] user: dan branch: trunk, size: 2141)
2019-01-24
16:27
[9dd97ab8] part of check-in [2d9cd067] Fix a problem with running ALTER TABLE on a schema that contains expressions of the type "col IN ()" (empty set on RHS of IN operator). (check-in: [2d9cd067] user: dan branch: trunk, size: 2102)
2019-01-23
19:50
[94152c25] part of check-in [2ca6b8f8] Fix a problem with renaming a table within a schema that contains a composite query that uses a column alias as an ORDER BY term. (check-in: [2ca6b8f8] user: dan branch: trunk, size: 1700)
16:59
Added: [b27923ad] part of check-in [0387cb3a] Fix problems with sub-selects in WINDOW definitions. Also rename-column operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER. (check-in: [0387cb3a] user: dan branch: trunk, size: 1039)