aboutsummaryrefslogtreecommitdiff
path: root/test/table.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibilitydrh2023-10-20
| | | | | with SQLServer and PG. FossilOrigin-Name: b91c19bf2680f60d7826ab5d9e7902e2dc2a55d847bbea565a6489d47f2cc8f1
* Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test casesdrh2018-11-07
| | | | | so that they work with DEFENSIVE enabled. FossilOrigin-Name: 3212733cb6d1a59516d67a86df7c7b1d2456a1b2e5d7080c26b0e87b2609c65d
* When running a CREATE TABLE AS, make the initial temporary sqlite_master entry drh2015-09-09
| | | | | | | 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]. FossilOrigin-Name: 4a18d8bd4cc66eb08c6198cdf6e14f1bce0ec05a
* Ensure that the CREATE TABLE AS statement correctly undoes partial changesdrh2015-06-16
| | | | | | to the sqlite_master table if the SELECT on the right-hand side aborts with an error. Fix for ticket [873cae2b6e25b] FossilOrigin-Name: 400e025e7c61efab71b891743c07a0862e5bb934
* Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg()drh2015-04-17
| | | | | take care of doing that. FossilOrigin-Name: 3f3b0f683af2fbee83811536f6bef770ff919385
* Make sure that NULL results from OP_Column are fully and completely NULLdrh2014-11-05
| | | | | and do not have the MEM_Ephem bit set. Fix for ticket [094d39a4c95ee4]. FossilOrigin-Name: 42705fd7d892c4fdfb95fbbb468c99569beece25
* A simpler fix for ticket [3a88d85f36704eebe1] - one that uses less code.drh2014-08-06
| | | | | | | 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. FossilOrigin-Name: 0ad1ed8ef0b5fb5d8db44479373b2b93d8fcfd66
* Ensure that aggregate functions are not used when evaluating a defaultdrh2014-08-05
| | | | | | value for a table column. Candidate fix for ticket [3a88d85f36704eebe134f7]. FossilOrigin-Name: 29ba812825bf06ef230f2480bba0579653f0a52d
* Standardize the error messages generated by constraint failures to a formatdrh2013-11-05
| | | | | | of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41
* If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and ↵dan2013-08-12
| | | | | populate the sqlite_stat3 table instead of sqlite_stat4. FossilOrigin-Name: cca8bf4372ab7a0258aa5c9397818415c6cf0abf
* Fix a couple of problems in code related to sqlite_stat4.dan2013-08-05
| | | FossilOrigin-Name: badd24d987240db5528b37d1c177431617079f9b
* Change the ANALYZE command so that it no longer tried to delete unuseddrh2011-10-07
| | | | | | sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. FossilOrigin-Name: 589f3f5652e3674d3203f8bd32784a46b5ed530c
* Add retry logic for AV defense to winOpen. Also, refactor test suite to ↵mistachkin2011-08-02
| | | | | allow the key Tcl file operations (e.g. copy and delete) to be retried. FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c
* Unset some global TCL variables prior to use in test where prior tests candrh2010-05-03
| | | | | have those same variables set to an array value. FossilOrigin-Name: 49bef00e5cda600ceb964148bf745de4aff1ab62
* Remove leftover "breakpoint" commands from test scripts. Also remove blankdrh2009-06-05
| | | | | lines at the end of scripts. (CVS 6721) FossilOrigin-Name: 1fef16ec2b89981770cf44f606a420fbe031a7a4
* Rework the logic that generates a schema for tables created using drh2009-05-11
| | | | | | | | | "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) FossilOrigin-Name: 33cf83591e6e13875ef6ada5b8ac8ab07619d8bc
* Simplifications to the symbol table implementation in hash.c. For very smalldrh2009-04-28
| | | | | | | 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) FossilOrigin-Name: 5c737835dec9e6038b304c198aa14337a6f23c1c
* Fix for #3719. When synthesizing a CREATE TABLE statement as as result of a ↵danielk19772009-03-14
| | | | | "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) FossilOrigin-Name: 7c6437efe0a0e935cfa8041bd6b94070c8654fa4
* Allow recently added keywords 'savepoint' and 'release' to be used as ↵danielk19772009-01-16
| | | | | database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186) FossilOrigin-Name: 54ab8326a1ea574b183f84c8465315e989a23ca4
* Fixes to the test suite (no code changes) so that quick.test runs with ↵danielk19772007-10-09
| | | | | OMIT_ATTACH builds. #2706. (CVS 4480) FossilOrigin-Name: 07c00fffe50e8380748f7ae02328531a75d64610
* Allow CREATE TABLE to occur while other queries are running. DROP TABLE isdrh2007-05-02
| | | | | | still prohibited, however, since we do not want to delete a table out from under an running query. (CVS 3902) FossilOrigin-Name: 5b4bf1fce4d589337cfb1b46d75c751bbdc607d5
* Remove use of the "clock" command in the test suite so that the testsdrh2006-09-01
| | | | | will run in Tcl8.5. Ticket #1445. (CVS 3380) FossilOrigin-Name: bedbac54db173ceb74bd78acd021209f28aa30a8
* Properly record the names of triggers even if the name is quoted.drh2006-03-29
| | | | | Ticket #1737. (CVS 3158) FossilOrigin-Name: 4ba280ddd66d5cbf617263d6300b7582f65d47a9
* Bug fix in the IF NOT EXISTS logic. (CVS 2858)drh2006-01-04
| | | FossilOrigin-Name: cb9095ac52e76926f274678ef55ebb9df4b9fcac
* Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847)drh2005-12-29
| | | FossilOrigin-Name: 0bd9e35fd22946640f4fb1c1874922ae096916f7
* Add support for DROP TABLE IF EXISTS. (CVS 2843)drh2005-12-29
| | | FossilOrigin-Name: a4c547de83d8b27f06a58f9e530a7c983ec1dc3a
* Avoid a memory leak and/or assertion failure when parsing a table drh2005-09-10
| | | | | | declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) FossilOrigin-Name: f43427742b1c086f2621c900f4ede1a34a8b44ee
* Fix a memory leak that occurs when a CREATE TABLE that contains adrh2005-08-13
| | | | | DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) FossilOrigin-Name: 25cfe9390dda79bb2a7740b3d7380f517a4e8d1b
* Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)danielk19772005-03-29
| | | FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
* Modifications and bugfixes so that the test suite passes with the TCL ↵danielk19772005-01-24
| | | | | statement cache turned on. (CVS 2271) FossilOrigin-Name: d5233e0747789dea04d35a8350b408321d23a64d
* Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL ↵danielk19772005-01-22
| | | | | "file copy" command on windows. (CVS 2264) FossilOrigin-Name: 764b55adb5dff944db36d0d19ce5e7cc758b3a9e
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2251) FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
* fulltest runs now, but still finds a memory leak. (CVS 2150)drh2004-11-23
| | | FossilOrigin-Name: 5944d51e6c164270301b57e4351add4cb6137be6
* Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143)danielk19772004-11-23
| | | FossilOrigin-Name: 557be3ff5b1c46a3f3836ea3a9d9dede5dc46998
* Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085)danielk19772004-11-10
| | | FossilOrigin-Name: 8e5c2e5df8b824f7efb27e776240f005c6f1f0ff
* Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is ↵danielk19772004-11-09
| | | | | defined. (CVS 2083) FossilOrigin-Name: f81b9c1c022772378aad32ec45d0027beeb36574
* Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of ↵danielk19772004-11-09
| | | | | sqlite. (CVS 2082) FossilOrigin-Name: 0d27c8ff48f327ad82dd5b5b3b47b8d221f119b7
* Update tests to work even if some features of the library are disabled. (CVS ↵drh2004-11-03
| | | | | 2050) FossilOrigin-Name: b11fc9b3f3a2711f98e7e45724aa1d30081197f3
* Progress towards getting prepared statements and CREATE and DROP to playdrh2004-07-24
| | | | | nicely together. Work is incomplete. Some tests are known to fail. (CVS 1864) FossilOrigin-Name: 49b991492496e104f5eca620a5d465a742b7ff3a
* Update sqlite3_column_decltype() to return NULL as the declartion type fordanielk19772004-06-21
| | | | | an expression that is not a column reference. (CVS 1646) FossilOrigin-Name: ee9dffd986621490af7bd45c7fe070bb7da8c357
* Change the name of the TCL command from "sqlite" to "sqlite3" so that bothdrh2004-06-19
| | | | | SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) FossilOrigin-Name: d705d051bed2b92b6c3bbcc75fe5b056633b9c31
* (1) Modifications to the user-function interface and (2) Internal changesdanielk19772004-06-12
| | | | | to automatically created indices. (CVS 1575) FossilOrigin-Name: 5903f53828b5d282b33e27813417e4317c9ecf0b
* Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inheritdanielk19772004-06-07
| | | | | column declaration types from the SELECT statement. (CVS 1538) FossilOrigin-Name: 31c1668dbc2b84438a5b78b0270f58b37b03791d
* Update the typeof() operator to respect manifest types. (CVS 1450)danielk19772004-05-24
| | | FossilOrigin-Name: 162cf42e33691f4c9ec3a25abcaa2bdcdca2b5e0
* Get more tests running. (CVS 1409)drh2004-05-19
| | | FossilOrigin-Name: 7eb3f29e305d0f455f6544560c567fa6b6e24986
* Better error messages on constraint violations. Additional tests and bug fixesdrh2003-01-29
| | | | | for the callback-free API. (CVS 854) FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e
* Optimizations to the BTree module for a modest speed improvement. (CVS 810)drh2003-01-04
| | | FossilOrigin-Name: 39902a70417475225956704a037493515e9b08b9
* Parse foreign key constraints and populate internal data structuresdrh2002-08-31
| | | | | appropriately. Constraints are still not enforced. (CVS 738) FossilOrigin-Name: 170711ca65dc894d0486b9d575edb8f1708250fb
* Make the distinction between text and numeric data. (CVS 710)drh2002-08-13
| | | FossilOrigin-Name: 310ac4fbaf0ed63f98bfacb55259960be03b0c8b
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 03:59:43 +0000