/ File History
Login

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

History of test/altercol.test

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