Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/altercol.test
|
2019-07-02
| ||
| 20:10 | Have ALTER TABLE detect and error out for the case where renaming a column changes a the interpretation of a double-quoted identifier in the database schema from an SQL literal to a column reference. file: [545a7f2a] check-in: [5dbb0734] user: dan branch: tkt9b78184b-alt, size: 22982 | |
|
2019-01-09
| ||
| 02:02 | Enhance the ALTER TABLE RENAME COLUMN feature so that it works on tables that have redundant UNIQUE and/or PRIMARY KEY constraints. Fix for ticket [bc8d94f0fbd633fd9a051e3] file: [54374d2b] check-in: [f09aa324] user: drh branch: trunk, size: 22977 | |
|
2018-11-26
| ||
| 18:09 | Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. file: [313ed080] check-in: [6e133054] user: drh branch: trunk, size: 21867 | |
|
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: [50095d59] check-in: [3212733c] user: drh branch: read-only-shadow, size: 21468 | |
|
2018-09-12
| ||
| 08:51 | Fix an invalid pointer comparison triggered by renaming a table column when there are views with explicit column names in the schema. file: [53fb5e21] check-in: [572de7e4] user: dan branch: trunk, size: 21435 | |
|
2018-09-06
| ||
| 17:23 | Fix test script problems causing SQLITE_OMIT_VIRTUALTABLE builds to fail. file: [1defda7e] check-in: [37ad064e] user: dan branch: trunk, size: 21077 | |
|
2018-09-01
| ||
| 20:23 | Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. file: [a5e24ad5] check-in: [336b8a09] user: dan branch: alter-table-rename-column, size: 20958 | |
| 15:55 | Merge fixes from the alter-table-rename-column branch that occurred after this branch separated from that one. file: [42250da2] check-in: [22e785aa] user: drh branch: alter-table-rename-table, size: 19893 | |
|
2018-08-30
| ||
| 20:03 | Test the schema after renaming a table. Ensure that temp database triggers and views are updated when renaming a column. file: [b89cd928] check-in: [f3c27d91] user: dan branch: alter-table-rename-table, size: 19874 | |
|
2018-08-25
| ||
| 16:22 | Fix a minor issue in the altercol.test script so that it runs on Windows. file: [5636b8e5] check-in: [62089c6d] user: drh branch: alter-table-rename-column, size: 19616 | |
|
2018-08-24
| ||
| 20:20 | Fix a problem by renaming a column when the schema contains an trigger program featuring an UPSERT that uses an "excluded.*" reference to a different table. file: [919898b3] check-in: [83d5f5ab] user: dan branch: alter-table-rename-column, size: 19597 | |
| 20:10 | Fix a problem with renaming a column that occurs as an "excluded.colname" construction in an UPSERT that is part of a trigger program. file: [b8332aae] check-in: [bb2f7234] user: dan branch: alter-table-rename-column, size: 19464 | |
| 17:55 | After modifying and reparsing the schema as part of an ALTER TABLE RENAME COLUMN, check that no new schema errors have been introduced (e.g. ambiguous column names in views) before committing the operation. file: [f8359980] check-in: [a0e06d2c] user: dan branch: alter-table-rename-column, size: 19028 | |
| 16:04 | Avoid incorrectly replacing tokens that refer to a column being renamed via an alias. For example, do not overwrite "xyz" when "a" is renamed in "CREATE VIEW v1 AS SELECT a AS xyz FROM tbl WHERE xyz=1" file: [2630ee56] check-in: [ad072a83] user: dan branch: alter-table-rename-column, size: 18595 | |
|
2018-08-23
| ||
| 19:32 | Fix harmless compiler warnings in the ALTER TABLE logic. Rephrase an error message to use active voice. file: [5187221c] check-in: [a7dae59a] user: drh branch: alter-table-rename-column, size: 18168 | |
|
2018-08-21
| ||
| 15:06 | Rationalize some duplicated code in alter.c. Also improve error messages for ALTER TABLE RENAME COLUMN in some cases. file: [d0962610] check-in: [5d2163c7] user: dan branch: alter-table-rename-column, size: 18175 | |
|
2018-08-20
| ||
| 20:01 | Add further tests for RENAME COLUMN. file: [9d3e8257] check-in: [82c4c10a] user: dan branch: alter-table-rename-column, size: 18023 | |
| 16:16 | Ensure that it is not possible to rename columns of system tables, views or virtual tables. file: [692c15f8] check-in: [786b5991] user: dan branch: alter-table-rename-column, size: 14775 | |
|
2018-08-18
| ||
| 17:35 | Improvements to error handling in ALTER TABLE RENAME COLUMN. file: [7e22d63b] check-in: [7fa1faea] user: dan branch: edit-trigger-wrapper, size: 13596 | |
|
2018-08-17
| ||
| 18:08 | Allow an ALTER TABLE RENAME COLUMN to proceed even if the schema contains a virtual table for which the module is unavailable. file: [cac93959] check-in: [7b72b236] user: dan branch: edit-trigger-wrapper, size: 12831 | |
| 17:18 | Ensure that CREATE VIEW, TRIGGER or INDEX statements can be edited by ALTER TABLE RENAME COLUMN even if they use collation-sequences or user-defined-functions that are not available. file: [4597bd06] check-in: [540014ef] user: dan branch: edit-trigger-wrapper, size: 12256 | |
|
2018-08-16
| ||
| 19:49 | Further progress on updating trigger programs as part of ALTER TABLE RENAME COLUMN. file: [c6016185] check-in: [3f47222b] user: dan branch: edit-trigger-wrapper, size: 11516 | |
|
2018-08-15
| ||
| 20:28 | Have ALTER TABLE RENAME COLUMN edit trigger programs. Only partly working. file: [c5763375] check-in: [e272dc2b] user: dan branch: edit-trigger-wrapper, size: 10083 | |
|
2018-08-14
| ||
| 21:05 | Fix a problem when renaming an IPK column that is also part of a child key. file: [a0b57120] check-in: [6e6a2bfd] user: dan branch: edit-trigger-wrapper, size: 9655 | |
| 21:03 | Fix a problem when renaming an IPK column that is also part of a child key. file: [8380bf54] check-in: [ad154860] user: dan branch: alter-table-rename-column, size: 6646 | |
| 20:40 | Merge latest trunk and ALTER TABLE error message improvements into this branch. file: [0af8f573] check-in: [7a45802d] user: dan branch: edit-trigger-wrapper, size: 9462 | |
| 20:18 | Have ALTER TABLE RENAME edit column references in CREATE VIEW statements. file: [98f1c88a] check-in: [db829dc1] user: dan branch: edit-trigger-wrapper, size: 9728 | |
| 16:18 | Fix ALTER TABLE RENAME COLUMN in cases where the column being renamed is an IPK declared with a separate PRIMARY KEY clause - "CREATE TABLE x(y INTEGER, PRIMARY KEY(y))". file: [65d15800] check-in: [32ca8418] user: dan branch: alter-table-rename-column, size: 6453 | |
|
2018-08-13
| ||
| 17:14 | Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLE RENAME COLUMN. file: [b3263a3d] check-in: [5fdb6b0a] user: dan branch: edit-trigger-wrapper, size: 6744 | |
|
2018-08-11
| ||
| 20:38 | If the new column name in an ALTER TABLE RENAME COLUMN statement is quoted, then also use quotes for the column name in the edited SQL statements. file: [a64f69f6] check-in: [ca5184a2] user: dan branch: alter-table-rename-column, size: 6187 | |
| 18:34 | Avoid an assert() sometimes triggered by ALTER TABLE RENAME COLUMN in non-debug builds. file: [4b75873d] check-in: [520c1c75] user: dan branch: alter-table-rename-column, size: 6046 | |
| 17:49 | Fix a bug causing ALTER TABLE RENAME COLUMN to fail when renaming an IPK column that is used in a CHECK constraint. file: [753fe5cf] check-in: [6595c881] user: dan branch: alter-table-rename-column, size: 6055 | |
| 17:34 | Fix a bug causing all ALTER TABLE RENAME COLUMN commands to fail if ANALYZE had been run on the database. Also prevent the user from renaming the columns of system tables. file: [4ff44e94] check-in: [ca644a28] user: dan branch: alter-table-rename-column, size: 5688 | |
| 13:40 | Reload the entire schema after renaming a column in order to ensure that the schema for any tables for which parent key definitions were changed are reloaded. file: [3b45ec54] check-in: [f4497b01] user: dan branch: alter-table-rename-column, size: 5266 | |
|
2018-08-10
| ||
| 20:19 | Ensure the schema cookie is changed when a column is renamed. file: [b7b2ee8c] check-in: [2dec9ea4] user: dan branch: alter-table-rename-column, size: 5268 | |
| 19:19 | When a column is renamed, update any references to it in REFERENCES clauses that belong to other tables. file: [93847fb3] check-in: [191079bd] user: dan branch: alter-table-rename-column, size: 5083 | |
| 14:23 | Fix a problem with renaming columns on tables with REFERENCES clauses that specify a large number of columns. file: [d5a22893] check-in: [d48f7bbd] user: dan branch: alter-table-rename-column, size: 3534 | |
|
2018-08-09
| ||
| 20:47 | Experimental implementation of ALTER TABLE ... RENAME COLUMN. Still buggy. file: [44fedc51] check-in: [fa0fc01e] user: dan branch: alter-table-rename-column, size: 3053 Added | |