Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/table.test
2025-04-10
| ||
10:18 | [e87294bf1c] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 21946) | |
2023-10-20
| ||
20:19 | [7862a00b58] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 21958) | |
2018-11-07
| ||
02:17 | [eb3463b7ad] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 21964) | |
2015-12-12
| ||
17:31 | [9ed9aed4a8] part of check-in [21526012c2] Add further tests for the changes on this branch. Also fix a memory-leak that could follow a malloc failure. (check-in: [21526012c2] user: dan branch: onepass-delete-or, size: 22265) | |
2015-12-09
| ||
16:08 | [f85f8694f9] part of check-in [c80bbf14b3] Fix a problem with the DROP TABLE command on this branch. (check-in: [c80bbf14b3] user: dan branch: onepass-delete-or, size: 22250) | |
2015-09-09
| ||
13:28 | [b708f3e5fa] part of check-in [4a18d8bd4c] 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]. (check-in: [4a18d8bd4c] user: drh branch: trunk, size: 21929) | |
2015-06-16
| ||
16:39 | [33bf0d1fd0] part of check-in [400e025e7c] 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] (check-in: [400e025e7c] user: drh branch: trunk, size: 21443) | |
2015-04-17
| ||
18:22 | [bd841e8df6] part of check-in [3f3b0f683a] Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. (check-in: [3f3b0f683a] user: drh branch: trunk, size: 20973) | |
2014-11-05
| ||
15:57 | [06271d61eb] part of check-in [42705fd7d8] 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]. (check-in: [42705fd7d8] user: drh branch: trunk, size: 20600) | |
2014-08-06
| ||
00:29 | [2a1d2fa52c] part of check-in [0ad1ed8ef0] 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. (check-in: [0ad1ed8ef0] user: drh branch: trunk, size: 20036) | |
2014-08-05
| ||
21:31 | [5b98582797] part of check-in [29ba812825] Ensure that aggregate functions are not used when evaluating a default value for a table column. Candidate fix for ticket [3a88d85f36704eebe134f7]. (check-in: [29ba812825] user: drh branch: trunk, size: 19981) | |
2013-11-05
| ||
13:33 | [580d235301] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 18433) | |
2013-08-12
| ||
20:14 | [3042321110] part of check-in [cca8bf4372] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf4372] user: dan branch: sqlite_stat4, size: 18421) | |
2013-08-05
| ||
05:34 | [03135ef2fd] part of check-in [badd24d987] Fix a couple of problems in code related to sqlite_stat4. (check-in: [badd24d987] user: dan branch: sqlite_stat4, size: 18382) | |
2011-10-07
| ||
23:52 | [a59d985ca3] part of check-in [589f3f5652] 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. (check-in: [589f3f5652] user: drh branch: trunk, size: 18382) | |
2011-08-02
| ||
00:57 | [50c47f5fe9] 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: 18101) | |
2010-05-03
| ||
19:20 | [04ba066432] part of check-in [49bef00e5c] Unset some global TCL variables prior to use in test where prior tests can have those same variables set to an array value. (check-in: [49bef00e5c] user: drh branch: trunk, size: 18115) | |
2009-06-05
| ||
17:09 | [bf102a5669] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 18079) | |
2009-05-11
| ||
20:53 | [00fe72cef1] part of check-in [33cf83591e] 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) (check-in: [33cf83591e] user: drh branch: trunk, size: 18090) | |
2009-04-28
| ||
15:43 | [e47c932339] part of check-in [5c737835de] 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) (check-in: [5c737835de] user: drh branch: trunk, size: 18198) | |
2009-03-14
| ||
08:37 | [bf1bc3d963] part of check-in [7c6437efe0] 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) (check-in: [7c6437efe0] user: danielk1977 branch: trunk, size: 18220) | |
2009-01-16
| ||
11:04 | [0aac9468b6] part of check-in [54ab8326a1] 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) (check-in: [54ab8326a1] user: danielk1977 branch: trunk, size: 17516) | |
2007-10-09
| ||
08:29 | [13b1c2e2fb] 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: 17317) | |
2007-05-02
| ||
17:54 | [dbdfd06aef] part of check-in [5b4bf1fce4] 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) (check-in: [5b4bf1fce4] user: drh branch: trunk, size: 17234) | |
2006-09-01
| ||
15:49 | [feea6a3eb0] part of check-in [bedbac54db] Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) (check-in: [bedbac54db] user: drh branch: trunk, size: 17150) | |
2006-03-29
| ||
00:24 | [1c1539af8d] part of check-in [4ba280ddd6] Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) (check-in: [4ba280ddd6] user: drh branch: trunk, size: 17202) | |
2006-01-04
| ||
21:40 | [6dc0dfa44d] part of check-in [cb9095ac52] Bug fix in the IF NOT EXISTS logic. (CVS 2858) (check-in: [cb9095ac52] user: drh branch: trunk, size: 17103) | |
2005-12-29
| ||
23:33 | [149b76a28b] part of check-in [0bd9e35fd2] Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) (check-in: [0bd9e35fd2] user: drh branch: trunk, size: 16997) | |
01:11 | [c3c0302f04] part of check-in [a4c547de83] Add support for DROP TABLE IF EXISTS. (CVS 2843) (check-in: [a4c547de83] user: drh branch: trunk, size: 16916) | |
2005-09-10
| ||
15:35 | [ec0e6c2186] part of check-in [f43427742b] Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) (check-in: [f43427742b] user: drh branch: trunk, size: 16903) | |
2005-08-13
| ||
00:56 | [d0e05ede3f] part of check-in [25cfe9390d] 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) (check-in: [25cfe9390d] user: drh branch: trunk, size: 16777) | |
2005-03-29
| ||
03:10 | [e87fb2211b] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 16809) | |
2005-01-24
| ||
10:25 | [a2a58cae70] part of check-in [d5233e0747] Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: [d5233e0747] user: danielk1977 branch: trunk, size: 16774) | |
2005-01-22
| ||
03:39 | [fe2fa0d684] part of check-in [764b55adb5] Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264) (check-in: [764b55adb5] user: danielk1977 branch: trunk, size: 16730) | |
2005-01-21
| ||
03:12 | [a6b6b89773] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 16741) | |
2004-11-23
| ||
22:16 | [b8b0bee2ac] part of check-in [5944d51e6c] fulltest runs now, but still finds a memory leak. (CVS 2150) (check-in: [5944d51e6c] user: drh branch: trunk, size: 16607) | |
09:06 | [9e0d406073] part of check-in [557be3ff5b] Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) (check-in: [557be3ff5b] user: danielk1977 branch: trunk, size: 16591) | |
2004-11-10
| ||
11:55 | [87a6219c78] part of check-in [8e5c2e5df8] Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) (check-in: [8e5c2e5df8] user: danielk1977 branch: trunk, size: 16044) | |
2004-11-09
| ||
16:13 | [0d7659fa9f] part of check-in [f81b9c1c02] Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) (check-in: [f81b9c1c02] user: danielk1977 branch: trunk, size: 14140) | |
12:44 | [5408185474] part of check-in [0d27c8ff48] Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: [0d27c8ff48] user: danielk1977 branch: trunk, size: 14086) | |
2004-11-03
| ||
16:27 | [109155b5a9] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 13316) | |
2004-07-24
| ||
03:30 | [fd9a0f4992] part of check-in [49b9914924] Progress towards getting prepared statements and CREATE and DROP to play nicely together. Work is incomplete. Some tests are known to fail. (CVS 1864) (check-in: [49b9914924] user: drh branch: trunk, size: 13230) | |
2004-06-21
| ||
07:36 | [b6d07f04c4] part of check-in [ee9dffd986] Update sqlite3_column_decltype() to return NULL as the declartion type for an expression that is not a column reference. (CVS 1646) (check-in: [ee9dffd986] user: danielk1977 branch: trunk, size: 13242) | |
2004-06-19
| ||
00:16 | [06c077c82d] part of check-in [d705d051be] 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) (check-in: [d705d051be] user: drh branch: trunk, size: 12622) | |
2004-06-12
| ||
09:25 | [bbae9f267e] part of check-in [5903f53828] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f53828] user: danielk1977 branch: trunk, size: 12623) | |
2004-06-07
| ||
10:00 | [1defd90e82] part of check-in [31c1668dbc] Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inherit column declaration types from the SELECT statement. (CVS 1538) (check-in: [31c1668dbc] user: danielk1977 branch: trunk, size: 12587) | |
2004-05-24
| ||
12:55 | [71f808817b] part of check-in [162cf42e33] Update the typeof() operator to respect manifest types. (CVS 1450) (check-in: [162cf42e33] user: danielk1977 branch: trunk, size: 12516) | |
2004-05-19
| ||
21:09 | [50e4534552] part of check-in [7eb3f29e30] Get more tests running. (CVS 1409) (check-in: [7eb3f29e30] user: drh branch: trunk, size: 12444) | |
2003-01-29
| ||
18:46 | [371a1fc1c4] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 12441) | |
2003-01-04
| ||
16:48 | [2a94f55b39] part of check-in [39902a7041] Optimizations to the BTree module for a modest speed improvement. (CVS 810) (check-in: [39902a7041] user: drh branch: trunk, size: 12438) | |
2002-08-31
| ||
18:53 | [10508e5e53] part of check-in [170711ca65] Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) (check-in: [170711ca65] user: drh branch: trunk, size: 12416) | |
2002-08-13
| ||
23:02 | [dedb4d3a73] part of check-in [310ac4fbaf] Make the distinction between text and numeric data. (CVS 710) (check-in: [310ac4fbaf] user: drh branch: trunk, size: 11358) | |
2002-07-05
| ||
21:42 | [bc571115de] part of check-in [b4737a16c9] 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) (check-in: [b4737a16c9] user: drh branch: trunk, size: 11284) | |
2002-06-02
| ||
18:19 | [42511f98a3] part of check-in [6fdcee3c99] 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) (check-in: [6fdcee3c99] user: drh branch: trunk, size: 10656) | |
2002-05-22
| ||
21:27 | [d9fd161dc9] part of check-in [ba1953abd0] Fix for ticket #46: Report an error if a CREATE TABLE contains two or more columns with the same name. (CVS 578) (check-in: [ba1953abd0] user: drh branch: trunk, size: 9402) | |
2002-02-21
| ||
12:01 | [17b0b6eafa] part of check-in [b2a9807fed] Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) (check-in: [b2a9807fed] user: drh branch: trunk, size: 9234) | |
2002-02-18
| ||
18:30 | [b8be4d3d3f] part of check-in [78a50971e9] Add support for CREATE TABLE AS. (CVS 377) (check-in: [78a50971e9] user: drh branch: trunk, size: 8796) | |
2001-09-27
| ||
15:11 | [3ef4254d62] part of check-in [116fdad068] Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) (check-in: [116fdad068] user: drh branch: trunk, size: 7765) | |
2001-09-16
| ||
00:13 | [52fdca1632] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 7764) | |
2001-09-14
| ||
03:24 | [a882150e82] part of check-in [e7b65e37fd] 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) (check-in: [e7b65e37fd] user: drh branch: trunk, size: 8307) | |
2001-09-13
| ||
21:53 | [4d3a978ea7] part of check-in [62c7bd11bc] Many problems fixed. Many problems yet to go. (CVS 242) (check-in: [62c7bd11bc] user: drh branch: trunk, size: 8301) | |
2001-04-12
| ||
23:21 | [3e0d74ec03] part of check-in [3bde128418] More testing (CVS 209) (check-in: [3bde128418] user: drh branch: trunk, size: 8680) | |
2001-04-04
| ||
11:48 | [c1704fead1] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 8604) | |
2000-10-19
| ||
14:10 | [eaa25951c0] part of check-in [54d60c68dc] Added the "memory:" driver (CVS 158) (check-in: [54d60c68dc] user: drh branch: trunk, size: 8091) | |
2000-08-02
| ||
13:47 | [620cd72a6c] part of check-in [b7b9023794] file format change (CVS 122) (check-in: [b7b9023794] user: drh branch: trunk, size: 7936) | |
2000-06-08
| ||
15:10 | [d3e01e4916] part of check-in [61c381e7e6] :-) (CVS 81) (check-in: [61c381e7e6] user: drh branch: trunk, size: 7556) | |
2000-05-30
| ||
16:27 | [85d6f410d1] part of check-in [8d66c7355d] :-) (CVS 15) (check-in: [8d66c7355d] user: drh branch: trunk, size: 7301) | |
13:44 | [2d6b3ba102] part of check-in [1bb8ee8d9f] :-) (CVS 14) (check-in: [1bb8ee8d9f] user: drh branch: trunk, size: 6787) | |
03:12 | [b1afc2f6d4] part of check-in [20f2811fc1] :-) (CVS 12) (check-in: [20f2811fc1] user: drh branch: trunk, size: 6774) | |
2000-05-29
| ||
23:58 | Added: [7eea7cd2a0] part of check-in [84333008b7] :-) (CVS 9) (check-in: [84333008b7] user: drh branch: trunk, size: 6794) | |