SQLite

All files named ”test/altertab2.test”
Login

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

History for test/altertab2.test

2025-07-01
12:43
[0889ba0700] part of check-in [77397bd67d] When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See forum thread f4878de3e7. (check-in: [77397bd67d] user: drh branch: trunk, size: 10300)
2025-04-10
10:18
[4bad0fa9b1] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 10319)
2024-05-15
21:38
[fff90e3f01] part of check-in [b79a8be37b] Fix a case where an error in the ORDER BY clause of an aggregate function that is part of a trigger body might cause an assert() to fail in an ALTER TABLE command. (check-in: [b79a8be37b] user: dan branch: alter-table-fix, size: 10323)
2022-02-06
00:30
[62597b6fd0] part of check-in [fa34676042] Further improvements to localization of errors in input SQL. (check-in: [fa34676042] user: drh branch: trunk, size: 9915)
2019-12-30
06:55
[b0d62f323c] part of check-in [a9e0354c99] 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: [a9e0354c99] user: dan branch: trunk, size: 9915)
2019-06-11
02:43
[8883693952] part of check-in [04bd5cb732] 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] (check-in: [04bd5cb732] user: drh branch: trunk, size: 9917)
01:56
[429e4e8447] part of check-in [e82f235e72] Fix repeated test numbers in the altertab2.test file. (check-in: [e82f235e72] user: drh branch: trunk, size: 9472)
2019-02-11
11:34
[5d423a2d10] part of check-in [8824115a97] Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds. (check-in: [8824115a97] user: dan branch: trunk, size: 9474)
2019-01-23
16:59
[7bedde2e6e] part of check-in [0387cb3add] 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: [0387cb3add] user: dan branch: trunk, size: 9435)
2019-01-19
14:07
[2465aac70c] part of check-in [908ff7fffa] 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". (check-in: [908ff7fffa] user: dan branch: trunk, size: 9431)
2019-01-18
16:06
[67dd9806e7] part of check-in [64bec9e621] 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. (check-in: [64bec9e621] user: dan branch: trunk, size: 9148)
2019-01-16
20:48
[b80f1b4c1f] part of check-in [ca7b7aaed0] Fix a problem with fix [b4b57413]. (check-in: [ca7b7aaed0] user: dan branch: trunk, size: 8292)
14:58
[1a4dffbd35] part of check-in [b4b5741366] 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. (check-in: [b4b5741366] user: dan branch: trunk, size: 7198)
12:05
[d0c8e6bd57] part of check-in [d45bee36f2] 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. (check-in: [d45bee36f2] user: dan branch: trunk, size: 6300)
2019-01-15
20:51
[4e40836ce9] part of check-in [cc6cd7531f] Fix a problem with ALTER TABLE and vector assignments in UPDATE statements within triggers. (check-in: [cc6cd7531f] user: dan branch: trunk, size: 4781)
2018-12-05
13:49
[814369c72a] part of check-in [f44bc7a8b3] Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. (check-in: [f44bc7a8b3] user: dan branch: trunk, size: 3846)
2018-11-10
03:47
[0d64de5632] part of check-in [bf88efcec4] Merge fixes from trunk. (check-in: [bf88efcec4] user: drh branch: read-only-shadow, size: 2425)
2018-11-09
20:04
[7b3f4a6ca0] part of check-in [ae9638e9c0] 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). (check-in: [ae9638e9c0] user: dan branch: trunk, size: 2426)
2018-11-07
02:17
[228b406400] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 1052)
2018-09-20
17:21
Added: [159fd5f7b2] part of check-in [71947337e9] By default, make all "ALTER TABLE RENAME" statements executed within a virtual table xRename() method exhibit the legacy behaviour. (check-in: [71947337e9] user: dan branch: legacy-alter-table, size: 1053)