aboutsummaryrefslogtreecommitdiff
path: root/src/alter.c
Commit message (Collapse)AuthorAge
...
* Ensure the schema cookie is changed when a column is renamed.dan2018-08-10
| | | FossilOrigin-Name: 2dec9ea4ab1779d00bb22add0aa9a8536661d8abc9f4c2fb8628e04d4cd84326
* Fix harmless compiler warnings.drh2018-08-10
| | | FossilOrigin-Name: 9564d7008c3fd804401a5da6ea342c6f4261db14e9f994d1a38883358a7c6f8c
* When a column is renamed, update any references to it in REFERENCES clausesdan2018-08-10
| | | | | that belong to other tables. FossilOrigin-Name: 191079bd4f774528a1e39b71b4a4ce7859dee0edf0ce72e4b6968ae889dc35c8
* Experimental implementation of ALTER TABLE ... RENAME COLUMN. Still buggy.dan2018-08-09
| | | FossilOrigin-Name: fa0fc01eb48a864f0a3d43f9b805d5ed2e530846ee0c34fcbc2eabd9e5696277
* Fix a minor problem in the code for determining whether or not an SQLdan2018-06-30
| | | | | statement is SQLITE_TOOBIG. FossilOrigin-Name: 763e6c9e2bbc0a6ef8d8361069bf7160790c9064f24f0e336b7ed85668735da9
* Change a comma into a logically equivalent but semantically clearer semicolon.drh2018-06-06
| | | FossilOrigin-Name: 71f97f0f82b3abfb07feb78d64a182fc50ff396e85d6f5aac479dbf58ba4d00a
* Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags thatdrh2017-07-26
| | | | | do not interact with PRAGMA statements into sqlite3.mDbFlags. FossilOrigin-Name: 3808a00f06d372cc531da039d97bd974e4a6576a30cf63bf562f83f186b313b3
* Minor code simplification in the ALTER TABLE logic.drh2017-06-28
| | | FossilOrigin-Name: bfc4e7f30e4654b9603457fb6a4136828e346dcfe4e313fdf56ed62d131b7156
* All temp.sqlite_master to be used as an alias for sqlite_temp_master.drh2016-12-16
| | | FossilOrigin-Name: 8d646905b830d5bb29092e103ac5cb499b3c7e5a
* Refactor the Table.nRef field as Table.nTabRef for easier grepping.drh2016-12-14
| | | FossilOrigin-Name: 9cae4c2e300e20304ced0dc8c1415c4922185928
* Rename the Db.zName field to Db.zDbSName to make it more descriptive and todrh2016-08-18
| | | | | | distinguish it from all of the other "zName" variables scattered throughout the code. FossilOrigin-Name: 92a22f01343a898455fd61c3b8e7d7c954f5b569
* Fix ALTER TABLE so that it does not promote the schema version past 3, asdrh2016-07-14
| | | | | | that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. FossilOrigin-Name: a7db6e45ad45be9b3003f61d4163f543498a7c9d
* Reduce the amount of heap required to store many schemas by storing eachdrh2016-02-29
| | | | | | column datatype appended to the column name, rather than as a separate allocation. FossilOrigin-Name: 842b21162713bb141b845b01c136457a31af4ab0
* Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reducedrh2016-02-27
| | | | | the amount of memory needed to hold the schema. FossilOrigin-Name: d8c94a46dfa94930732c2de2aa79675c5087d36e
* Improvements to the application-defined function mechanism so that it isdrh2016-02-15
| | | | | | more compact and runs faster, especially when the application defines thousands of new SQL functions. FossilOrigin-Name: 3201fbcc5105d23132e6b8b7ac825e66af4f8a39
* Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_formatdrh2016-02-09
| | | | | | to 4 if is not there already. No need to upgrade to only 2 or 3 since format 4 has now been supported for over 10 years. FossilOrigin-Name: e1d8ec85546caeca3bb7a05ad962a2aed91194ce
* Fix an assert() to have a test instead of a side effectpdr2016-02-06
| | | FossilOrigin-Name: a2952231ac7abe165ed070875728f752ae0be608
* Improvements to the way that OOM errors are processed.drh2016-02-05
| | | FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
* Remove unnecessary sets of db->mallocFailed.drh2016-02-04
| | | FossilOrigin-Name: b787165b25a240fd5b4a5c7f73b395f30213a1d7
* Change the OP_SetCookie instruction to write the literal P3 value, not thedrh2016-02-01
| | | | | value in register P3. FossilOrigin-Name: 6d7d4703ebf3754bec74123d5ba7e861a705f90f
* Compiler warning fixes: Rename some local variables from "j1" to avoid adrh2015-10-10
| | | | | | name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. FossilOrigin-Name: 9ddef84d432813f3ece8012047d08441caa3315d
* Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to helpdrh2015-09-03
| | | | | | with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). FossilOrigin-Name: 847387ec8e6fef283899578fb232b2c23b00ee5b
* Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB.drh2015-06-02
| | | FossilOrigin-Name: bce3f04186cd2d69414a5a98b5b77dc8f060554a
* Fix an assert() failure that could occur if the internal ↵dan2015-04-28
| | | | | sqlite3_rename_parent() SQL scalar function was invoked directly. FossilOrigin-Name: 36e515261825be60ffdc73d13340d77cf377e8e1
* Always disallow functions as the DEFAULT of a column. Add assert()s anddrh2015-03-12
| | | FossilOrigin-Name: a991bb1a9eb54bdbd45bd623e8b304bdfeb481a3
* Allow the default value for columns added using ALTER TABLE ADD COLUMN to be ↵dan2015-03-11
| | | | | a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. FossilOrigin-Name: ff868e22ca0393eaac417872a4c10738f0d7d970
* Fix typos in comments. No code changes.peter.d.reid2014-09-06
| | | FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
* Make sure the undocumented sqlite_rename_parent() function does notdrh2014-04-14
| | | | | | crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] FossilOrigin-Name: c6fa8d0d82805be230f672eabccdfa5680d4ddfd
* Make sure that the difference between two string pointers is passed intodrh2014-02-20
| | | | | sqlite3_mprintf() as type "int". FossilOrigin-Name: d5d973fedcf5a2eea219f10e11ba3dacdd0593f0
* Add the SQLITE_NOTNULL P5 code for comparison operations - really a compositedrh2014-02-19
| | | | | | | | of SQLITE_NULLEQ and SQLITE_JUMPIFNULL. This flag indicates that NULL operands are not possible and raises and assert() if NULL operands are seen. Also omit an unnecessary scan of the sqlite_sequence table when writing into an AUTOINCREMENT table. FossilOrigin-Name: d2c047f304848e49864ed8c216b48fd671fa3916
* Tweaks in support of VDBE branch test coverage.drh2014-02-19
| | | FossilOrigin-Name: b97825646996792d0a67b83f135658027c8569ca
* Add logic to do test coverage measurements on the VDBE code.drh2014-02-17
| | | FossilOrigin-Name: ce184c7bb16988641d37c908d9b3042456d4be3d
* Delete the OP_VerifySchema opcode. Enhance OP_Transaction to do the schemadrh2014-02-06
| | | | | version checks that OP_VerifySchema used to do. FossilOrigin-Name: 2f3376ebf13df44e6acf27cb1f07172cd8b34033
* When possible, use the multi-column samples in sqlite_stat4 to estimate the ↵dan2013-08-06
| | | | | number of index rows scanned by a query plan. FossilOrigin-Name: 2973f5ca736c4a6f13c653d54b6a29d7cae8d0ed
* Shared-cache mode fixes for views and virtual tables.dan2012-10-04
| | | FossilOrigin-Name: 2b370dea704b59262c604af0efcef5660b194454
* Change boolean fields in the Column object from unsigned characters intodrh2012-09-13
| | | | | bits in a single bit mask variable. FossilOrigin-Name: 4163f5f194741bc2bdf141973912661c6aac70f1
* Fix ALTER TABLE RENAME so that it correctly handles triggers that attachdrh2012-02-01
| | | | | | to the table using the name in a different case. Ticket [ae6794effd404]. FossilOrigin-Name: 0d78ebb8e41ba08b446b44694d9433e1e90e0a7e
* Create and use a function especially for adding the ParseSchema opcode.drh2011-06-03
| | | | | This gives a small reduction in code and a small performance increase. FossilOrigin-Name: 957b2ab67c6185f0e1062593d237de5c434a38bf
* Ensure that it is not possible to add a column to a system table using ALTER ↵dan2011-04-01
| | | | | TABLE. FossilOrigin-Name: d9707ef8dcd29667b6d366897f6ad02c87aa0041
* Fix some problems that can occur if a trigger has the same name as another ↵dan2010-09-29
| | | | | database object. FossilOrigin-Name: 655991ec8a781d67d69fc353853403b9a811acf2
* Remove the Table.dbMem variable, as it is no longer being used for its ↵dan2010-07-23
| | | | | original purpose. FossilOrigin-Name: 6eddc6e601cf8f585c6c2cf79f36fcbfe98a307e
* When commands such as ALTER TABLE and VACUUM use SQL internally, make suredrh2010-04-24
| | | | | | they use only the built-in functions and not application-defined overrides for those functions. FossilOrigin-Name: 0291ed974d5bf1e344e2c38422530cc961b897da
* Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraintsdrh2010-02-15
| | | | | | in ATTACH-ed and in TEMP tables as well as in the main database. Ticket [13336e9c3c8c3f]. FossilOrigin-Name: ab197d0aaf18016ac2dd3674f49bea5f1556451c
* Remove the obsolete "$Id:$" RCS identifier strings from the source code.drh2009-11-10
| | | FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
* Suppress some harmless compiler warnings.drh2009-10-13
| | | FossilOrigin-Name: 5d381daa6e5248ec171aa682e2dad058d4012f24
* Fix a segfault that can occur following an OOM fault while renaming adrh2009-10-08
| | | | | table holding foreign key constraints. FossilOrigin-Name: 33973814c67bc9bac575bf2249df6530dd2184d3
* Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER ↵dan2009-09-29
| | | | | and OMIT_ALTER_TABLE. FossilOrigin-Name: e4eb227b14e4bfcb9f7f284692a391b7355f0204
* When ALTER TABLE RENAME TO is used to change the name of a table that is the ↵dan2009-09-26
| | | | | parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. FossilOrigin-Name: b4a10c39e726dc190e9597e382baddc034294114
* Prevent ALTER TABLE from being used to add a column with a REFERENCES clause ↵dan2009-09-25
| | | | | and a non-NULL default value while foreign key support is enabled. FossilOrigin-Name: 353b1b18253ab71ba38a887e555994f5469b87bd
* Combine the OP_Statement and OP_Transaction opcodes.dan2009-09-08
| | | FossilOrigin-Name: aec9dbd8d21c55c3945287a3dfa55d3ed168f977
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 03:38:40 +0000