Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/alter.test
2023-11-18
| ||
11:23 | [3c00eff1e2] part of check-in [3afaeac56d] Another assertion fault fix, similar to [a9443dbfbe25e588]. dbsqlfuzz 2d9af4e94aca188e0092900eec711401c5d51687. (check-in: [3afaeac56d] user: drh branch: trunk, size: 27079) | |
2023-11-17
| ||
11:58 | [5d3c2a662c] part of check-in [a9443dbfbe] Fix an incorrect assert() associated with ALTER TABLE where an unknown aggregate function contains an ORDER BY clause. dbsqlfuzz e0900262dadd5c78c2226ad6a435c7f0255be2cd. (check-in: [a9443dbfbe] user: drh branch: trunk, size: 26719) | |
2023-10-14
| ||
20:24 | [403a7f8842] part of check-in [75b075863e] Do not allow an ALTER TABLE ADD COLUMN on a STRICT table if the added column contains a DEFAULT clause that would violate the type of the added column. (check-in: [75b075863e] user: drh branch: trunk, size: 26140) | |
2021-10-13
| ||
14:01 | [313073774a] part of check-in [9e2f06b84f] Remove a NEVER() macro in ALTER TABLE due to an obscure case of a nested CTE inside an UPDATE within a trigger. dbsqlfuzz e89174cbfad2d904f06b5e24df0a22510b6a1c1e (check-in: [9e2f06b84f] user: drh branch: trunk, size: 25557) | |
2021-03-08
| ||
17:17 | [f53d8a4ecd] part of check-in [f13e0d12f1] Fix a bad assert in RENAME COLUMN. dbsqlfuzz 3f0a7245b69cd08617d7d7781ebaedb0fe765a93. (check-in: [f13e0d12f1] user: drh branch: trunk, size: 24935) | |
2020-05-08
| ||
19:02 | [25e109787d] part of check-in [3a16c0ce4d] Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: [3a16c0ce4d] user: drh branch: trunk, size: 24500) | |
2020-01-01
| ||
15:43 | [77f0092d13] part of check-in [473892a8ec] 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: [473892a8ec] user: drh branch: trunk, size: 24467) | |
2019-08-08
| ||
15:24 | [16ed8d2470] part of check-in [1e17ea2fd1] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 24465) | |
2019-07-02
| ||
20:10 | [673c5e68f5] part of check-in [5dbb0734af] 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: [5dbb0734af] user: dan branch: tkt9b78184b-alt, size: 24530) | |
2018-11-26
| ||
18:09 | [93dee7c0ff] part of check-in [6e1330545e] 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: [6e1330545e] user: drh branch: trunk, size: 24528) | |
2018-09-16
| ||
23:27 | [99e72759d4] part of check-in [05a9d12925] First proposed fix for the ALTER TABLE problem described by ticket [b41031ea2b5372378cb3d2d] (check-in: [05a9d12925] user: drh branch: tkt-b41031ea, size: 24131) | |
2018-09-03
| ||
20:05 | [cf28c2f352] part of check-in [6805b5900d] Improve the error messages emitted by RENAME TABLE. (check-in: [6805b5900d] user: dan branch: alter-table-rename-column, size: 23537) | |
2018-09-01
| ||
20:23 | [905d899b2f] part of check-in [336b8a0923] Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. (check-in: [336b8a0923] user: dan branch: alter-table-rename-column, size: 23520) | |
2018-08-31
| ||
18:23 | [31b4e91288] part of check-in [eac2aa7dce] 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: [eac2aa7dce] user: dan branch: alter-table-rename-table, size: 23518) | |
2018-08-29
| ||
21:00 | [8388947daa] part of check-in [01308bae3a] Extend RENAME TABLE to edit triggers and views. Still buggy. (check-in: [01308bae3a] user: dan branch: alter-table-rename-table, size: 25262) | |
2016-12-16
| ||
01:00 | [b820ab9dcf] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 25251) | |
2015-04-28
| ||
14:07 | [2facdddf08] part of check-in [36e5152618] Fix an assert() failure that could occur if the internal sqlite3_rename_parent() SQL scalar function was invoked directly. (check-in: [36e5152618] user: dan branch: trunk, size: 25251) | |
2014-04-14
| ||
19:48 | [547dc2d292] part of check-in [c6fa8d0d82] Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] (check-in: [c6fa8d0d82] user: drh branch: trunk, size: 24876) | |
2013-10-23
| ||
01:57 | [b955ec265b] part of check-in [3f8016dee2] Some simple inserts and queries working on WITHOUT ROWID tables. (check-in: [3f8016dee2] user: drh branch: omit-rowid, size: 23457) | |
2013-10-21
| ||
02:14 | [e88dfa77e0] part of check-in [131cc6e152] Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. (check-in: [131cc6e152] user: drh branch: omit-rowid, size: 23448) | |
2013-10-19
| ||
23:31 | [f128974fba] part of check-in [0248ec5e6e] Experimental changes toward "index only" tables. Add the ability to specify options on CREATE TABLE statements using the WITH clause modeled after PostgreSQL and SQL Server. Only the "omit_rowid" option is currently recognized and that option is currently a no-op. (check-in: [0248ec5e6e] user: drh branch: omit-rowid, size: 23440) | |
2013-08-31
| ||
14:56 | [775a1dded3] part of check-in [d9fadc8fa6] Reenable a test accidentally disabled when the stat4 branch was merged. (check-in: [d9fadc8fa6] user: dan branch: trunk, size: 22832) | |
2013-08-03
| ||
20:24 | [7e771c3c3f] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 22769) | |
2012-02-01
| ||
01:13 | [57d96ec9b3] part of check-in [0d78ebb8e4] 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: [0d78ebb8e4] user: drh branch: trunk, size: 22769) | |
2011-10-21
| ||
19:06 | [66f5818f98] part of check-in [aed2bf7a3c] Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: [aed2bf7a3c] user: drh branch: trunk, size: 22712) | |
2011-08-26
| ||
13:52 | [328d2daaeb] part of check-in [0df04f920b] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f920b] user: drh branch: stat3-3.7.2, size: 22795) | |
2011-08-15
| ||
12:58 | [54912d9323] part of check-in [2504bcfb0c] Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. (check-in: [2504bcfb0c] user: drh branch: stat3-enhancement, size: 22775) | |
2011-08-02
| ||
00:57 | [5314fc01ef] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 22712) | |
2011-05-05
| ||
19:44 | [a3f570072b] part of check-in [1586244b6d] Changes to various test scripts so that they pass on windows. (check-in: [1586244b6d] user: dan branch: win32-test-fixes, size: 22740) | |
2011-04-01
| ||
15:15 | [4e47fb9ea5] part of check-in [d9707ef8dc] Ensure that it is not possible to add a column to a system table using ALTER TABLE. (check-in: [d9707ef8dc] user: dan branch: trunk, size: 22732) | |
2010-04-24
| ||
14:02 | [15f9224868] part of check-in [0291ed974d] 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: [0291ed974d] user: drh branch: trunk, size: 22120) | |
2009-03-24
| ||
15:08 | [645b2e8d23] part of check-in [ea74d8dc62] Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) (check-in: [ea74d8dc62] user: drh branch: trunk, size: 21589) | |
2009-02-13
| ||
03:43 | [958b36b7e9] part of check-in [dd179ff298] Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) (check-in: [dd179ff298] user: drh branch: trunk, size: 21589) | |
2008-05-09
| ||
14:17 | [6353aae683] part of check-in [ab18b4e759] 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: [ab18b4e759] user: drh branch: trunk, size: 21296) | |
2008-02-09
| ||
14:30 | [1426bb4c86] part of check-in [607247c27b] ALTER TABLE uses double-quotes for quoting table names. (CVS 4781) (check-in: [607247c27b] user: drh branch: trunk, size: 20565) | |
2007-12-13
| ||
08:15 | [345648dcd1] part of check-in [19d56d997f] Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831. (CVS 4623) (check-in: [19d56d997f] user: danielk1977 branch: trunk, size: 20565) | |
2007-10-23
| ||
15:39 | [a87b7933d4] part of check-in [7e30fd6a09] Floating point and 64-bit integer constants store in the virtual machine opcodes in binary, not as text. Performance improvement. Ticket #2733. (CVS 4507) (check-in: [7e30fd6a09] user: drh branch: trunk, size: 20022) | |
2007-10-09
| ||
08:29 | [908659f97a] part of check-in [07c00fffe5] Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) (check-in: [07c00fffe5] user: danielk1977 branch: trunk, size: 20027) | |
2007-05-15
| ||
16:51 | [c2a9402e17] part of check-in [f84d9dab11] Make sure pParse->rc gets set whenever sqlite3ErrorMsg() is called. This is added insurance that parsing will stop quickly after an error. This change did make the parser stop faster in some cases, which required some revisions to tests. (CVS 4010) (check-in: [f84d9dab11] user: drh branch: trunk, size: 19798) | |
14:34 | [fa99dbd9cb] part of check-in [262a3e6339] 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: [262a3e6339] user: drh branch: trunk, size: 19642) | |
09:00 | [e2b5ccf30f] part of check-in [252810424d] Do not allow bytes 0x80 through 0xBF to be the first character of an identifer because no valid UTF-8 character can begin with those bytes. If we allowed an identifier to begin with one of those bytes, then the substr() function in ALTER TABLE will not work correctly. (CVS 4003) (check-in: [252810424d] user: drh branch: trunk, size: 18742) | |
03:56 | [1513354e75] part of check-in [9ff382f458] Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) (check-in: [9ff382f458] user: drh branch: trunk, size: 18378) | |
00:09 | [0e69c016b5] part of check-in [d07cdd3c09] Make sure the parser aborts quickly following a syntax error. (CVS 3996) (check-in: [d07cdd3c09] user: drh branch: trunk, size: 17344) | |
2007-05-08
| ||
12:37 | [088d82f140] part of check-in [c2f90b465e] 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: [c2f90b465e] user: danielk1977 branch: trunk, size: 17225) | |
2007-04-06
| ||
02:32 | [6a95662539] part of check-in [a776d93cca] Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) (check-in: [a776d93cca] user: drh branch: trunk, size: 16731) | |
2007-02-24
| ||
11:52 | [a2cc30e844] part of check-in [e11bbf174c] Make sure that integer values are converted to real when pulled from a REAL table column by GROUP BY. Ticket #2251. Also make sure default values are correctly expanded. There may be other places in the code where this issue comes up - we need to look further. (CVS 3659) (check-in: [e11bbf174c] user: drh branch: trunk, size: 16660) | |
2006-02-09
| ||
02:56 | [29234396d7] part of check-in [baef2f66be] Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) (check-in: [baef2f66be] user: drh branch: trunk, size: 16177) | |
2006-01-17
| ||
09:35 | [d2569ed639] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 15843) | |
2006-01-15
| ||
14:11 | [1ac1263c84] part of check-in [69f996e0fa] Correctly set the length of the string in bytes when transforming an OP_String8 to OP_String in a utf-16 vdbe program. (CVS 2949) (check-in: [69f996e0fa] user: danielk1977 branch: trunk, size: 15847) | |
2006-01-14
| ||
08:02 | [2678f1ac6d] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 15654) | |
2006-01-13
| ||
18:06 | [55362362d4] part of check-in [d634f8b28a] Account for multi-byte characters in ALTER TABLE code. Fix for #1609. (CVS 2942) (check-in: [d634f8b28a] user: danielk1977 branch: trunk, size: 15790) | |
2006-01-03
| ||
00:33 | [b94b640063] part of check-in [70b228575e] The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) (check-in: [70b228575e] user: drh branch: trunk, size: 14180) | |
2005-03-29
| ||
03:10 | [9d6837a3d9] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 14154) | |
2005-02-14
| ||
06:38 | [3a20ce14c3] part of check-in [41d2214b83] Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: [41d2214b83] user: danielk1977 branch: trunk, size: 13629) | |
2005-01-27
| ||
00:30 | [b146ddd669] part of check-in [1d5ebb1146] Test that it is ok to execute ALTER TABLE immediately after opening a database connection. (CVS 2281) (check-in: [1d5ebb1146] user: danielk1977 branch: trunk, size: 13632) | |
2004-11-22
| ||
19:12 | [95c57a4f46] part of check-in [fc8c1393c8] Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) (check-in: [fc8c1393c8] user: drh branch: trunk, size: 13187) | |
13:35 | [2f0355d92b] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 13198) | |
2004-11-19
| ||
08:41 | [2b4478c490] part of check-in [f635b6aae6] Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) (check-in: [f635b6aae6] user: danielk1977 branch: trunk, size: 12656) | |
08:02 | [6337578f49] part of check-in [6e97186880] Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) (check-in: [6e97186880] user: danielk1977 branch: trunk, size: 12390) | |
05:14 | [627f1c24c8] part of check-in [1fd8e835a3] Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) (check-in: [1fd8e835a3] user: danielk1977 branch: trunk, size: 11813) | |
2004-11-18
| ||
15:44 | [45d3092260] part of check-in [c61b7de107] Handle triggers correctly in ALTER TABLE. (CVS 2111) (check-in: [c61b7de107] user: danielk1977 branch: trunk, size: 9180) | |
2004-11-12
| ||
15:53 | [ea6b104fa8] part of check-in [c4115aa3a1] Add authorization callbacks to ALTER TABLE. (CVS 2093) (check-in: [c4115aa3a1] user: danielk1977 branch: trunk, size: 6389) | |
13:42 | Added: [faf3440c41] part of check-in [a1b2cc63e6] Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) (check-in: [a1b2cc63e6] user: danielk1977 branch: trunk, size: 5261) | |