/ File History
Login

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

History of test/altertab2.test

2019-06-11
02:43
The ALTER TABLE command should not attempt to rename objects that are contained within an expression tree that has been optimized out because it is the other branch of an "AND false" expression. Ticket [533010b8cacebe82] file: [88836939] check-in: [04bd5cb7] user: drh branch: trunk, size: 9917
01:56
Fix repeated test numbers in the altertab2.test file. file: [429e4e84] check-in: [e82f235e] user: drh branch: trunk, size: 9472
2019-02-11
11:34
Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds. file: [5d423a2d] check-in: [8824115a] user: dan branch: trunk, size: 9474
2019-01-23
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: [7bedde2e] check-in: [0387cb3a] user: dan branch: trunk, size: 9435
2019-01-19
14:07
Fix a problem with using ALTER TABLE to rename a table or column when the database schema contains a trigger or view that itself contains an expression "<column> AND 0". file: [2465aac7] check-in: [908ff7ff] user: dan branch: trunk, size: 9431
2019-01-18
16:06
Fix a fairly obscure problem allowing an "ALTER TABLE RENAME col TO ..." statement to modify the schema in such a way as to break a reference within a trigger program. file: [67dd9806] check-in: [64bec9e6] user: dan branch: trunk, size: 9148
2019-01-16
20:48
Fix a problem with fix [b4b57413]. file: [b80f1b4c] check-in: [ca7b7aae] user: dan branch: trunk, size: 8292
14:58
Fix a problem with renaming a column that is used as part of an ORDER BY on a compound SELECT within a database view or trigger. file: [1a4dffbd] check-in: [b4b57413] user: dan branch: trunk, size: 7198
12:05
Avoid a dangling pointer comparison when renaming a table that has a trigger that itself contains a window function with an (illegal) column reference in a FOLLOWING expression. file: [d0c8e6bd] check-in: [d45bee36] user: dan branch: trunk, size: 6300
2019-01-15
20:51
Fix a problem with ALTER TABLE and vector assignments in UPDATE statements within triggers. file: [4e40836c] check-in: [cc6cd753] user: dan branch: trunk, size: 4781
2018-12-05
13:49
Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. file: [814369c7] check-in: [f44bc7a8] user: dan branch: trunk, size: 3846
2018-11-10
03:47
Merge fixes from trunk. file: [0d64de56] check-in: [bf88efce] user: drh branch: read-only-shadow, size: 2425
2018-11-09
20:04
When a table is renamed using "ALTER TABLE RENAME TO", update any REFERENCES clauses that refer to the table, unless "PRAGMA legacy_alter_table" is true and "PRAGMA foreign_keys" is set to false (i.e. so that when "PRAGMA legacy_alter_table" is set behaviour is still compatible with versions 3.24 and earlier). file: [7b3f4a6c] check-in: [ae9638e9] user: dan branch: trunk, size: 2426
2018-11-07
02:17
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. file: [228b4064] check-in: [3212733c] user: drh branch: read-only-shadow, size: 1052
2018-09-20
17:21
By default, make all "ALTER TABLE RENAME" statements executed within a virtual table xRename() method exhibit the legacy behaviour. file: [159fd5f7] check-in: [71947337] user: dan branch: legacy-alter-table, size: 1053 Added