Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/misc1.test
|
2018-12-20
| ||
| 22:08 | Do not set the Cursor.seekOp test variable in the OP_NotExists opcode. This is a change to test logic only and does not affect deliverable builds. file: [7ce84b25] check-in: [98f34307] user: drh branch: trunk, size: 25820 | |
|
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: [c8cfd1c3] check-in: [3212733c] user: drh branch: read-only-shadow, size: 25484 | |
|
2017-12-29
| ||
| 12:50 | Add test cases for the undocumented behavior of duplicate columns on an INSERT or UPDATE. file: [704ea2cc] check-in: [f4349c0c] user: drh branch: trunk, size: 25385 | |
|
2017-09-17
| ||
| 19:45 | Do not make the assumption (as check-in [4da49a95c0f07] incorrectly did) that the ExprList returned by sqlite3ExprListDup() would never be passed into sqlite3ExprListAppend(). Include a new test case that shows this sometimes does happen. file: [76737c25] check-in: [29227d00] user: drh branch: trunk, size: 24786 | |
|
2017-07-22
| ||
| 16:58 | Add the "atomic-batch-write" permutation to permutations.test. This permutation fails if not run on a file-system that supports atomic-batch-writes. file: [51ec3f56] check-in: [9f1b83fa] user: dan branch: batch-atomic-write, size: 23307 | |
|
2016-02-18
| ||
| 14:49 | Avoid a potential buffer overrun if an SQL statement being parsed ends with an illegal "!" token. (This problem was detected by fuzzcheck running under valgrind. The problem was introduced by check-in [9570b6b43df3], two days ago and has not appeared in a release.) file: [6430dabf] check-in: [2a8d97e7] user: drh branch: trunk, size: 23226 | |
|
2015-11-21
| ||
| 13:24 | Do not allow table-valued function syntax on ordinary tables and views as those objects are not table-valued functions. Fix for ticket [73eba7ba5c7c0fc]. Problem found by libFuzzer. file: [48ebfb5b] check-in: [ff5716b8] user: drh branch: trunk, size: 23225 | |
|
2015-11-14
| ||
| 22:04 | Code simplification in sqlite3ColumnsFromExprList(). Update the %z format code so that it works with buffers obtained from sqlite3DbMalloc(). Add a testcase for the slow column name uniquifier. file: [d614a334] check-in: [92724260] user: drh branch: trunk, size: 23234 | |
|
2015-09-07
| ||
| 18:23 | For the Lemon-generated parser, add a new action type SHIFTREDUCE and use it to further compress the parser tables and improve parser performance. file: [0be38a29] check-in: [531c3974] user: drh branch: lemon-update, size: 18789 | |
|
2015-05-26
| ||
| 18:58 | Fix a one-byte buffer overread that may follow a syntax error while preparing an SQL statement. file: [3f1c479c] check-in: [07500393] user: dan branch: test-using-fuzzcheck, size: 18788 | |
|
2015-05-20
| ||
| 20:24 | Fix a potential NULL pointer deference on a corrupt database schema. Cherrypick of [dc61b292d8ea]. file: [df58abc1] check-in: [7f3943fb] user: dan branch: branch-3.8.6, size: 17340 | |
| 19:44 | Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. Cherrypick of [02e3c88fbf6a]. file: [830f2398] check-in: [4125477e] user: dan branch: branch-3.8.6, size: 17006 | |
| 17:25 | Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. file: [2bb46a36] check-in: [0e45e8f1] user: drh branch: create-table-as-type-fix, size: 18567 | |
|
2015-04-19
| ||
| 21:59 | Fix another assert() that is not true if the database schema is corrupt. file: [783ba757] check-in: [bc97cec6] user: drh branch: trunk, size: 18316 | |
| 20:39 | Fix a faulty assert in the schema parsing logic. file: [e908edf5] check-in: [b1ed9495] user: drh branch: trunk, size: 18056 | |
| 19:21 | Fix a potential NULL pointer deference on a corrupt database schema. file: [623405f6] check-in: [dc61b292] user: drh branch: trunk, size: 17746 | |
|
2015-04-15
| ||
| 04:51 | When doing the (dubious) conversion of double-quoted identifier into string literal for MySQL compatibility, be sure to also clear the iTable value from the Expr entry to avoid an assert. file: [9abcae9a] check-in: [d7211b68] user: drh branch: trunk, size: 17412 | |
|
2015-03-22
| ||
| 10:23 | Fix a potential NULL pointer dereference following a syntax error. file: [f3f59b39] check-in: [8d27e3e1] user: drh branch: trunk, size: 17329 | |
|
2015-01-27
| ||
| 13:17 | Fix a (almost always harmless) read past the end of a memory allocation that comes about because the Expr.pTab field is checked on an EXPR_REDUCEDSIZE Expr object before checking the Expr.op field to know that the Expr.pTab field is meaningless. file: [4864f283] check-in: [e098de69] user: drh branch: trunk, size: 17145 | |
|
2014-05-16
| ||
| 14:17 | Repurpose the SQLITE_TESTCTRL_FAULT_INSTALL test-control to register a callback to be invoked by sqlite3FaultSim(). That test-control has been unused since 2008-06-20 and was never used in any official release. file: [1201a037] check-in: [0d43a7ad] user: drh branch: trunk, size: 16849 | |
|
2014-01-10
| ||
| 20:38 | Fix CREATE TABLE ... AS so that it works with column names that are empty strings. file: [441a0faf] check-in: [632045f2] user: drh branch: trunk, size: 16465 | |
|
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: [9bed1bd3] check-in: [54b22192] user: drh branch: omit-rowid, size: 16125 | |
| 01:59 | Add the conflict2.test script. Fix issues discovered by this script. file: [fc2e45c7] check-in: [294ed337] user: drh branch: omit-rowid, size: 16115 | |
|
2012-03-05
| ||
| 22:52 | Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. file: [889b4072] check-in: [86c049a1] user: mistachkin branch: winrt, size: 16116 | |
|
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: [55cb2bfb] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 15987 | |
|
2010-03-19
| ||
| 15:48 | Do not create, open, or initialize the rollback journal until something actually needs to be written into the journal. That way, expensive filesystem operations are avoided if the transaction ends up being a no-op. file: [e56baf44] check-in: [b78e58ae] user: drh branch: trunk, size: 15994 | |
|
2007-11-05
| ||
| 14:58 | Fix a bug in the misc1 test script. (CVS 4526) file: [1b89c02c] check-in: [fa16996d] user: drh branch: trunk, size: 15884 | |
|
2006-06-27
| ||
| 20:06 | Move the sqlite3_sleep() and sqlite3_clear_bindings() interfaces into the main library and make this official. (CVS 3316) file: [27a6ad11] check-in: [eb3442c4] user: drh branch: trunk, size: 15877 | |
|
2006-01-17
| ||
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [5a9cfffc] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 15812 | |
|
2005-11-01
| ||
| 15:48 | Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) file: [7aabf32e] check-in: [e0d6f61c] user: drh branch: trunk, size: 15757 | |
|
2005-09-08
| ||
| 10:37 | The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) file: [c9916176] check-in: [21adf4bd] user: drh branch: trunk, size: 15767 | |
|
2005-08-19
| ||
| 03:03 | Additional tests for better coverage. (CVS 2602) file: [4ca69ca2] check-in: [4281a838] user: drh branch: trunk, size: 15783 | |
|
2005-08-13
| ||
| 12:59 | Add the "!" flag to the "%g" mprintf conversion parameter to force a decimal point. This prevents floating point values from appearing as integers. Use this flag when converting floating point to text. Ticket #1362. (CVS 2586) file: [be8aa484] check-in: [4b98dace] user: drh branch: trunk, size: 15555 | |
|
2005-07-16
| ||
| 13:33 | Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) file: [a4fe87c7] check-in: [ca69f368] user: drh branch: trunk, size: 15547 | |
|
2005-03-29
| ||
| 03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [a4a36c19] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 15530 | |
|
2005-01-21
| ||
| 04:25 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [ff817d37] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 15524 | |
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [e4d9edd5] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 15520 | |
|
2004-11-04
| ||
| 04:42 | All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) file: [744f60d1] check-in: [c33b3a61] user: drh branch: trunk, size: 15425 | |
|
2004-08-20
| ||
| 18:34 | Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [1a20ea72] check-in: [e97c3313] user: drh branch: trunk, size: 15401 | |
|
2004-07-19
| ||
| 00:39 | When comparing two expressions do not apply affinity to either operand. Ticket #805. (CVS 1810) file: [72768ec8] check-in: [88a4e400] user: drh branch: trunk, size: 15385 | |
|
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: [a8eb48d3] check-in: [d705d051] user: drh branch: trunk, size: 15385 | |
|
2004-06-10
| ||
| 05:59 | Misc fixes for test cases failing due to the new locking model. (CVS 1561) file: [8472d213] check-in: [71e98d0d] user: danielk1977 branch: trunk, size: 15392 | |
|
2004-06-09
| ||
| 09:55 | Some progress on user-defined collation sequences. (CVS 1544) file: [06e92b61] check-in: [c634e71f] user: danielk1977 branch: trunk, size: 15259 | |
|
2004-05-31
| ||
| 08:26 | Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [508ef728] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 14886 | |
|
2004-05-19
| ||
| 20:41 | Correctly handle 64-bit integers in SQL statements. (CVS 1408) file: [2e1c0d59] check-in: [34f03ba6] user: drh branch: trunk, size: 14802 | |
|
2003-08-05
| ||
| 13:13 | Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) file: [0b98d493] check-in: [086aa1c9] user: drh branch: trunk, size: 14868 | |
|
2003-06-03
| ||
| 01:47 | Additional testing of the ATTACH command with bug fixes for the new problems that the tests found. (CVS 998) file: [c7dc2f2b] check-in: [3e8889d7] user: drh branch: trunk, size: 14869 | |
|
2003-02-26
| ||
| 13:52 | Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) file: [865c907d] check-in: [66158843] user: drh branch: trunk, size: 14187 | |
|
2003-02-01
| ||
| 13:53 | When a CREATE TABLE ... AS SELECT statement fails, make sure the table name is removed from the internal hash tables. Ticket #238. (CVS 858) file: [2876987a] check-in: [65264780] user: drh branch: trunk, size: 13320 | |
|
2003-01-29
| ||
| 18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [6d61d128] check-in: [ccc82f1a] user: drh branch: trunk, size: 12930 | |
|
2003-01-18
| ||
| 20:11 | Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) file: [9f9e8b6f] check-in: [71cc292d] user: drh branch: trunk, size: 12919 | |
|
2002-12-07
| ||
| 21:45 | Save the full pathname of the database file so that journalling still works even if the user changes working directories after opening the databae. Ticket #200. (CVS 798) file: [828ea289] check-in: [1c58b4fc] user: drh branch: trunk, size: 12713 | |
|
2002-10-22
| ||
| 23:38 | Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) file: [3c467206] check-in: [3b68aa25] user: drh branch: trunk, size: 12344 | |
|
2002-09-17
| ||
| 03:20 | Fix a bug in the OP_MemStore operator of the VDBE. A realloc() might occur but pointer to the old buffer were not being moved over to the new buffer. (CVS 752) file: [9b0fdc82] check-in: [29145746] user: drh branch: trunk, size: 12168 | |
|
2002-08-18
| ||
| 22:41 | This COLLATE keyword was not being parsed correctly inside CREATE TABLE statements - it was being included as part of the datatype. This fixes the problem. (CVS 722) file: [3ee14f86] check-in: [39bd52d3] user: drh branch: trunk, size: 10777 | |
|
2002-08-15
| ||
| 11:48 | Additional test cases and documentation updates. (CVS 717) file: [834dce8b] check-in: [048b16c1] user: drh branch: trunk, size: 9864 | |
|
2002-08-13
| ||
| 23:02 | Make the distinction between text and numeric data. (CVS 710) file: [064d7fbb] check-in: [310ac4fb] user: drh branch: trunk, size: 8766 | |
|
2002-07-30
| ||
| 18:43 | Fix for ticket #114: Correctly handle SQLITE_BUSY if it occurs during database initialization. (CVS 696) file: [eb47435b] check-in: [5b814b5d] user: drh branch: trunk, size: 8643 | |
|
2002-06-28
| ||
| 01:02 | Fix for ticket #84: If the WHERE clause is too complex, issue an error message and refuse to do the SELECT. The cutoff is a WHERE clause with 100 terms. (CVS 650) file: [13584dda] check-in: [c07e493b] user: drh branch: trunk, size: 8226 | |
|
2002-06-21
| ||
| 23:01 | Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) file: [18c74cdf] check-in: [9d552310] user: drh branch: trunk, size: 6891 | |
|
2002-06-09
| ||
| 01:16 | Fix for ticket #65: If an integer value is too big to be represented as a 32-bit integer, then treat it as a string. (CVS 611) file: [faae0b01] check-in: [ad962479] user: drh branch: trunk, size: 6892 | |
|
2002-06-06
| ||
| 23:42 | Bug fix: do not segfault if a SELECT without a FROM clause includes the * wildcard in the result column list. (CVS 609) file: [87490d33] check-in: [d9392949] user: drh branch: trunk, size: 6351 | |
|
2002-05-24
| ||
| 02:14 | Added tests for multi-column primary keys. (CVS 585) file: [df281e9b] check-in: [ffc49e56] user: drh branch: trunk, size: 6191 | |
|
2002-03-30
| ||
| 15:26 | Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) file: [a0321411] check-in: [d2bdc0fe] user: drh branch: trunk, size: 5355 | |
|
2002-03-13
| ||
| 18:54 | Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) file: [84a3d8e8] check-in: [c0e3f1c5] user: drh branch: trunk, size: 4422 | |
|
2002-02-14
| ||
| 12:50 | Fix an incorrect assert() in pager.c. (CVS 369) file: [7fd54d33] check-in: [08a68e09] user: drh branch: trunk, size: 3941 | |
|
2002-02-13
| ||
| 23:22 | Bug fix: if PRAGMA full_column_names=ON is set and you do a query like this: "SELECT rowid,* FROM ...", then an assertion failed. Bummer. (CVS 368) file: [5ed0df72] check-in: [df6bf627] user: drh branch: trunk, size: 3318 | |
|
2001-09-18
| ||
| 22:17 | Fix a problem in GROUP BY with multiple columns. (CVS 255) file: [50a5ca34] check-in: [22132ce1] user: drh branch: trunk, size: 3032 Added | |