/ File History
Login

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