/ File History
Login

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