Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/altertab3.test
|
2019-12-09
| ||
| 19:29 | Add a NEVER() to the ALTER TABLE fix in check-in [1d2e53a39b87e364] file: [231881a8] check-in: [c7309ed3] user: drh branch: trunk, size: 13674 | |
| 08:13 | Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself. file: [3faf56b3] check-in: [1d2e53a3] user: dan branch: trunk, size: 13685 | |
|
2019-12-05
| ||
| 14:31 | 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. file: [18111c21] check-in: [7e5ad8e0] user: dan branch: trunk, size: 12992 | |
|
2019-12-04
| ||
| 15:08 | Ensure that an ALWAYS() in the rename logic really is always true, even for faulty inputs. file: [923db557] check-in: [54410f0e] user: drh branch: trunk, size: 12715 | |
| 14:26 | Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. file: [1456b08b] check-in: [75b04a4b] user: dan branch: trunk, size: 12346 | |
|
2019-10-28
| ||
| 13:54 | Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63. file: [f40013d3] check-in: [0b0a3048] user: dan branch: trunk, size: 10409 | |
|
2019-08-08
| ||
| 15:24 | 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. file: [c755ef31] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 9631 | |
|
2019-08-05
| ||
| 13:19 | 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. file: [9b868b9f] check-in: [2ac0e42f] user: dan branch: trunk, size: 9632 | |
|
2019-08-01
| ||
| 10:58 | Fix a problem in ALTER TABLE triggered by views or triggers that include the construction "ORDER BY true" or "ORDER BY false". file: [0f1e2801] check-in: [8168021f] user: dan branch: trunk, size: 9110 | |
|
2019-07-22
| ||
| 11:38 | Fix a problem with renaming tables when the schema contains an invocation of a currently unregistered aggregate with a FILTER clause. file: [8e6db08e] check-in: [bd37ce3f] user: dan branch: trunk, size: 8698 | |
|
2019-07-19
| ||
| 14:32 | Fix a problem with renaming a table when the schema contains an invocation of a window function that is not currently registered. file: [b20c9c42] check-in: [ff290feb] user: dan branch: trunk, size: 8316 | |
| 11:20 | 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. file: [45b86673] check-in: [348e7f19] user: dan branch: trunk, size: 8028 | |
| 10:31 | 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. file: [4f9dbe76] check-in: [ee076c28] user: dan branch: trunk, size: 6972 | |
|
2019-06-15
| ||
| 15:27 | Add extra test case for one of the problems fixed by the previous commit. file: [7a241982] check-in: [0bbceebb] user: dan branch: trunk, size: 5997 | |
|
2019-06-13
| ||
| 13:52 | Fix a minor error in a test script, and harmless compiler warnings in the CLI code. file: [3d9f15e9] check-in: [eaa34626] user: drh branch: trunk, size: 5533 | |
|
2019-06-11
| ||
| 12:03 | 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. file: [6909f4f3] check-in: [f2c8179f] user: dan branch: trunk, size: 5525 | |
|
2019-06-10
| ||
| 19:17 | Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. file: [47cdbc49] check-in: [71643deb] user: dan branch: trunk, size: 5213 | |
| 15:34 | 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]. file: [a8f64e28] check-in: [567b1309] user: dan branch: trunk, size: 4797 | |
|
2019-04-29
| ||
| 11:27 | 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. file: [2433d0cc] check-in: [c621fc66] user: dan branch: trunk, size: 4471 | |
|
2019-04-12
| ||
| 12:10 | Fix minor problems in tcl test scripts. file: [40f2ce9b] check-in: [56b66418] user: dan branch: trunk, size: 3596 | |
|
2019-03-20
| ||
| 16:58 | 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)". file: [b917c2a2] check-in: [b9e2393c] user: dan branch: trunk, size: 3546 | |
|
2019-03-15
| ||
| 16:17 | Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a]. file: [35aadf59] check-in: [0f2129f5] user: dan branch: trunk, size: 2972 | |
|
2019-02-11
| ||
| 11:34 | Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds. file: [1df6d9c6] check-in: [8824115a] user: dan branch: trunk, size: 2141 | |
|
2019-01-24
| ||
| 16:27 | 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). file: [9dd97ab8] check-in: [2d9cd067] user: dan branch: trunk, size: 2102 | |
|
2019-01-23
| ||
| 19:50 | 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. file: [94152c25] check-in: [2ca6b8f8] user: dan branch: trunk, size: 1700 | |
| 16:59 | 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. file: [b27923ad] check-in: [0387cb3a] user: dan branch: trunk, size: 1039 Added | |