/ File History
Login

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

History of test/alter.test

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