Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/table.test
2018-11-07
| ||
02:17 | Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. file: [eb3463b7] check-in: [3212733c] user: drh branch: read-only-shadow, size: 21964 | |
2015-12-12
| ||
17:31 | Add further tests for the changes on this branch. Also fix a memory-leak that could follow a malloc failure. file: [9ed9aed4] check-in: [21526012] user: dan branch: onepass-delete-or, size: 22265 | |
2015-12-09
| ||
16:08 | Fix a problem with the DROP TABLE command on this branch. file: [f85f8694] check-in: [c80bbf14] user: dan branch: onepass-delete-or, size: 22250 | |
2015-09-09
| ||
13:28 | When running a CREATE TABLE AS, make the initial temporary sqlite_master entry for the new table a real record rather than a NULL, in case the query after the AS actually tries to read the sqlite_master table. Fix for ticket [acd12990885d9276]. file: [b708f3e5] check-in: [4a18d8bd] user: drh branch: trunk, size: 21929 | |
2015-06-16
| ||
16:39 | Ensure that the CREATE TABLE AS statement correctly undoes partial changes to the sqlite_master table if the SELECT on the right-hand side aborts with an error. Fix for ticket [873cae2b6e25b] file: [33bf0d1f] check-in: [400e025e] user: drh branch: trunk, size: 21443 | |
2015-04-17
| ||
18:22 | Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. file: [bd841e8d] check-in: [3f3b0f68] user: drh branch: trunk, size: 20973 | |
2014-11-05
| ||
15:57 | Make sure that NULL results from OP_Column are fully and completely NULL and do not have the MEM_Ephem bit set. Fix for ticket [094d39a4c95ee4]. file: [06271d61] check-in: [42705fd7] user: drh branch: trunk, size: 20600 | |
2014-08-06
| ||
00:29 | A simpler fix for ticket [3a88d85f36704eebe1] - one that uses less code. The error message is not quite as good, but as this error has apparently not previously occurred in over 8 years of heavy use, that is not seen as a serious problem. file: [2a1d2fa5] check-in: [0ad1ed8e] user: drh branch: trunk, size: 20036 | |
2014-08-05
| ||
21:31 | Ensure that aggregate functions are not used when evaluating a default value for a table column. Candidate fix for ticket [3a88d85f36704eebe134f7]. file: [5b985827] check-in: [29ba8128] user: drh branch: trunk, size: 19981 | |
2013-11-05
| ||
13:33 | Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [580d2353] check-in: [54b22192] user: drh branch: omit-rowid, size: 18433 | |
2013-08-12
| ||
20:14 | If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. file: [30423211] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 18421 | |
2013-08-05
| ||
05:34 | Fix a couple of problems in code related to sqlite_stat4. file: [03135ef2] check-in: [badd24d9] user: dan branch: sqlite_stat4, size: 18382 | |
2011-10-07
| ||
23:52 | Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. file: [a59d985c] check-in: [589f3f56] user: drh branch: trunk, size: 18382 | |
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: [50c47f5f] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 18101 | |
2010-05-03
| ||
19:20 | Unset some global TCL variables prior to use in test where prior tests can have those same variables set to an array value. file: [04ba0664] check-in: [49bef00e] user: drh branch: trunk, size: 18115 | |
2009-06-05
| ||
17:09 | Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) file: [bf102a56] check-in: [1fef16ec] user: drh branch: trunk, size: 18079 | |
2009-05-11
| ||
20:53 | Rework the logic that generates a schema for tables created using "CREATE TABLE ... AS SELECT ...". Instead of trying to copy the raw datatype string from the right-hand side, just make the type one of TEXT, INT, REAL, NUM, or nothing. This is much simpler than trying to parse and quote datatype strings. Other minor implifications to build.c are bundled with this change. (CVS 6626) file: [00fe72ce] check-in: [33cf8359] user: drh branch: trunk, size: 18090 | |
2009-04-28
| ||
15:43 | Simplifications to the symbol table implementation in hash.c. For very small symbol tables (less than 10 entries) a simple linked list is used instead of a hash table. Number of hash table buckets is limited to prevent large allocations. (CVS 6559) file: [e47c9323] check-in: [5c737835] user: drh branch: trunk, size: 18198 | |
2009-03-14
| ||
08:37 | Fix for #3719. When synthesizing a CREATE TABLE statement as as result of a "CREATE TABLE AS", quote the column type names unless they are simple identifiers or simple identifiers followed by one or two dimensions (e.g. "VARCHAR(10)"). (CVS 6345) file: [bf1bc3d9] check-in: [7c6437ef] user: danielk1977 branch: trunk, size: 18220 | |
2009-01-16
| ||
11:04 | Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186) file: [0aac9468] check-in: [54ab8326] user: danielk1977 branch: trunk, size: 17516 | |
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: [13b1c2e2] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 17317 | |
2007-05-02
| ||
17:54 | Allow CREATE TABLE to occur while other queries are running. DROP TABLE is still prohibited, however, since we do not want to delete a table out from under an running query. (CVS 3902) file: [dbdfd06a] check-in: [5b4bf1fc] user: drh branch: trunk, size: 17234 | |
2006-09-01
| ||
15:49 | Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) file: [feea6a3e] check-in: [bedbac54] user: drh branch: trunk, size: 17150 | |
2006-03-29
| ||
00:24 | Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) file: [1c1539af] check-in: [4ba280dd] user: drh branch: trunk, size: 17202 | |
2006-01-04
| ||
21:40 | Bug fix in the IF NOT EXISTS logic. (CVS 2858) file: [6dc0dfa4] check-in: [cb9095ac] user: drh branch: trunk, size: 17103 | |
2005-12-29
| ||
23:33 | Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) file: [149b76a2] check-in: [0bd9e35f] user: drh branch: trunk, size: 16997 | |
01:11 | Add support for DROP TABLE IF EXISTS. (CVS 2843) file: [c3c0302f] check-in: [a4c547de] user: drh branch: trunk, size: 16916 | |
2005-09-10
| ||
15:35 | Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) file: [ec0e6c21] check-in: [f4342774] user: drh branch: trunk, size: 16903 | |
2005-08-13
| ||
00:56 | Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) file: [d0e05ede] check-in: [25cfe939] user: drh branch: trunk, size: 16777 | |
2005-03-29
| ||
03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [e87fb221] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 16809 | |
2005-01-24
| ||
10:25 | Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) file: [a2a58cae] check-in: [d5233e07] user: danielk1977 branch: trunk, size: 16774 | |
2005-01-22
| ||
03:39 | Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264) file: [fe2fa0d6] check-in: [764b55ad] user: danielk1977 branch: trunk, size: 16730 | |
2005-01-21
| ||
03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [a6b6b897] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 16741 | |
2004-11-23
| ||
22:16 | fulltest runs now, but still finds a memory leak. (CVS 2150) file: [b8b0bee2] check-in: [5944d51e] user: drh branch: trunk, size: 16607 | |
09:06 | Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) file: [9e0d4060] check-in: [557be3ff] user: danielk1977 branch: trunk, size: 16591 | |
2004-11-10
| ||
11:55 | Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) file: [87a6219c] check-in: [8e5c2e5d] user: danielk1977 branch: trunk, size: 16044 | |
2004-11-09
| ||
16:13 | Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) file: [0d7659fa] check-in: [f81b9c1c] user: danielk1977 branch: trunk, size: 14140 | |
12:44 | Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [54081854] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 14086 | |
2004-11-03
| ||
16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [109155b5] check-in: [b11fc9b3] user: drh branch: trunk, size: 13316 | |
2004-07-24
| ||
03:30 | Progress towards getting prepared statements and CREATE and DROP to play nicely together. Work is incomplete. Some tests are known to fail. (CVS 1864) file: [fd9a0f49] check-in: [49b99149] user: drh branch: trunk, size: 13230 | |
2004-06-21
| ||
07:36 | Update sqlite3_column_decltype() to return NULL as the declartion type for an expression that is not a column reference. (CVS 1646) file: [b6d07f04] check-in: [ee9dffd9] user: danielk1977 branch: trunk, size: 13242 | |
2004-06-19
| ||
00:16 | Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) file: [06c077c8] check-in: [d705d051] user: drh branch: trunk, size: 12622 | |
2004-06-12
| ||
09:25 | (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [bbae9f26] check-in: [5903f538] user: danielk1977 branch: trunk, size: 12623 | |
2004-06-07
| ||
10:00 | Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inherit column declaration types from the SELECT statement. (CVS 1538) file: [1defd90e] check-in: [31c1668d] user: danielk1977 branch: trunk, size: 12587 | |
2004-05-24
| ||
12:55 | Update the typeof() operator to respect manifest types. (CVS 1450) file: [71f80881] check-in: [162cf42e] user: danielk1977 branch: trunk, size: 12516 | |
2004-05-19
| ||
21:09 | Get more tests running. (CVS 1409) file: [50e45345] check-in: [7eb3f29e] user: drh branch: trunk, size: 12444 | |
2003-01-29
| ||
18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [371a1fc1] check-in: [ccc82f1a] user: drh branch: trunk, size: 12441 | |
2003-01-04
| ||
16:48 | Optimizations to the BTree module for a modest speed improvement. (CVS 810) file: [2a94f55b] check-in: [39902a70] user: drh branch: trunk, size: 12438 | |
2002-08-31
| ||
18:53 | Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) file: [10508e5e] check-in: [170711ca] user: drh branch: trunk, size: 12416 | |
2002-08-13
| ||
23:02 | Make the distinction between text and numeric data. (CVS 710) file: [dedb4d3a] check-in: [310ac4fb] user: drh branch: trunk, size: 11358 | |
2002-07-05
| ||
21:42 | All the code is now in place for SQLite to distinguish between NUMERIC and TEXT datatypes. Still need to turn on the new code and test it. (CVS 659) file: [bc571115] check-in: [b4737a16] user: drh branch: trunk, size: 11284 | |
2002-06-02
| ||
18:19 | Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored, but at least they now do not cause a syntax error. (CVS 603) file: [42511f98] check-in: [6fdcee3c] user: drh branch: trunk, size: 10656 | |
2002-05-22
| ||
21:27 | Fix for ticket #46: Report an error if a CREATE TABLE contains two or more columns with the same name. (CVS 578) file: [d9fd161d] check-in: [ba1953ab] user: drh branch: trunk, size: 9402 | |
2002-02-21
| ||
12:01 | Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) file: [17b0b6ea] check-in: [b2a9807f] user: drh branch: trunk, size: 9234 | |
2002-02-18
| ||
18:30 | Add support for CREATE TABLE AS. (CVS 377) file: [b8be4d3d] check-in: [78a50971] user: drh branch: trunk, size: 8796 | |
2001-09-27
| ||
15:11 | Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) file: [3ef4254d] check-in: [116fdad0] user: drh branch: trunk, size: 7765 | |
2001-09-16
| ||
00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [52fdca16] check-in: [4e926efe] user: drh branch: trunk, size: 7764 | |
2001-09-14
| ||
03:24 | All tests now pass. But there are still issues. For example, inserts are way too slow. And additional tests are needed for new features. (CVS 243) file: [a882150e] check-in: [e7b65e37] user: drh branch: trunk, size: 8307 | |
2001-09-13
| ||
21:53 | Many problems fixed. Many problems yet to go. (CVS 242) file: [4d3a978e] check-in: [62c7bd11] user: drh branch: trunk, size: 8301 | |
2001-04-12
| ||
23:21 | More testing (CVS 209) file: [3e0d74ec] check-in: [3bde1284] user: drh branch: trunk, size: 8680 | |
2001-04-04
| ||
11:48 | Added transaction support (CVS 196) file: [c1704fea] check-in: [35a8feed] user: drh branch: trunk, size: 8604 | |
2000-10-19
| ||
14:10 | Added the "memory:" driver (CVS 158) file: [eaa25951] check-in: [54d60c68] user: drh branch: trunk, size: 8091 | |
2000-08-02
| ||
13:47 | file format change (CVS 122) file: [620cd72a] check-in: [b7b90237] user: drh branch: trunk, size: 7936 | |
2000-06-08
| ||
15:10 | :-) (CVS 81) file: [d3e01e49] check-in: [61c381e7] user: drh branch: trunk, size: 7556 | |
2000-05-30
| ||
16:27 | :-) (CVS 15) file: [85d6f410] check-in: [8d66c735] user: drh branch: trunk, size: 7301 | |
13:44 | :-) (CVS 14) file: [2d6b3ba1] check-in: [1bb8ee8d] user: drh branch: trunk, size: 6787 | |
03:12 | :-) (CVS 12) file: [b1afc2f6] check-in: [20f2811f] user: drh branch: trunk, size: 6774 | |
2000-05-29
| ||
23:58 | :-) (CVS 9) file: [7eea7cd2] check-in: [84333008] user: drh branch: trunk, size: 6794 Added | |