/ History for src/alter.c
Login

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

History for src/alter.c

2020-05-16
19:00
[e1198116] part of check-in [5af4abe9] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe9] user: drh branch: reuse-schema, size: 55965)
2020-05-14
21:16
[826bc456] part of check-in [eca0ba2c] Do not allow a virtual table to be renamed into the name of one of its shadows. (check-in: [eca0ba2c] user: drh branch: trunk, size: 55979)
2020-05-08
19:02
[8d8e0b51] part of check-in [3a16c0ce] Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: [3a16c0ce] user: drh branch: trunk, size: 55928)
2020-04-07
01:18
[fa2c3be9] part of check-in [230556e8] The ALTER TABLE fix of check-in [7e5ad8e0ab7ee91a] is no longer needed due to the changes at check-in [4cf8721f5ceb1fda]. But, we keep the defense in place as an assert() for extra safety. (check-in: [230556e8] user: drh branch: trunk, size: 55439)
2020-04-06
18:16
[db353ed3] part of check-in [1e4b6a93] Performance improvement for column name lookup. (check-in: [1e4b6a93] user: drh branch: trunk, size: 55431)
2020-04-03
11:20
[ac9d737c] part of check-in [d09f8c36] Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. (check-in: [d09f8c36] user: dan branch: trunk, size: 55383)
2020-01-17
15:33
[d8f92794] part of check-in [b302b260] More restrictions on changes to shadow tables when in defensive mode. (check-in: [b302b260] user: drh branch: branch-3.28, size: 53022)
15:24
[00814c58] part of check-in [3d13fbf2] Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: [3d13fbf2] user: drh branch: branch-3.28, size: 53049)
2020-01-15
14:26
[5584426b] part of check-in [f7839178] Merge all recent enhancements and fixes from trunk. (check-in: [f7839178] user: drh branch: reuse-schema, size: 55008)
2020-01-02
22:23
[f48a4423] part of check-in [34b87774] NEVER() and ALWAYS() macros tagging unreachable branches. (check-in: [34b87774] user: drh branch: two-size-lookaside, size: 55022)
2019-12-31
14:49
[92604dd5] part of check-in [39d55579] Merge recent enhancements from trunk. (check-in: [39d55579] user: drh branch: two-size-lookaside, size: 54979)
2019-12-20
14:18
[bc3e4089] part of check-in [365dd8b6] Fix a potential problem with ALTER TABLE commands on schemas that contains a triggers or view featuring a sub-query that uses an ON clause with a join that is not a LEFT JOIN. (check-in: [365dd8b6] user: dan branch: trunk, size: 54838)
14:08
[ed16ff55] part of check-in [2bbd014c] Fix harmless compiler warnings. (check-in: [2bbd014c] user: drh branch: trunk, size: 54767)
12:55
[ca6d2329] part of check-in [01ca865f] Do not continue an ALTER TABLE tree walk of a subquery if a prior error is seen in the tree. Report the problem immediately, without continuing. (check-in: [01ca865f] user: drh branch: trunk, size: 54854)
2019-12-19
03:14
[ca75938a] part of check-in [4146c629] More restrictions on changes to shadow tables when in defensive mode. (check-in: [4146c629] user: drh branch: branch-3.30, size: 53809)
2019-12-17
12:03
[14b5516b] part of check-in [8223e79f] Clean up the ExprList that holds the names of columns in a CTE before checking for unused references in the ALTER TABLE implementation. (check-in: [8223e79f] user: drh branch: trunk, size: 54804)
2019-12-13
00:49
[accee2f8] part of check-in [59d0f3af] Tie up the loose ends in the ExprList size reduction. (check-in: [59d0f3af] user: drh branch: exprlist-size-reduction, size: 54870)
2019-12-12
20:22
[27aaf104] part of check-in [d3783357] Change the name of the Expr.a.zName field to zEName, so that it has a name that is distinct from other fields and variables and is hence easier to grep for. (check-in: [d3783357] user: drh branch: two-size-lookaside, size: 54733)
2019-12-09
19:29
[9b3d6f8d] part of check-in [c7309ed3] Add a NEVER() to the ALTER TABLE fix in check-in [1d2e53a39b87e364] (check-in: [c7309ed3] user: drh branch: trunk, size: 54729)
08:13
[ef3519bc] part of check-in [1d2e53a3] Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself. (check-in: [1d2e53a3] user: dan branch: trunk, size: 54722)
2019-12-05
14:31
[c49548d0] part of check-in [7e5ad8e0] Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE. (check-in: [7e5ad8e0] user: dan branch: trunk, size: 54414)
2019-12-04
15:08
[8980e4d8] part of check-in [54410f0e] Ensure that an ALWAYS() in the rename logic really is always true, even for faulty inputs. (check-in: [54410f0e] user: drh branch: trunk, size: 54290)
14:26
[3101da36] part of check-in [75b04a4b] Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. (check-in: [75b04a4b] user: dan branch: trunk, size: 54251)
2019-11-16
13:51
[01730734] part of check-in [8ad34d36] Break out the test for writable shadow tables into a separate subroutine. (check-in: [8ad34d36] user: drh branch: defensive-improvements, size: 54220)
2019-10-24
01:04
[0fdf14a1] part of check-in [42fc08bc] Do not allow ALTER TABLE ADD COLUMN for a STORED column. (check-in: [42fc08bc] user: drh branch: generated-columns, size: 54247)
2019-10-19
13:29
[fa7486bf] part of check-in [27ab41c9] Refactor names of column index transformation functions, for clarity. Get generated columns working with ALTER TABLE RENAME COLUMN. (check-in: [27ab41c9] user: drh branch: generated-columns, size: 54129)
2019-10-16
20:05
[8a4317e2] part of check-in [120c6b78] ALTER TABLE is able to add a VIRTUAL column. (check-in: [120c6b78] user: drh branch: generated-columns, size: 53961)
2019-10-11
11:21
[2cd3adae] part of check-in [eff7cd7f] Merge the 3.30.1 changes into reuse-schema. (check-in: [eff7cd7f] user: drh branch: reuse-schema-3.30, size: 53822)
2019-10-09
15:00
[83cf5973] part of check-in [01ba4641] Change sqlite3SelectDup() to always return NULL if an OOM has occurred. (check-in: [01ba4641] user: drh branch: trunk, size: 53794)
2019-10-07
18:43
[5773b286] part of check-in [31e85fbb] Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. (check-in: [31e85fbb] user: dan branch: trunk, size: 53836)
2019-08-13
15:22
[deddf439] part of check-in [5b4689d8] Merge latest trunk changes with this branch. (check-in: [5b4689d8] user: dan branch: reuse-schema, size: 53795)
2019-08-12
00:08
[5c3031e4] part of check-in [724f4df9] Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: [724f4df9] user: drh branch: trunk, size: 53809)
2019-07-08
21:32
[0042c5ab] part of check-in [fae92fee] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [fae92fee] user: drh branch: reuse-schema, size: 53782)
12:44
[3c5b9bdf] part of check-in [b0629132] Comment improvements. No changes to code. (check-in: [b0629132] user: drh branch: tkt9b78184b-alt, size: 56364)
2019-07-02
20:10
[bb45a2df] 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: 56219)
2019-06-15
15:21
[c1b5e563] part of check-in [d3b6f166] Ensure that sqlite3RenameExprUnmap() does an unmap of the result set alias names in subqueries when ALTER TABLE fails because of a syntax error in a trigger. (check-in: [d3b6f166] user: drh branch: trunk, size: 53796)
2019-06-11
16:43
[12f8c9a7] part of check-in [d4755aca] Mark an unreachable branch with an ALWAYS macro. (check-in: [d4755aca] user: drh branch: trunk, size: 53563)
12:03
[29fcfd07] part of check-in [f2c8179f] Have the ALTER TABLE code handle the case where an entire expression that includes a sub-select is excluded from a view, trigger or index. (check-in: [f2c8179f] user: dan branch: trunk, size: 53501)
2019-05-14
22:25
[7b060214] part of check-in [018f3199] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [018f3199] user: drh branch: reuse-schema, size: 53112)
2019-04-19
16:34
[85b41586] part of check-in [a2ead8aa] Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65]. (check-in: [a2ead8aa] user: dan branch: trunk, size: 53126)
2019-03-20
16:03
[7516a6e3] part of check-in [4cd20ca6] Merge latest trunk changes into this branch. (check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 53022)
2019-03-15
16:17
[25f54387] part of check-in [0f2129f5] Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a]. (check-in: [0f2129f5] user: dan branch: trunk, size: 53036)
2019-02-18
18:16
[669e18e9] part of check-in [88cbf54e] Ensure that creating temp schema items does not cause an OPEN_SHARABLE_SCHEMA connection to load all schemas into memory. (check-in: [88cbf54e] user: dan branch: reuse-schema, size: 52951)
2019-02-05
19:51
[995b37de] part of check-in [c089cc4f] Merge latest trunk into this branch. (check-in: [c089cc4f] user: dan branch: reuse-schema, size: 52933)
2019-01-18
16:06
[cb691d6c] part of check-in [64bec9e6] Fix a fairly obscure problem allowing an "ALTER TABLE RENAME col TO ..." statement to modify the schema in such a way as to break a reference within a trigger program. (check-in: [64bec9e6] user: dan branch: trunk, size: 52947)
2019-01-13
00:58
[8ac946d8] part of check-in [ac3b6021] Move a local variable declaration into the outermost scope in which it is used. This fixes an ASAN warning. (check-in: [ac3b6021] user: drh branch: trunk, size: 52915)
2019-01-09
02:02
[9dda6a9c] 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: 52921)
2018-12-18
20:31
[082286f8] part of check-in [23e200da] In defensive mode, do not allow shadow tables to be renamed using ALTER TABLE. (check-in: [23e200da] user: dan branch: trunk, size: 52806)
2018-12-06
01:53
[87c9057f] part of check-in [ea50815b] Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. (check-in: [ea50815b] user: drh branch: trunk, size: 52643)
2018-12-05
13:49
[80747854] part of check-in [f44bc7a8] Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. (check-in: [f44bc7a8] user: dan branch: trunk, size: 52551)
2018-11-26
18:09
[f886160d] 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: 52043)
15:00
[a61ed147] part of check-in [12920bcb] Minor comment enhancement in alter.c. No changes to code. (check-in: [12920bcb] user: drh branch: trunk, size: 52385)
2018-11-20
16:02
[f4ba663e] part of check-in [dfab7170] Consolidate the two sqlite3SchemaToIndex() routines. (check-in: [dfab7170] user: dan branch: reuse-schema1, size: 52399)
2018-11-19
20:41
[3e283b57] part of check-in [84be9220] Fix a problem with virtual tables in shared schemas. (check-in: [84be9220] user: dan branch: reuse-schema1, size: 52407)
2018-11-17
18:45
[ab7f9763] part of check-in [9fdd1868] Merge latest trunk changes into this branch. (check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 52165)
2018-11-16
17:04
[486cfbe8] part of check-in [9780829a] Fix further REUSE_SCHEMA issues. (check-in: [9780829a] user: dan branch: reuse-schema1, size: 52148)
2018-11-09
20:04
[61c1ace4] part of check-in [ae9638e9] When a table is renamed using "ALTER TABLE RENAME TO", update any REFERENCES clauses that refer to the table, unless "PRAGMA legacy_alter_table" is true and "PRAGMA foreign_keys" is set to false (i.e. so that when "PRAGMA legacy_alter_table" is set behaviour is still compatible with versions 3.24 and earlier). (check-in: [ae9638e9] user: dan branch: trunk, size: 52155)
2018-10-08
18:58
[59fa3409] part of check-in [2ac72114] Merge latest trunk changes into this branch. (check-in: [2ac72114] user: dan branch: reuse-schema, size: 52124)
2018-10-06
14:33
[27281c6e] part of check-in [dac28547] Ensure each ALTER TABLE statement makes just a single SQLITE_ALTER_TABLE call to the authorizer function. (check-in: [dac28547] user: dan branch: alter-auth-callbacks, size: 52609)
2018-10-03
18:05
[bcb67339] part of check-in [ebcd4523] Add an ALWAYS on an unreachable branch in the ALTER TABLE logic. (check-in: [ebcd4523] user: drh branch: trunk, size: 52138)
2018-10-01
07:04
[b929e4da] part of check-in [c52f457e] Fix a problem with ALTER TABLE commands when the schema features an INSTEAD of trigger that uses NEW.* or OLD.*. (check-in: [c52f457e] user: dan branch: trunk, size: 52008)
2018-09-20
20:15
[65fc93f6] part of check-in [7edd26ed] Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. (check-in: [7edd26ed] user: drh branch: trunk, size: 51893)
19:02
[e561794b] part of check-in [ad130bb8] Combine the Expr.pTab and Expr.pWin fields into a union named "y". Add a new EP_WinFunc property that is only true if Expr.y.pWin is a valid pointer. This reduces the size of the Expr object by 8 bytes, reduces the overall amount of code, and shaves over 1 million cycles off of the speed test. (check-in: [ad130bb8] user: drh branch: trunk, size: 51539)
17:21
[70dd115e] part of check-in [71947337] By default, make all "ALTER TABLE RENAME" statements executed within a virtual table xRename() method exhibit the legacy behaviour. (check-in: [71947337] user: dan branch: legacy-alter-table, size: 51887)
08:28
[5bca9ae0] part of check-in [5acad2e9] Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. (check-in: [5acad2e9] user: dan branch: legacy-alter-table, size: 51887)
2018-09-19
20:14
[3a859149] part of check-in [24b0f66a] Reduce the size of Expr to 64-bytes. This works somewhat, but there are test failures. More importantly, the size reduction from 80- to 64-bytes has not lowered the schema memory usage, but it has made the code a little bigger and a little slower. So the initial evidence is that this Expr refactoring experiment is not working... (check-in: [24b0f66a] user: drh branch: expr-simplify, size: 51609)
2018-09-17
13:38
[2269dd2f] part of check-in [4d8be404] Minor modification to the fix on this branch to avoid adding extra conditional compilation macros. (check-in: [4d8be404] user: dan branch: tkt-b41031ea, size: 51533)
2018-09-12
15:51
[3800f24c] part of check-in [4396914f] Restrict the scope of internal-use functions in alter.c. (check-in: [4396914f] user: drh branch: trunk, size: 51466)
08:51
[b04e36e2] 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: 51445)
2018-09-07
18:52
[eed84737] part of check-in [8fa254aa] Add assert() and ALWAYS() to identify two unreachable branches. (check-in: [8fa254aa] user: drh branch: trunk, size: 50970)
15:50
[54146be0] part of check-in [ceb60bd7] Fix a problem with renaming a non-temp table that has at least one temp trigger and shares its name with a temp table. (check-in: [ceb60bd7] user: dan branch: trunk, size: 50962)
11:51
[525d74d3] part of check-in [1a8aedc3] Minor fixes for problems revealed by releasetest.tcl. (check-in: [1a8aedc3] user: dan branch: trunk, size: 50919)
2018-09-06
17:47
[b4c7e8f7] part of check-in [fa835145] Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [fa835145] user: dan branch: trunk, size: 50847)
16:01
[9088b817] part of check-in [ffecfca5] Ensure that the tbl_name column in the sqlite_temp_master table is updated correctly as part of a RENAME TABLE operation. (check-in: [ffecfca5] user: dan branch: alter-table-rename-column, size: 50852)
2018-09-05
14:36
[900f64f0] part of check-in [2ec7e50c] Avoid comparing pointer values after the object that they point to has been deleted. (check-in: [2ec7e50c] user: dan branch: alter-table-rename-column, size: 50312)
08:28
[03195c21] part of check-in [18ba35b8] Fix minor code issues in alter.c. (check-in: [18ba35b8] user: dan branch: alter-table-rename-column, size: 48789)
2018-09-03
20:05
[8e6fc7ba] part of check-in [6805b590] Improve the error messages emitted by RENAME TABLE. (check-in: [6805b590] user: dan branch: alter-table-rename-column, size: 46837)
2018-09-01
20:23
[f309bac1] 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: 46602)
20:02
[24c05a7b] part of check-in [41b8f38b] Fixes for harmless compiler warnings. (check-in: [41b8f38b] user: drh branch: alter-table-rename-column, size: 46529)
16:55
[f07588d9] part of check-in [2e2cf992] Fix some harmless compiler warnings and improve defenses against OOM errors. (check-in: [2e2cf992] user: drh branch: alter-table-rename-column, size: 46767)
16:05
[86affdc4] part of check-in [8d89ddc1] Have "ALTER TABLE ADD COLUMN" reload the entire db schema, as "RENAME COLUMN" and "RENAME TABLE" do. (check-in: [8d89ddc1] user: dan branch: alter-table-rename-table, size: 46859)
15:55
[245152da] 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: 51005)
2018-08-31
18:23
[6fa0efb0] part of check-in [eac2aa7d] Ensure b-tree mutexes are always held when sqlite3FindTable() is called. Do not invoke the authorizer callback when parsing schema items as part of ALTER TABLE commands. Fix test script issues. (check-in: [eac2aa7d] user: dan branch: alter-table-rename-table, size: 50812)
2018-08-30
20:03
[5ff9eba0] 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: 50522)
16:26
[f46a4188] part of check-in [72cfb1be] Fix an ALTER TABLE problem with processing temp schema views and triggers. (check-in: [72cfb1be] user: dan branch: alter-table-rename-table, size: 48794)
2018-08-29
21:00
[78188ded] part of check-in [01308bae] Extend RENAME TABLE to edit triggers and views. Still buggy. (check-in: [01308bae] user: dan branch: alter-table-rename-table, size: 48748)
2018-08-25
16:14
[cd45c47c] part of check-in [fc293bcb] Invoke the authorizer for ALTER TABLE RENAME COLUMN. (check-in: [fc293bcb] user: drh branch: alter-table-rename-column, size: 50281)
02:04
[64dcb3cb] part of check-in [f0eed21d] The implementation of sqlite_rename_column() must be holding the schema mutexes. (check-in: [f0eed21d] user: drh branch: alter-table-rename-column, size: 50088)
2018-08-24
20:20
[39c6b7f9] 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: 49993)
20:10
[1e0fc6d0] 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: 50046)
17:55
[4433a450] 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: 49846)
16:04
[6b381569] 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: 49221)
2018-08-23
19:32
[070bf02d] 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: 49190)
2018-08-21
16:32
[54c347c1] part of check-in [b9ae9a0a] Rename internal function sqlite3RenameToken() to sqlite3RenameTokenMap() and sqlite3MoveRenameToken() to sqlite3RenameTokenRemap(). (check-in: [b9ae9a0a] user: dan branch: alter-table-rename-column, size: 49165)
15:06
[0c27d981] 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: 49113)
08:29
[d8882d67] part of check-in [47997695] Minor changes to function tokenExpr() in order to claw back cycles lost to the rename-column change. (check-in: [47997695] user: dan branch: alter-table-rename-column, size: 48932)
2018-08-20
20:01
[efe002e3] part of check-in [82c4c10a] Add further tests for RENAME COLUMN. (check-in: [82c4c10a] user: dan branch: alter-table-rename-column, size: 48916)
16:16
[bfd9803d] 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: 48838)
2018-08-18
18:27
[3c041cee] part of check-in [9d8e73bf] Additional fixes for harmless compiler warnings that are specific to this branch. (check-in: [9d8e73bf] user: drh branch: alter-table-rename-column, size: 47830)
17:35
[3342dba2] part of check-in [7fa1faea] Improvements to error handling in ALTER TABLE RENAME COLUMN. (check-in: [7fa1faea] user: dan branch: edit-trigger-wrapper, size: 47749)
2018-08-17
18:08
[c81f6d8d] 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: 45828)
2018-08-16
19:49
[c16b42be] 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: 45783)
2018-08-15
20:28
[1452a35d] 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: 44875)
2018-08-14
21:05
[e1f3a719] 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: 42386)
21:03
[35512b6c] 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: 40156)
20:38
[b3f6b775] part of check-in [f6d6b472] Do not allow ALTER TABLE RENAME COLUMN on a virtual table. (check-in: [f6d6b472] user: drh branch: alter-table-rename-column, size: 40157)
20:18
[03a90ab3] 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: 42391)
19:27
[ec59506c] part of check-in [37d11b8e] Improved error messages when an ALTER TABLE RENAME COLUMN fails due to a duplicate column name. (check-in: [37d11b8e] user: drh branch: alter-table-rename-column, size: 39938)
16:18
[918b76c6] 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: 39969)
2018-08-13
17:14
[9f823184] 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: 38805)
17:02
[5367a548] part of check-in [87743dde] Make the sqlite_rename_column() SQL function resistant to problems caused by OOMs and/or malformed parameters submitted by hostile application code. Also add additional comments to the RENAME COLUMN logic. (check-in: [87743dde] user: drh branch: alter-table-rename-column, size: 40313)
15:09
[7a8e8f14] part of check-in [32edc892] Fix legacy comments on Token. Begin commenting the new ALTER TABLE RENAME COLUMN code. Fix a memory leak in the sqlite_rename_column() SQL function. (check-in: [32edc892] user: drh branch: alter-table-rename-column, size: 38170)
13:43
[cebb1e33] part of check-in [0b28dd5c] Fix issues with ALTER TABLE RENAME COLUMN associated with OOM errors. (check-in: [0b28dd5c] user: drh branch: alter-table-rename-column, size: 35780)
2018-08-11
20:38
[87911da1] 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: 35718)
17:49
[8c3ce112] 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: 35624)
17:34
[26ddd598] 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: 35514)
13:40
[3a3e29b3] 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: 35427)
2018-08-10
20:19
[0b71fa1e] 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: 35357)
19:33
[2be0bc29] part of check-in [9564d700] Fix harmless compiler warnings. (check-in: [9564d700] user: drh branch: alter-table-rename-column, size: 35316)
19:19
[f5c2b068] 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: 35367)
2018-08-09
20:47
[94baeaee] 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: 34649)
2018-06-30
20:00
[6beb4760] part of check-in [763e6c9e] Fix a minor problem in the code for determining whether or not an SQL statement is SQLITE_TOOBIG. (check-in: [763e6c9e] user: dan branch: exp-window-functions, size: 27153)
2018-06-06
23:31
[819b14b5] part of check-in [71f97f0f] Change a comma into a logically equivalent but semantically clearer semicolon. (check-in: [71f97f0f] user: drh branch: trunk, size: 27133)
2017-08-09
20:35
[748950c5] part of check-in [a6256980] Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. (check-in: [a6256980] user: dan branch: reuse-schema, size: 27144)
2017-07-26
19:59
[cf7a8af4] part of check-in [3808a00f] Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. (check-in: [3808a00f] user: drh branch: trunk, size: 27134)
2017-06-28
01:12
[850ede4e] part of check-in [bfc4e7f3] Minor code simplification in the ALTER TABLE logic. (check-in: [bfc4e7f3] user: drh branch: trunk, size: 27113)
2016-12-16
01:00
[3b239776] part of check-in [8d646905] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905] user: drh branch: trunk, size: 27141)
2016-12-14
14:07
[0f83ee1d] part of check-in [9cae4c2e] Refactor the Table.nRef field as Table.nTabRef for easier grepping. (check-in: [9cae4c2e] user: drh branch: trunk, size: 27159)
2016-08-18
14:33
[29911769] part of check-in [92a22f01] Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (check-in: [92a22f01] user: drh branch: zDbSName, size: 27153)
2016-07-14
19:13
[cc28ab93] part of check-in [a7db6e45] Fix ALTER TABLE so that it does not promote the schema version past 3, as that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. (check-in: [a7db6e45] user: drh branch: trunk, size: 27147)
2016-02-29
15:53
[1bb0709b] part of check-in [842b2116] Reduce the amount of heap required to store many schemas by storing each column datatype appended to the column name, rather than as a separate allocation. (check-in: [842b2116] user: drh branch: schema-storage, size: 27136)
2016-02-27
21:16
[44e18dfd] part of check-in [d8c94a46] Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. (check-in: [d8c94a46] user: drh branch: trunk, size: 27157)
2016-02-15
00:34
[7603afbd] part of check-in [3201fbcc] Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. (check-in: [3201fbcc] user: drh branch: many-app-functions, size: 27127)
2016-02-09
16:09
[1fbb01c2] part of check-in [e1d8ec85] Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format 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. (check-in: [e1d8ec85] user: drh branch: trunk, size: 27302)
2016-02-06
14:14
[d50b7dbb] part of check-in [a2952231] Fix an assert() to have a test instead of a side effect (check-in: [a2952231] user: pdr branch: trunk, size: 27882)
2016-02-05
01:55
[e4a5132e] part of check-in [c3ef0347] Improvements to the way that OOM errors are processed. (check-in: [c3ef0347] user: drh branch: oom-handling, size: 27881)
2016-02-04
11:48
[b6e0befc] part of check-in [b787165b] Remove unnecessary sets of db->mallocFailed. (check-in: [b787165b] user: drh branch: trunk, size: 27871)
2016-02-01
21:48
[3fe13e97] part of check-in [6d7d4703] Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (check-in: [6d7d4703] user: drh branch: trunk, size: 27865)
2015-10-10
14:41
[9d649e46] part of check-in [9ddef84d] Compiler warning fixes: Rename some local variables from "j1" to avoid a name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. (check-in: [9ddef84d] user: drh branch: trunk, size: 27858)
2015-09-03
13:46
[4911e1f1] part of check-in [847387ec] Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). (check-in: [847387ec] user: drh branch: trunk, size: 27849)
2015-06-02
15:32
[48e14b8a] part of check-in [bce3f041] Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB. (check-in: [bce3f041] user: drh branch: blob-affinity-rename, size: 27866)
2015-04-28
14:07
[8f6dc4a6] part of check-in [36e51526] Fix an assert() failure that could occur if the internal sqlite3_rename_parent() SQL scalar function was invoked directly. (check-in: [36e51526] user: dan branch: trunk, size: 27866)
2015-03-12
21:02
[d23d6b69] part of check-in [a991bb1a] Always disallow functions as the DEFAULT of a column. Add assert()s and (check-in: [a991bb1a] user: drh branch: stat4-function, size: 27829)
2015-03-11
20:59
[809313dd] part of check-in [ff868e22] Allow the default value for columns added using ALTER TABLE ADD COLUMN to be a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. (check-in: [ff868e22] user: dan branch: stat4-function, size: 27780)
2014-09-06
16:39
[ba266a77] part of check-in [e62aab5e] Fix typos in comments. No code changes. (check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 27744)
2014-05-19
15:16
[05664d98] part of check-in [17349a49] Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. (check-in: [17349a49] user: drh branch: safer-malloc, size: 27751)
2014-04-14
19:48
[b0090087] part of check-in [c6fa8d0d] Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] (check-in: [c6fa8d0d] user: drh branch: trunk, size: 27746)
2014-02-20
19:23
[5d99edba] part of check-in [d5d973fe] Make sure that the difference between two string pointers is passed into sqlite3_mprintf() as type "int". (check-in: [d5d973fe] user: drh branch: trunk, size: 27709)
2014-02-19
14:20
[75a0b861] part of check-in [d2c047f3] Add the SQLITE_NOTNULL P5 code for comparison operations - really a composite 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. (check-in: [d2c047f3] user: drh branch: trunk, size: 27690)
00:53
[1a630c65] part of check-in [b9782564] Tweaks in support of VDBE branch test coverage. (check-in: [b9782564] user: drh branch: trunk, size: 27689)
2014-02-17
22:40
[829d67a3] part of check-in [ce184c7b] Add logic to do test coverage measurements on the VDBE code. (check-in: [ce184c7b] user: drh branch: insert-optimization, size: 27646)
2014-02-06
23:56
[d5348d0f] part of check-in [2f3376eb] Delete the OP_VerifySchema opcode. Enhance OP_Transaction to do the schema version checks that OP_VerifySchema used to do. (check-in: [2f3376eb] user: drh branch: trunk, size: 27629)
2013-08-06
20:01
[2af0330b] part of check-in [2973f5ca] When possible, use the multi-column samples in sqlite_stat4 to estimate the number of index rows scanned by a query plan. (check-in: [2973f5ca] user: dan branch: sqlite_stat4, size: 27655)
2012-10-26
13:34
[c3d9d0d6] part of check-in [325364a9] Backport the shared-cache-fix branch. (check-in: [325364a9] user: drh branch: branch-3.7.14, size: 27634)
2012-10-05
18:35
[ecf32968] part of check-in [ac81ae49] Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (check-in: [ac81ae49] user: drh branch: branch-3.7.9, size: 27619)
2012-10-04
19:33
[f8db986c] part of check-in [2b370dea] Shared-cache mode fixes for views and virtual tables. (check-in: [2b370dea] user: dan branch: shared-cache-fix, size: 27651)
2012-09-13
14:22
[0c1716aa] part of check-in [4163f5f1] Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. (check-in: [4163f5f1] user: drh branch: trunk, size: 27697)
2012-02-01
01:13
[149cc80d] part of check-in [0d78ebb8] Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. (check-in: [0d78ebb8] user: drh branch: trunk, size: 27680)
2011-06-03
20:11
[ac80a0f3] part of check-in [957b2ab6] Create and use a function especially for adding the ParseSchema opcode. This gives a small reduction in code and a small performance increase. (check-in: [957b2ab6] user: drh branch: trunk, size: 27665)
2011-04-01
15:15
[280f5c04] part of check-in [d9707ef8] Ensure that it is not possible to add a column to a system table using ALTER TABLE. (check-in: [d9707ef8] user: dan branch: trunk, size: 27713)
2010-09-28
19:16
[6a0c176e] part of check-in [655991ec] Fix some problems that can occur if a trigger has the same name as another database object. (check-in: [655991ec] user: dan branch: trunk, size: 27139)
2010-07-25
02:12
[2b9a10af] part of check-in [da2f62c5] Further examples of using automatic deallocation to replace "delete" methods. (check-in: [da2f62c5] user: drh branch: malloc-enhancement, size: 27018)
2010-07-23
15:41
[8dc27638] part of check-in [6eddc6e6] Remove the Table.dbMem variable, as it is no longer being used for its original purpose. (check-in: [6eddc6e6] user: dan branch: trunk, size: 26981)
2010-04-24
14:02
[a9ff6f14] part of check-in [0291ed97] When commands such as ALTER TABLE and VACUUM use SQL internally, make sure they use only the built-in functions and not application-defined overrides for those functions. (check-in: [0291ed97] user: drh branch: trunk, size: 27010)
2010-02-25
14:44
[f1c7a868] part of check-in [a2550597] Add some technically unnecessary variable initializations to silence compiler warnings. (check-in: [a2550597] user: dan branch: branch-3.6.1, size: 20654)
2010-02-15
18:03
[e6f4d11b] part of check-in [ab197d0a] Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraints in ATTACH-ed and in TEMP tables as well as in the main database. Ticket [13336e9c3c8c3f]. (check-in: [ab197d0a] user: drh branch: trunk, size: 26625)
2009-11-10
01:30
[92ba9385] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 26605)
2009-10-13
13:08
[9e4b52e6] part of check-in [5d381daa] Suppress some harmless compiler warnings. (check-in: [5d381daa] user: drh branch: trunk, size: 26669)
2009-10-08
01:43
[ee4c8b09] part of check-in [33973814] Fix a segfault that can occur following an OOM fault while renaming a table holding foreign key constraints. (check-in: [33973814] user: drh branch: trunk, size: 26640)
2009-09-29
06:33
[1b63d4f2] part of check-in [e4eb227b] Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (check-in: [e4eb227b] user: dan branch: trunk, size: 26610)
2009-09-26
17:51
[082657ce] part of check-in [b4a10c39] When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. (check-in: [b4a10c39] user: dan branch: trunk, size: 26454)
2009-09-25
11:26
[e771528d] part of check-in [353b1b18] Prevent ALTER TABLE from being used to add a column with a REFERENCES clause and a non-NULL default value while foreign key support is enabled. (check-in: [353b1b18] user: dan branch: trunk, size: 22196)
2009-09-08
19:15
[0bbc3429] part of check-in [aec9dbd8] Combine the OP_Statement and OP_Transaction opcodes. (check-in: [aec9dbd8] user: dan branch: trunk, size: 22016)
2009-08-28
18:53
[55b60185] part of check-in [9b9c1921] Changes to support recursive triggers. (check-in: [9b9c1921] user: dan branch: trunk, size: 21987)
2009-07-24
17:58
[8b42cace] part of check-in [5d9e767a] Allow virtual tables to be used in shared-cache mode. (CVS 6928) (check-in: [5d9e767a] user: danielk1977 branch: trunk, size: 21984)
2009-06-03
11:25
[95f41d95] part of check-in [6dbf4eca] Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) (check-in: [6dbf4eca] user: danielk1977 branch: trunk, size: 21954)
2009-05-28
01:00
[88b8cc66] part of check-in [4ac2bdfb] Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: [4ac2bdfb] user: drh branch: trunk, size: 21914)
2009-05-27
10:31
[accb3c77] part of check-in [7cb1c3ba] Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) (check-in: [7cb1c3ba] user: drh branch: trunk, size: 21914)
2009-05-12
17:46
[f0430ee6] part of check-in [6fe3750a] Move the sqlite3MinimumFileFormat() routine from build.c over to alter.c since alter.c is the only code that uses it. Additional changes and cleanup to build.c to facility coverage testing. (CVS 6630) (check-in: [6fe3750a] user: drh branch: trunk, size: 21865)
2009-04-16
16:30
[8ab5824b] part of check-in [6a91ab08] Changes to alter.c to enable full branch coverage testing. (CVS 6513) (check-in: [6a91ab08] user: drh branch: trunk, size: 20972)
2009-04-15
13:39
[cf3d0583] part of check-in [c0bba77a] Mark an branch in alter.c as always false. Only run the assert() on the sqlite3_aggregate_count() function in func.c if the SQLITE_OMIT_DEPRECATED compile-time option is off. (CVS 6508) (check-in: [c0bba77a] user: drh branch: trunk, size: 20965)
2009-03-24
15:08
[472c0a47] part of check-in [ea74d8dc] Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) (check-in: [ea74d8dc] user: drh branch: trunk, size: 20956)
2009-02-28
10:47
[b95815cc] part of check-in [3befe1ef] Instead of linking temporary triggers on non-temporary tables into the Table.pTrigger list, search the temp schema for them on demand. Fix for #3688. (CVS 6329) (check-in: [3befe1ef] user: danielk1977 branch: trunk, size: 20952)
2009-02-13
03:43
[f93d13aa] part of check-in [dd179ff2] Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) (check-in: [dd179ff2] user: drh branch: trunk, size: 20910)
2009-01-20
16:53
[0ec29744] part of check-in [1041abd6] When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) (check-in: [1041abd6] user: danielk1977 branch: trunk, size: 20590)
2008-12-10
19:26
[7eee66a6] part of check-in [c872d554] Never use strlen(). Use our own internal sqlite3Strlen30() which is guaranteed to never overflow an integer. Additional explicit casts to avoid nuisance warning messages. (CVS 6007) (check-in: [c872d554] user: drh branch: trunk, size: 20611)
2008-11-19
09:05
[0a00c184] part of check-in [88134322] Changes to avoid "unused parameter" compiler warnings. (CVS 5921) (check-in: [88134322] user: danielk1977 branch: trunk, size: 20604)
2008-10-30
17:21
[a03c9236] part of check-in [0996783b] Fix a crash that can follow a malloc failure in sqlite3ValueFromExpr(). Ticket #3468. (CVS 5851) (check-in: [0996783b] user: danielk1977 branch: trunk, size: 20539)
2008-08-08
14:19
[f462b637] part of check-in [4cedc641] Disallow the ON CONFLICT clause on CHECK constraints. The syntax used to be allowed but never worked, so this should not present compatibility problems. Other internal grammar simplifications. (CVS 5546) (check-in: [4cedc641] user: drh branch: trunk, size: 20511)
2008-07-28
19:34
[2c541aaa] part of check-in [e48f9697] Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) (check-in: [e48f9697] user: drh branch: trunk, size: 20532)
2008-07-15
14:47
[73ec449c] part of check-in [c942a38e] Continuing work on improved test coverage. (CVS 5415) (check-in: [c942a38e] user: drh branch: trunk, size: 20483)
2008-07-07
12:44
[c74accc3] part of check-in [3e558acd] Fix a comment in alter.c. No changes to code. (CVS 5347) (check-in: [3e558acd] user: drh branch: trunk, size: 20677)
2008-05-09
14:17
[cc38b9e2] part of check-in [ab18b4e7] Fix the ALTER TABLE RENAME algorithm so that it is not confused by comments in the CREATE TABLE statement. Ticket #3102. (CVS 5110) (check-in: [ab18b4e7] user: drh branch: trunk, size: 20700)
2008-03-19
21:45
[b42d7829] part of check-in [54c55cae] Add a new interface, sqlite3_context_db_handle(), that returns the database connection pointer for an application-defined function. (CVS 4889) (check-in: [54c55cae] user: drh branch: trunk, size: 20670)
2008-02-09
14:30
[b494a50f] part of check-in [607247c2] ALTER TABLE uses double-quotes for quoting table names. (CVS 4781) (check-in: [607247c2] user: drh branch: trunk, size: 20663)
2008-01-25
15:04
[8a34c900] part of check-in [50815a82] Error messages says "no such view" instead of "no such table" when trying to DROP a VIEW that does not exist. (CVS 4750) (check-in: [50815a82] user: drh branch: trunk, size: 20647)
2008-01-17
16:22
[2a101cb0] part of check-in [706b41b7] Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) (check-in: [706b41b7] user: drh branch: trunk, size: 20641)
2008-01-04
22:01
[5a54f58d] part of check-in [fe057a88] Implement the out2-prerelease opcode design pattern. (CVS 4681) (check-in: [fe057a88] user: drh branch: trunk, size: 20639)
11:01
[b59c8810] part of check-in [8bb9f970] Add OP_MemSet, for setting a memory cell to a string value. (CVS 4674) (check-in: [8bb9f970] user: danielk1977 branch: trunk, size: 20777)
2008-01-03
18:39
[f95b19da] part of check-in [253ed40a] Modify VFilter and VRename to use registers instead of the vdbe stack for inputs. (CVS 4670) (check-in: [253ed40a] user: danielk1977 branch: trunk, size: 20668)
00:01
[b58ed3be] part of check-in [027875e4] Refactoring the VM. The P3 parameter is changed to P4. A P5 parameter is added (though not currently used.) Add routines sqlite3VdbeAddOpX() where X is one of 0, 1, 2, 3, or 4. (CVS 4660) (check-in: [027875e4] user: drh branch: trunk, size: 20611)
2007-12-13
21:54
[23d18ec5] part of check-in [4e91a267] Change all instances of "it's" in comments to either "its" or "it is", as appropriate, in case the comments are ever again read by a pedantic grammarian. Ticket #2840. (CVS 4629) (check-in: [4e91a267] user: drh branch: trunk, size: 20576)
08:15
[451da14f] part of check-in [19d56d99] Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831. (CVS 4623) (check-in: [19d56d99] user: danielk1977 branch: trunk, size: 20586)
2007-10-20
20:58
[8512ed31] part of check-in [82b08a3d] Use the 2-argument version of substr() in the SQL contained in the VACUUM and ALTER TABLE commands. Ticket #2737. (CVS 4499) (check-in: [82b08a3d] user: drh branch: trunk, size: 20418)
2007-08-29
14:06
[c9f30b4d] part of check-in [c790c234] Use the DbMalloc() and DbRealloc() functions more consistently. (CVS 4323) (check-in: [c790c234] user: danielk1977 branch: trunk, size: 20441)
04:00
[977eeee3] part of check-in [e8060f85] Better asserts(). But now some of the tests are busted again. (CVS 4320) (check-in: [e8060f85] user: drh branch: trunk, size: 20427)
2007-08-25
13:09
[fd78c600] part of check-in [e5ec1707] Fix bugs in the altermalloc.test and incrblob_err.test scripts. (CVS 4295) (check-in: [e5ec1707] user: danielk1977 branch: trunk, size: 20239)
2007-08-16
10:09
[f0aac006] part of check-in [77b16713] More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) (check-in: [77b16713] user: danielk1977 branch: trunk, size: 20236)
04:30
[27b0c0d3] part of check-in [deb7ecd6] Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) (check-in: [deb7ecd6] user: drh branch: trunk, size: 20067)
2007-06-27
17:09
[24c81ed6] part of check-in [57840eba] Test error handling when renaming fts2 tables. (CVS 4144) (check-in: [57840eba] user: danielk1977 branch: trunk, size: 19961)
15:53
[3402b657] part of check-in [37d1f9f3] Allow ALTER TABLE on virtual tables. (CVS 4142) (check-in: [37d1f9f3] user: danielk1977 branch: trunk, size: 19880)
2007-05-15
14:34
[1b1deeb9] part of check-in [262a3e63] Relax the restriction on using bytes 0x80 through 0xbf as the first character of an identifier. Enhancements to ALTER TABLE tests for tables with strange names or stange column names. (CVS 4008) (check-in: [262a3e63] user: drh branch: trunk, size: 19226)
03:56
[357378a0] part of check-in [9ff382f4] Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) (check-in: [9ff382f4] user: drh branch: trunk, size: 19316)
2007-05-08
12:37
[ca8fc4a3] part of check-in [c2f90b46] Do not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger() if they are somehow passed unexpected input. (CVS 3944) (check-in: [c2f90b46] user: danielk1977 branch: trunk, size: 18984)
2006-09-08
12:27
[2c79ec40] part of check-in [c81eaa0d] Bug fix in date/time computations. Ticket #1964. Some unrelated comment typos are also fixed and got accidently checked in at the same time. (CVS 3396) (check-in: [c81eaa0d] user: drh branch: trunk, size: 18731)
2006-06-21
12:36
[eba661e7] part of check-in [6c3e8852] Add tests to make sure altering or adding an index to a virtual table is prohibited. (CVS 3280) (check-in: [6c3e8852] user: danielk1977 branch: trunk, size: 18753)
2006-02-09
02:56
[451b34fc] part of check-in [baef2f66] Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) (check-in: [baef2f66] user: drh branch: trunk, size: 18414)
2006-01-31
14:28
[faf98b04] part of check-in [461f5869] Authorization callback on the ALTER TABLE ADD COLUMN command. Ticket #1479. (CVS 3043) (check-in: [461f5869] user: drh branch: trunk, size: 18393)
2006-01-18
16:51
[90b779cf] part of check-in [ac090f2a] Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) (check-in: [ac090f2a] user: danielk1977 branch: trunk, size: 18225)
2006-01-17
13:21
[f1b66e9a] part of check-in [0505405f] Various fixes that allow the malloc() failure tests to pass again. (CVS 2963) (check-in: [0505405f] user: danielk1977 branch: trunk, size: 18265)
2006-01-11
21:41
[4139c8f1] part of check-in [5d9c6aa9] Automatically deallocate thread-specific data when it is no longer being used. Ticket #1601. Also implemented the suggestion of ticket #1603. Memory management is now off by default at compile-time. The sqlite3_enable_memory_management() API has been removed. (CVS 2919) (check-in: [5d9c6aa9] user: drh branch: trunk, size: 18263)
2006-01-09
06:29
[d0dd079b] part of check-in [82b81f69] Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: [82b81f69] user: danielk1977 branch: trunk, size: 18255)
2006-01-05
11:34
[e9deb3f4] part of check-in [deeda0dc] Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 18243)
2005-12-21
14:43
[5905a337] part of check-in [7064433e] Basic functionality for descending indices is in place. Lots more testing needed. (CVS 2840) (check-in: [7064433e] user: drh branch: trunk, size: 17543)
2005-12-16
01:06
[7bc737c6] part of check-in [cd110aa2] Initial infrastructure for recognizing DESC indices and being able to read and write older databases that specify DESC indices but do not really use them. Nothing is close to working yet. (CVS 2822) (check-in: [cd110aa2] user: drh branch: trunk, size: 18100)
2005-12-09
20:02
[26e59061] part of check-in [83a59151] Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: [83a59151] user: drh branch: trunk, size: 17887)
2005-12-06
12:52
[7ed4b794] part of check-in [e1606658] Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) (check-in: [e1606658] user: danielk1977 branch: trunk, size: 17870)
2005-10-20
07:28
[149e871e] part of check-in [e261b8b0] Changes to prevent various compiler warnings. (CVS 2750) (check-in: [e261b8b0] user: drh branch: trunk, size: 17851)
2005-08-19
19:14
[26d755f2] part of check-in [b550d04d] Increase test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603) (check-in: [b550d04d] user: drh branch: trunk, size: 17842)
2005-06-06
21:19
[03041f24] part of check-in [e73d25c7] Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) (check-in: [e73d25c7] user: drh branch: trunk, size: 17709)
2005-03-28
00:07
[9570af38] part of check-in [ccb9f402] Use SQL function substr() correctly from ALTER TABLE code. Ticket #1182. (CVS 2420) (check-in: [ccb9f402] user: danielk1977 branch: trunk, size: 17699)
2005-03-27
01:56
[f0b637b8] part of check-in [3c86e633] Correctly allocate new columns array in ALTER TABLE .. ADD COLUMN. Ticket #1183. (CVS 2419) (check-in: [3c86e633] user: danielk1977 branch: trunk, size: 17699)
2005-03-19
14:45
[8ee27ba2] part of check-in [90a00e90] Preparations for the release of version 3.2.0. (CVS 2400) (check-in: [90a00e90] user: drh branch: trunk, size: 17589)
2005-03-17
05:03
[85a23fc9] part of check-in [94185dd4] Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) (check-in: [94185dd4] user: danielk1977 branch: trunk, size: 17596)
2005-02-15
21:36
[6dab3d91] part of check-in [dbd11a0c] Move the special built-in SQL functions used by ALTER TABLE out of func.c and into alter.c. (CVS 2343) (check-in: [dbd11a0c] user: drh branch: trunk, size: 10740)
20:47
[4e38440d] part of check-in [90d6573c] Split the logic for the ALTER TABLE command off into a separate source code file. (CVS 2342) (check-in: [90d6573c] user: drh branch: trunk, size: 6021) Added