Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/alter.test
|
2019-08-08
| ||
| 15:24 | 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. file: [16ed8d24] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 24465 | |
|
2019-07-02
| ||
| 20:10 | 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. file: [673c5e68] check-in: [5dbb0734] user: dan branch: tkt9b78184b-alt, size: 24530 | |
|
2018-11-26
| ||
| 18:09 | 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. file: [93dee7c0] check-in: [6e133054] user: drh branch: trunk, size: 24528 | |
|
2018-09-16
| ||
| 23:27 | First proposed fix for the ALTER TABLE problem described by ticket [b41031ea2b5372378cb3d2d] file: [99e72759] check-in: [05a9d129] user: drh branch: tkt-b41031ea, size: 24131 | |
|
2018-09-03
| ||
| 20:05 | Improve the error messages emitted by RENAME TABLE. file: [cf28c2f3] check-in: [6805b590] user: dan branch: alter-table-rename-column, size: 23537 | |
|
2018-09-01
| ||
| 20:23 | Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. file: [905d899b] check-in: [336b8a09] user: dan branch: alter-table-rename-column, size: 23520 | |
|
2018-08-31
| ||
| 18:23 | 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. file: [31b4e912] check-in: [eac2aa7d] user: dan branch: alter-table-rename-table, size: 23518 | |
|
2018-08-29
| ||
| 21:00 | Extend RENAME TABLE to edit triggers and views. Still buggy. file: [8388947d] check-in: [01308bae] user: dan branch: alter-table-rename-table, size: 25262 | |
|
2016-12-16
| ||
| 01:00 | All temp.sqlite_master to be used as an alias for sqlite_temp_master. file: [b820ab9d] check-in: [8d646905] user: drh branch: trunk, size: 25251 | |
|
2015-04-28
| ||
| 14:07 | Fix an assert() failure that could occur if the internal sqlite3_rename_parent() SQL scalar function was invoked directly. file: [2facdddf] check-in: [36e51526] user: dan branch: trunk, size: 25251 | |
|
2014-04-14
| ||
| 19:48 | Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] file: [547dc2d2] check-in: [c6fa8d0d] user: drh branch: trunk, size: 24876 | |
|
2013-10-23
| ||
| 01:57 | Some simple inserts and queries working on WITHOUT ROWID tables. file: [b955ec26] check-in: [3f8016de] user: drh branch: omit-rowid, size: 23457 | |
|
2013-10-21
| ||
| 02:14 | Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. file: [e88dfa77] check-in: [131cc6e1] user: drh branch: omit-rowid, size: 23448 | |
|
2013-10-19
| ||
| 23:31 | 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. file: [f128974f] check-in: [0248ec5e] user: drh branch: omit-rowid, size: 23440 | |
|
2013-08-31
| ||
| 14:56 | Reenable a test accidentally disabled when the stat4 branch was merged. file: [775a1dde] check-in: [d9fadc8f] user: dan branch: trunk, size: 22832 | |
|
2013-08-03
| ||
| 20:24 | Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [7e771c3c] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 22769 | |
|
2012-02-01
| ||
| 01:13 | Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. file: [57d96ec9] check-in: [0d78ebb8] user: drh branch: trunk, size: 22769 | |
|
2011-10-21
| ||
| 19:06 | Purge lingering references to SQLITE_STAT2 from the code and test scripts. file: [66f5818f] check-in: [aed2bf7a] user: drh branch: trunk, size: 22712 | |
|
2011-08-26
| ||
| 13:52 | Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. file: [328d2daa] check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 22795 | |
|
2011-08-15
| ||
| 12:58 | Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. file: [54912d93] check-in: [2504bcfb] user: drh branch: stat3-enhancement, size: 22775 | |
|
2011-08-02
| ||
| 00:57 | 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. file: [5314fc01] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 22712 | |
|
2011-05-05
| ||
| 19:44 | Changes to various test scripts so that they pass on windows. file: [a3f57007] check-in: [1586244b] user: dan branch: win32-test-fixes, size: 22740 | |
|
2011-04-01
| ||
| 15:15 | Ensure that it is not possible to add a column to a system table using ALTER TABLE. file: [4e47fb9e] check-in: [d9707ef8] user: dan branch: trunk, size: 22732 | |
|
2010-04-24
| ||
| 14:02 | 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. file: [15f92248] check-in: [0291ed97] user: drh branch: trunk, size: 22120 | |
|
2009-03-24
| ||
| 15:08 | Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) file: [645b2e8d] check-in: [ea74d8dc] user: drh branch: trunk, size: 21589 | |
|
2009-02-13
| ||
| 03:43 | Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) file: [958b36b7] check-in: [dd179ff2] user: drh branch: trunk, size: 21589 | |
|
2008-05-09
| ||
| 14:17 | Fix the ALTER TABLE RENAME algorithm so that it is not confused by comments in the CREATE TABLE statement. Ticket #3102. (CVS 5110) file: [6353aae6] check-in: [ab18b4e7] user: drh branch: trunk, size: 21296 | |
|
2008-02-09
| ||
| 14:30 | ALTER TABLE uses double-quotes for quoting table names. (CVS 4781) file: [1426bb4c] check-in: [607247c2] user: drh branch: trunk, size: 20565 | |
|
2007-12-13
| ||
| 08:15 | Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831. (CVS 4623) file: [345648dc] check-in: [19d56d99] user: danielk1977 branch: trunk, size: 20565 | |
|
2007-10-23
| ||
| 15:39 | Floating point and 64-bit integer constants store in the virtual machine opcodes in binary, not as text. Performance improvement. Ticket #2733. (CVS 4507) file: [a87b7933] check-in: [7e30fd6a] user: drh branch: trunk, size: 20022 | |
|
2007-10-09
| ||
| 08:29 | Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) file: [908659f9] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 20027 | |
|
2007-05-15
| ||
| 16:51 | 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) file: [c2a9402e] check-in: [f84d9dab] user: drh branch: trunk, size: 19798 | |
| 14:34 | 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) file: [fa99dbd9] check-in: [262a3e63] user: drh branch: trunk, size: 19642 | |
| 09:00 | 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) file: [e2b5ccf3] check-in: [25281042] user: drh branch: trunk, size: 18742 | |
| 03:56 | Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) file: [1513354e] check-in: [9ff382f4] user: drh branch: trunk, size: 18378 | |
| 00:09 | Make sure the parser aborts quickly following a syntax error. (CVS 3996) file: [0e69c016] check-in: [d07cdd3c] user: drh branch: trunk, size: 17344 | |
|
2007-05-08
| ||
| 12:37 | Do not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger() if they are somehow passed unexpected input. (CVS 3944) file: [088d82f1] check-in: [c2f90b46] user: danielk1977 branch: trunk, size: 17225 | |
|
2007-04-06
| ||
| 02:32 | Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) file: [6a956625] check-in: [a776d93c] user: drh branch: trunk, size: 16731 | |
|
2007-02-24
| ||
| 11:52 | 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) file: [a2cc30e8] check-in: [e11bbf17] user: drh branch: trunk, size: 16660 | |
|
2006-02-09
| ||
| 02:56 | Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) file: [29234396] check-in: [baef2f66] user: drh branch: trunk, size: 16177 | |
|
2006-01-17
| ||
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [d2569ed6] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 15843 | |
|
2006-01-15
| ||
| 14:11 | 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) file: [1ac1263c] check-in: [69f996e0] user: danielk1977 branch: trunk, size: 15847 | |
|
2006-01-14
| ||
| 08:02 | Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [2678f1ac] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 15654 | |
|
2006-01-13
| ||
| 18:06 | Account for multi-byte characters in ALTER TABLE code. Fix for #1609. (CVS 2942) file: [55362362] check-in: [d634f8b2] user: danielk1977 branch: trunk, size: 15790 | |
|
2006-01-03
| ||
| 00:33 | 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) file: [b94b6400] check-in: [70b22857] user: drh branch: trunk, size: 14180 | |
|
2005-03-29
| ||
| 03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [9d6837a3] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 14154 | |
|
2005-02-14
| ||
| 06:38 | Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) file: [3a20ce14] check-in: [41d2214b] user: danielk1977 branch: trunk, size: 13629 | |
|
2005-01-27
| ||
| 00:30 | Test that it is ok to execute ALTER TABLE immediately after opening a database connection. (CVS 2281) file: [b146ddd6] check-in: [1d5ebb11] user: danielk1977 branch: trunk, size: 13632 | |
|
2004-11-22
| ||
| 19:12 | 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) file: [95c57a4f] check-in: [fc8c1393] user: drh branch: trunk, size: 13187 | |
| 13:35 | Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [2f0355d9] check-in: [007be591] user: danielk1977 branch: trunk, size: 13198 | |
|
2004-11-19
| ||
| 08:41 | Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) file: [2b4478c4] check-in: [f635b6aa] user: danielk1977 branch: trunk, size: 12656 | |
| 08:02 | Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) file: [6337578f] check-in: [6e971868] user: danielk1977 branch: trunk, size: 12390 | |
| 05:14 | Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) file: [627f1c24] check-in: [1fd8e835] user: danielk1977 branch: trunk, size: 11813 | |
|
2004-11-18
| ||
| 15:44 | Handle triggers correctly in ALTER TABLE. (CVS 2111) file: [45d30922] check-in: [c61b7de1] user: danielk1977 branch: trunk, size: 9180 | |
|
2004-11-12
| ||
| 15:53 | Add authorization callbacks to ALTER TABLE. (CVS 2093) file: [ea6b104f] check-in: [c4115aa3] user: danielk1977 branch: trunk, size: 6389 | |
| 13:42 | Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) file: [faf3440c] check-in: [a1b2cc63] user: danielk1977 branch: trunk, size: 5261 Added | |