/ File History
Login

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

History of test/altercol.test

2020-01-01
15:43
[1d6a6fe6] part of check-in [473892a8] New test-only SQL functions: implies_nonnull_row(), expr_compare(), and expr_implies_expr(). The SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test-control is modified to toggle internal function access on and off for a single database connection. (check-in: [473892a8] user: drh branch: trunk, size: 22979)
2019-07-02
20:10
[545a7f2a] part of check-in [5dbb0734] 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. (check-in: [5dbb0734] user: dan branch: tkt9b78184b-alt, size: 22982)
2019-01-09
02:02
[54374d2b] part of check-in [f09aa324] 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] (check-in: [f09aa324] user: drh branch: trunk, size: 22977)
2018-11-26
18:09
[313ed080] part of check-in [6e133054] 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. (check-in: [6e133054] user: drh branch: trunk, size: 21867)
2018-11-07
02:17
[50095d59] part of check-in [3212733c] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733c] user: drh branch: read-only-shadow, size: 21468)
2018-09-12
08:51
[53fb5e21] part of check-in [572de7e4] Fix an invalid pointer comparison triggered by renaming a table column when there are views with explicit column names in the schema. (check-in: [572de7e4] user: dan branch: trunk, size: 21435)
2018-09-06
17:23
[1defda7e] part of check-in [37ad064e] Fix test script problems causing SQLITE_OMIT_VIRTUALTABLE builds to fail. (check-in: [37ad064e] user: dan branch: trunk, size: 21077)
2018-09-01
20:23
[a5e24ad5] part of check-in [336b8a09] Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. (check-in: [336b8a09] user: dan branch: alter-table-rename-column, size: 20958)
15:55
[42250da2] part of check-in [22e785aa] Merge fixes from the alter-table-rename-column branch that occurred after this branch separated from that one. (check-in: [22e785aa] user: drh branch: alter-table-rename-table, size: 19893)
2018-08-30
20:03
[b89cd928] part of check-in [f3c27d91] Test the schema after renaming a table. Ensure that temp database triggers and views are updated when renaming a column. (check-in: [f3c27d91] user: dan branch: alter-table-rename-table, size: 19874)
2018-08-25
16:22
[5636b8e5] part of check-in [62089c6d] Fix a minor issue in the altercol.test script so that it runs on Windows. (check-in: [62089c6d] user: drh branch: alter-table-rename-column, size: 19616)
2018-08-24
20:20
[919898b3] part of check-in [83d5f5ab] 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. (check-in: [83d5f5ab] user: dan branch: alter-table-rename-column, size: 19597)
20:10
[b8332aae] part of check-in [bb2f7234] Fix a problem with renaming a column that occurs as an "excluded.colname" construction in an UPSERT that is part of a trigger program. (check-in: [bb2f7234] user: dan branch: alter-table-rename-column, size: 19464)
17:55
[f8359980] part of check-in [a0e06d2c] 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. (check-in: [a0e06d2c] user: dan branch: alter-table-rename-column, size: 19028)
16:04
[2630ee56] part of check-in [ad072a83] 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" (check-in: [ad072a83] user: dan branch: alter-table-rename-column, size: 18595)
2018-08-23
19:32
[5187221c] part of check-in [a7dae59a] Fix harmless compiler warnings in the ALTER TABLE logic. Rephrase an error message to use active voice. (check-in: [a7dae59a] user: drh branch: alter-table-rename-column, size: 18168)
2018-08-21
15:06
[d0962610] part of check-in [5d2163c7] Rationalize some duplicated code in alter.c. Also improve error messages for ALTER TABLE RENAME COLUMN in some cases. (check-in: [5d2163c7] user: dan branch: alter-table-rename-column, size: 18175)
2018-08-20
20:01
[9d3e8257] part of check-in [82c4c10a] Add further tests for RENAME COLUMN. (check-in: [82c4c10a] user: dan branch: alter-table-rename-column, size: 18023)
16:16
[692c15f8] part of check-in [786b5991] Ensure that it is not possible to rename columns of system tables, views or virtual tables. (check-in: [786b5991] user: dan branch: alter-table-rename-column, size: 14775)
2018-08-18
17:35
[7e22d63b] part of check-in [7fa1faea] Improvements to error handling in ALTER TABLE RENAME COLUMN. (check-in: [7fa1faea] user: dan branch: edit-trigger-wrapper, size: 13596)
2018-08-17
18:08
[cac93959] part of check-in [7b72b236] Allow an ALTER TABLE RENAME COLUMN to proceed even if the schema contains a virtual table for which the module is unavailable. (check-in: [7b72b236] user: dan branch: edit-trigger-wrapper, size: 12831)
17:18
[4597bd06] part of check-in [540014ef] 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. (check-in: [540014ef] user: dan branch: edit-trigger-wrapper, size: 12256)
2018-08-16
19:49
[c6016185] part of check-in [3f47222b] Further progress on updating trigger programs as part of ALTER TABLE RENAME COLUMN. (check-in: [3f47222b] user: dan branch: edit-trigger-wrapper, size: 11516)
2018-08-15
20:28
[c5763375] part of check-in [e272dc2b] Have ALTER TABLE RENAME COLUMN edit trigger programs. Only partly working. (check-in: [e272dc2b] user: dan branch: edit-trigger-wrapper, size: 10083)
2018-08-14
21:05
[a0b57120] part of check-in [6e6a2bfd] Fix a problem when renaming an IPK column that is also part of a child key. (check-in: [6e6a2bfd] user: dan branch: edit-trigger-wrapper, size: 9655)
21:03
[8380bf54] part of check-in [ad154860] Fix a problem when renaming an IPK column that is also part of a child key. (check-in: [ad154860] user: dan branch: alter-table-rename-column, size: 6646)
20:40
[0af8f573] part of check-in [7a45802d] Merge latest trunk and ALTER TABLE error message improvements into this branch. (check-in: [7a45802d] user: dan branch: edit-trigger-wrapper, size: 9462)
20:18
[98f1c88a] part of check-in [db829dc1] Have ALTER TABLE RENAME edit column references in CREATE VIEW statements. (check-in: [db829dc1] user: dan branch: edit-trigger-wrapper, size: 9728)
16:18
[65d15800] part of check-in [32ca8418] 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))". (check-in: [32ca8418] user: dan branch: alter-table-rename-column, size: 6453)
2018-08-13
17:14
[b3263a3d] part of check-in [5fdb6b0a] Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLE RENAME COLUMN. (check-in: [5fdb6b0a] user: dan branch: edit-trigger-wrapper, size: 6744)
2018-08-11
20:38
[a64f69f6] part of check-in [ca5184a2] 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. (check-in: [ca5184a2] user: dan branch: alter-table-rename-column, size: 6187)
18:34
[4b75873d] part of check-in [520c1c75] Avoid an assert() sometimes triggered by ALTER TABLE RENAME COLUMN in non-debug builds. (check-in: [520c1c75] user: dan branch: alter-table-rename-column, size: 6046)
17:49
[753fe5cf] part of check-in [6595c881] Fix a bug causing ALTER TABLE RENAME COLUMN to fail when renaming an IPK column that is used in a CHECK constraint. (check-in: [6595c881] user: dan branch: alter-table-rename-column, size: 6055)
17:34
[4ff44e94] part of check-in [ca644a28] 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. (check-in: [ca644a28] user: dan branch: alter-table-rename-column, size: 5688)
13:40
[3b45ec54] part of check-in [f4497b01] 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. (check-in: [f4497b01] user: dan branch: alter-table-rename-column, size: 5266)
2018-08-10
20:19
[b7b2ee8c] part of check-in [2dec9ea4] Ensure the schema cookie is changed when a column is renamed. (check-in: [2dec9ea4] user: dan branch: alter-table-rename-column, size: 5268)
19:19
[93847fb3] part of check-in [191079bd] When a column is renamed, update any references to it in REFERENCES clauses that belong to other tables. (check-in: [191079bd] user: dan branch: alter-table-rename-column, size: 5083)
14:23
[d5a22893] part of check-in [d48f7bbd] Fix a problem with renaming columns on tables with REFERENCES clauses that specify a large number of columns. (check-in: [d48f7bbd] user: dan branch: alter-table-rename-column, size: 3534)
2018-08-09
20:47
[44fedc51] part of check-in [fa0fc01e] Experimental implementation of ALTER TABLE ... RENAME COLUMN. Still buggy. (check-in: [fa0fc01e] user: dan branch: alter-table-rename-column, size: 3053) Added