aboutsummaryrefslogtreecommitdiff
path: root/src/alter.c
Commit message (Collapse)AuthorAge
...
* Fix an invalid pointer comparison triggered by renaming a table column whendan2018-09-12
| | | | | there are views with explicit column names in the schema. FossilOrigin-Name: 572de7e4e33562c72cd90790b267ba389370f21ddcaebc4db609fd76ae9b7ada
* Remove a faulty ALWAYS() macro added by check-in [8fa254aa6329bdd0].drh2018-09-07
| | | FossilOrigin-Name: fc47316e9b6b9f4c37cb7d3fe2af3f4dfb900fb5f07945dbf1239152a2d8f836
* Add assert() and ALWAYS() to identify two unreachable branches.drh2018-09-07
| | | FossilOrigin-Name: 8fa254aa6329bdd085b8e2c78d8e8a698b418eda8b2d48e0082dd9cd428cef29
* Fix a problem with renaming a non-temp table that has at least one tempdan2018-09-07
| | | | | trigger and shares its name with a temp table. FossilOrigin-Name: ceb60bd7e5f2a0a4247bff476fc6468227305467339ae0c24591be9d2b14bdde
* Minor fixes for problems revealed by releasetest.tcl.dan2018-09-07
| | | FossilOrigin-Name: 1a8aedc3376b7ae32fa7b2c367eedd483e2629908836efd10ee5bd1fe0784675
* Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds.dan2018-09-06
| | | FossilOrigin-Name: fa835145e63749e06e04bd50ff992afaeae05dcdd1df597d13911f944e62076b
* Ensure that the tbl_name column in the sqlite_temp_master table is updateddan2018-09-06
| | | | | correctly as part of a RENAME TABLE operation. FossilOrigin-Name: ffecfca511718e39e0003b380d5113755b8a11405a5bd80cc04503d9557f0842
* Avoid comparing pointer values after the object that they point to has beendan2018-09-05
| | | | | deleted. FossilOrigin-Name: 2ec7e50cbc0e7a4308d51be3c9416229b187a6a8abdd982c154edc256cd6da1f
* Fix minor code issues in alter.c.dan2018-09-05
| | | FossilOrigin-Name: 18ba35b86f3b9813179b5f8d74e59e4860bfb800f45aabab8d6c0a6d7c97fe74
* Improve the error messages emitted by RENAME TABLE.dan2018-09-03
| | | FossilOrigin-Name: 6805b5900df5e6d3329cbad2660875ebe4069efe37b19575f527d153dc0882a1
* Fix a problem with renaming a column in a table that has a temp trigger thatdan2018-09-01
| | | | | references another attached database. FossilOrigin-Name: 336b8a0923bf65b7a2c35811cb6dec0e262a0b31e534d2a6ab093d2afdb05c1f
* Fixes for harmless compiler warnings.drh2018-09-01
| | | FossilOrigin-Name: 41b8f38b97bf0d1abcd6de8e940269fc4c51e2bbcf7b2e53e0c8440c58187c33
* Fix some harmless compiler warnings and improve defenses against OOM errors.drh2018-09-01
| | | FossilOrigin-Name: 2e2cf992f5d6cae2030c3c03b0eb98af3b130e86a719b991e41380138751f615
* Have "ALTER TABLE ADD COLUMN" reload the entire db schema, as "RENAME COLUMN"dan2018-09-01
| | | | | and "RENAME TABLE" do. FossilOrigin-Name: 8d89ddc1a628e983b0fbd929c9c9daac86ee23d18f8dd2709c971012389395c6
* Merge fixes from the alter-table-rename-column branch that occurred afterdrh2018-09-01
|\ | | | | | | | | this branch separated from that one. FossilOrigin-Name: 22e785aa2bbce4ae0852bc3d127d4b12222a192eb6e3ee874bf8e5c8582d05f3
| * Invoke the authorizer for ALTER TABLE RENAME COLUMN.drh2018-08-25
| | | | | | FossilOrigin-Name: fc293bcb3402f049fb9e22aacfb4fdcd13f8609edf29c97d6cb95ce351363873
* | Ensure b-tree mutexes are always held when sqlite3FindTable() is called. Dodan2018-08-31
| | | | | | | | | | | | not invoke the authorizer callback when parsing schema items as part of ALTER TABLE commands. Fix test script issues. FossilOrigin-Name: eac2aa7dce577f1998cc2078dd8ac384070f8acf1ceb565999a5cf719092024e
* | Test the schema after renaming a table. Ensure that temp database triggers anddan2018-08-30
| | | | | | | | | | views are updated when renaming a column. FossilOrigin-Name: f3c27d916d4837f8fc3dd812bd004535f04c7a53bd2a0a2419613275f48bec76
* | Fix an ALTER TABLE problem with processing temp schema views and triggers.dan2018-08-30
| | | | | | FossilOrigin-Name: 72cfb1be29971d91a164f1d4f20cb054de68960a0bd547630bcd1160565971c5
* | Extend RENAME TABLE to edit triggers and views. Still buggy.dan2018-08-29
|/ | | FossilOrigin-Name: 01308bae3acf33f78b5bb90892085eab340df093aafc17e6ccf6a7d6cf324897
* The implementation of sqlite_rename_column() must be holding thedrh2018-08-25
| | | | | schema mutexes. FossilOrigin-Name: f0eed21d4e2e1f2c8e680a510a283ac21156c9766efec5b80a362a040424bce7
* Fix a problem by renaming a column when the schema contains an trigger programdan2018-08-24
| | | | | featuring an UPSERT that uses an "excluded.*" reference to a different table. FossilOrigin-Name: 83d5f5abce6be2f6d342a6fc68839289400d7bcb80eaa38194789142c93a80c3
* Fix a problem with renaming a column that occurs as an "excluded.colname"dan2018-08-24
| | | | | construction in an UPSERT that is part of a trigger program. FossilOrigin-Name: bb2f7234968157b605522dea8e115d8772ab4234147894089d6e48fedf5d6a5d
* After modifying and reparsing the schema as part of an ALTER TABLE RENAMEdan2018-08-24
| | | | | | COLUMN, check that no new schema errors have been introduced (e.g. ambiguous column names in views) before committing the operation. FossilOrigin-Name: a0e06d2c5e3abb3f300491e7651bb177a436899efd4506de9239359096b6a9e7
* Avoid incorrectly replacing tokens that refer to a column being renamed via andan2018-08-24
| | | | | | 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" FossilOrigin-Name: ad072a835f97ff418f5919d94f547ce8afb4fc7c7b590deba41f1e62136a79ac
* Fix harmless compiler warnings in the ALTER TABLE logic. Rephrase andrh2018-08-23
| | | | | error message to use active voice. FossilOrigin-Name: a7dae59a7e7b187fa2e9457bbb4b01cfe3d48bbdf59c3f8f7b4156bcde3bda98
* Rename internal function sqlite3RenameToken() to sqlite3RenameTokenMap() anddan2018-08-21
| | | | | sqlite3MoveRenameToken() to sqlite3RenameTokenRemap(). FossilOrigin-Name: b9ae9a0a188b82d7066f6ef7d21592889df0a61559e9a0e01819e9d5a92c3f36
* Rationalize some duplicated code in alter.c. Also improve error messages fordan2018-08-21
| | | | | ALTER TABLE RENAME COLUMN in some cases. FossilOrigin-Name: 5d2163c734aea8c0e1611af1161734bf141e7bd02c08f0b5f2e7bac3c7dfd2a5
* Minor changes to function tokenExpr() in order to claw back cycles lost to thedan2018-08-21
| | | | | rename-column change. FossilOrigin-Name: 479976955ecb27c3e77a280187eaf23722178549e072b34f3183354a27a4e5c3
* Add further tests for RENAME COLUMN.dan2018-08-20
| | | FossilOrigin-Name: 82c4c10a96db76f39edf5f6d027294d449d75b5a18da70da3667786da90e184d
* Ensure that it is not possible to rename columns of system tables, views ordan2018-08-20
| | | | | virtual tables. FossilOrigin-Name: 786b5991dc0bb6ba13327a3ac9d04efbf8b591dedc736b719b206ffd865b1918
* Additional fixes for harmless compiler warnings that are specific to thisdrh2018-08-18
| | | | | branch. FossilOrigin-Name: 9d8e73bf71e996b810959ffc0e60de69b5e8ca3301df52f9c35d5e9075921798
* Improvements to error handling in ALTER TABLE RENAME COLUMN.dan2018-08-18
| | | FossilOrigin-Name: 7fa1faeaff30b74b68ee6f4b363d837f21cf313d8262361c901bda884df139a2
* Allow an ALTER TABLE RENAME COLUMN to proceed even if the schema contains adan2018-08-17
| | | | | virtual table for which the module is unavailable. FossilOrigin-Name: 7b72b2360a70eb1f788b3c4d745967dfedb2c80af6b2e146ba940a3741fd51a1
* Further progress on updating trigger programs as part of ALTER TABLE RENAMEdan2018-08-16
| | | | | COLUMN. FossilOrigin-Name: 3f47222b6e20e1c1ef41c0f7391c8b5c7648e2a2d6013303d155ad59ce27143a
* (no comment)dan2018-08-15
| | | FossilOrigin-Name: e272dc2b1c0edab59a40f32c77c81a3e636937280524161eff5669cb0046ad84
* Fix a problem when renaming an IPK column that is also part of a child key.dan2018-08-14
|\ | | | | FossilOrigin-Name: 6e6a2bfdbbfd4ffc14be88962ff97bf3c626fef9d1a337715d2a4be1a657fb0d
| * Fix a problem when renaming an IPK column that is also part of a child key.dan2018-08-14
| | | | | | FossilOrigin-Name: ad15486022209205c65fb5ffdbe30a7b99379170451e6aff4bab6e90b549d6c7
| * Do not allow ALTER TABLE RENAME COLUMN on a virtual table.drh2018-08-14
| | | | | | FossilOrigin-Name: f6d6b472713c21deace3fd52c0b0b6901d758af043c238f004fabe52b01f730c
| * Improved error messages when an ALTER TABLE RENAME COLUMN fails due to adrh2018-08-14
| | | | | | | | | | duplicate column name. FossilOrigin-Name: 37d11b8e8224a8b241ff57b9c4b9499db39dde4ddcb56ff8b03a3d08091a4c11
| * Fix ALTER TABLE RENAME COLUMN in cases where the column being renamed is andan2018-08-14
| | | | | | | | | | | | IPK declared with a separate PRIMARY KEY clause - "CREATE TABLE x(y INTEGER, PRIMARY KEY(y))". FossilOrigin-Name: 32ca8418df8735a6c53e53153f733579e514711f091e4e09ecce83db85fe4d85
| * Make the sqlite_rename_column() SQL function resistant to problems causeddrh2018-08-13
| | | | | | | | | | | | by OOMs and/or malformed parameters submitted by hostile application code. Also add additional comments to the RENAME COLUMN logic. FossilOrigin-Name: 87743ddef11749b4017d60abc297abfd673e02a26a2ae45ffec861327578aa30
* | Have ALTER TABLE RENAME edit column references in CREATE VIEW statements.dan2018-08-14
| | | | | | FossilOrigin-Name: db829dc1a2d7afa49798a2fd32d1f070185b23e513416e65d8144fda24f23b50
* | Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLEdan2018-08-13
|/ | | | | RENAME COLUMN. FossilOrigin-Name: 5fdb6b0aafba727139e1937ef5950e4434a77f95a10fc46f8010ca2de3922326
* Fix legacy comments on Token. Begin commenting the new ALTER TABLE RENAMEdrh2018-08-13
| | | | | COLUMN code. Fix a memory leak in the sqlite_rename_column() SQL function. FossilOrigin-Name: 32edc8920376aabb84ebe1900eaa9512d23f1b44d6459e4916dc6b07db66e27c
* Fix issues with ALTER TABLE RENAME COLUMN associated with OOM errors.drh2018-08-13
| | | FossilOrigin-Name: 0b28dd5c2e4908d5e49eaedd359492e46de8af3bf84120f4683b3ea906882fbf
* If the new column name in an ALTER TABLE RENAME COLUMN statement is quoted,dan2018-08-11
| | | | | then also use quotes for the column name in the edited SQL statements. FossilOrigin-Name: ca5184a25f9150540a3e401ef67df0606efa7a294d70e3fa5edad9854003eb36
* Fix a bug causing ALTER TABLE RENAME COLUMN to fail when renaming an IPKdan2018-08-11
| | | | | column that is used in a CHECK constraint. FossilOrigin-Name: 6595c8811f13719d0aed8041abc7e1cade41c57427bcbf3503e2e42408eaa03b
* Fix a bug causing all ALTER TABLE RENAME COLUMN commands to fail if ANALYZEdan2018-08-11
| | | | | | had been run on the database. Also prevent the user from renaming the columns of system tables. FossilOrigin-Name: ca644a2877c26561f8fb3b3feb74a070cd46621acb105577f04bc936c9b72a95
* Reload the entire schema after renaming a column in order to ensure that thedan2018-08-11
| | | | | | schema for any tables for which parent key definitions were changed are reloaded. FossilOrigin-Name: f4497b0136e9fcb1121a834c86f84eeaf8f1e7d3157d409484e086bcef3487f1