/ File History
Login

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

History of test/altertab3.test

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