/ All files named "test/misc1.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/misc1.test

2020-07-29
16:18
[8526f45c] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 25819)
2018-12-20
22:08
[7ce84b25] part of check-in [98f34307] 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. (check-in: [98f34307] user: drh branch: trunk, size: 25820)
2018-11-07
02:17
[c8cfd1c3] part of check-in [3212733c] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733c] user: drh branch: read-only-shadow, size: 25484)
2017-12-29
12:50
[704ea2cc] part of check-in [f4349c0c] Add test cases for the undocumented behavior of duplicate columns on an INSERT or UPDATE. (check-in: [f4349c0c] user: drh branch: trunk, size: 25385)
2017-09-17
19:45
[76737c25] part of check-in [29227d00] 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. (check-in: [29227d00] user: drh branch: trunk, size: 24786)
2017-07-22
16:58
[51ec3f56] part of check-in [9f1b83fa] Add the "atomic-batch-write" permutation to permutations.test. This permutation fails if not run on a file-system that supports atomic-batch-writes. (check-in: [9f1b83fa] user: dan branch: batch-atomic-write, size: 23307)
2016-02-18
14:49
[6430dabf] part of check-in [2a8d97e7] 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.) (check-in: [2a8d97e7] user: drh branch: trunk, size: 23226)
2015-11-21
13:24
[48ebfb5b] part of check-in [ff5716b8] 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. (check-in: [ff5716b8] user: drh branch: trunk, size: 23225)
2015-11-14
22:04
[d614a334] part of check-in [92724260] 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. (check-in: [92724260] user: drh branch: trunk, size: 23234)
2015-09-07
18:23
[0be38a29] part of check-in [531c3974] For the Lemon-generated parser, add a new action type SHIFTREDUCE and use it to further compress the parser tables and improve parser performance. (check-in: [531c3974] user: drh branch: lemon-update, size: 18789)
2015-05-26
18:58
[3f1c479c] part of check-in [07500393] Fix a one-byte buffer overread that may follow a syntax error while preparing an SQL statement. (check-in: [07500393] user: dan branch: test-using-fuzzcheck, size: 18788)
2015-05-20
20:24
[df58abc1] part of check-in [7f3943fb] Fix a potential NULL pointer deference on a corrupt database schema. Cherrypick of [dc61b292d8ea]. (check-in: [7f3943fb] user: dan branch: branch-3.8.6, size: 17340)
19:44
[830f2398] part of check-in [4125477e] Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. Cherrypick of [02e3c88fbf6a]. (check-in: [4125477e] user: dan branch: branch-3.8.6, size: 17006)
17:25
[2bb46a36] part of check-in [0e45e8f1] Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. (check-in: [0e45e8f1] user: drh branch: create-table-as-type-fix, size: 18567)
2015-04-19
21:59
[783ba757] part of check-in [bc97cec6] Fix another assert() that is not true if the database schema is corrupt. (check-in: [bc97cec6] user: drh branch: trunk, size: 18316)
20:39
[e908edf5] part of check-in [b1ed9495] Fix a faulty assert in the schema parsing logic. (check-in: [b1ed9495] user: drh branch: trunk, size: 18056)
19:21
[623405f6] part of check-in [dc61b292] Fix a potential NULL pointer deference on a corrupt database schema. (check-in: [dc61b292] user: drh branch: trunk, size: 17746)
2015-04-15
04:51
[9abcae9a] part of check-in [d7211b68] 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. (check-in: [d7211b68] user: drh branch: trunk, size: 17412)
2015-03-22
10:23
[f3f59b39] part of check-in [8d27e3e1] Fix a potential NULL pointer dereference following a syntax error. (check-in: [8d27e3e1] user: drh branch: trunk, size: 17329)
2015-01-27
13:17
[4864f283] part of check-in [e098de69] 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. (check-in: [e098de69] user: drh branch: trunk, size: 17145)
2014-05-16
14:17
[1201a037] part of check-in [0d43a7ad] 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. (check-in: [0d43a7ad] user: drh branch: trunk, size: 16849)
2014-01-10
20:38
[441a0faf] part of check-in [632045f2] Fix CREATE TABLE ... AS so that it works with column names that are empty strings. (check-in: [632045f2] user: drh branch: trunk, size: 16465)
2013-11-05
13:33
[9bed1bd3] part of check-in [54b22192] 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: [54b22192] user: drh branch: omit-rowid, size: 16125)
01:59
[fc2e45c7] part of check-in [294ed337] Add the conflict2.test script. Fix issues discovered by this script. (check-in: [294ed337] user: drh branch: omit-rowid, size: 16115)
2012-03-05
22:52
[889b4072] part of check-in [86c049a1] 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. (check-in: [86c049a1] user: mistachkin branch: winrt, size: 16116)
2011-08-02
00:57
[55cb2bfb] part of check-in [9007586f] 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: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 15987)
2010-03-19
15:48
[e56baf44] part of check-in [b78e58ae] 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. (check-in: [b78e58ae] user: drh branch: trunk, size: 15994)
2007-11-05
14:58
[1b89c02c] part of check-in [fa16996d] Fix a bug in the misc1 test script. (CVS 4526) (check-in: [fa16996d] user: drh branch: trunk, size: 15884)
2006-06-27
20:06
[27a6ad11] part of check-in [eb3442c4] Move the sqlite3_sleep() and sqlite3_clear_bindings() interfaces into the main library and make this official. (CVS 3316) (check-in: [eb3442c4] user: drh branch: trunk, size: 15877)
2006-01-17
09:35
[5a9cfffc] part of check-in [3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 15812)
2005-11-01
15:48
[7aabf32e] part of check-in [e0d6f61c] 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) (check-in: [e0d6f61c] user: drh branch: trunk, size: 15757)
2005-09-08
10:37
[c9916176] part of check-in [21adf4bd] 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) (check-in: [21adf4bd] user: drh branch: trunk, size: 15767)
2005-08-19
03:03
[4ca69ca2] part of check-in [4281a838] Additional tests for better coverage. (CVS 2602) (check-in: [4281a838] user: drh branch: trunk, size: 15783)
2005-08-13
12:59
[be8aa484] part of check-in [4b98dace] 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) (check-in: [4b98dace] user: drh branch: trunk, size: 15555)
2005-07-16
13:33
[a4fe87c7] part of check-in [ca69f368] Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) (check-in: [ca69f368] user: drh branch: trunk, size: 15547)
2005-03-29
03:10
[a4a36c19] part of check-in [c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d5544] user: danielk1977 branch: trunk, size: 15530)
2005-01-21
04:25
[ff817d37] part of check-in [d4e19efc] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 15524)
03:12
[e4d9edd5] part of check-in [bb0254ab] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 15520)
2004-11-04
04:42
[744f60d1] part of check-in [c33b3a61] All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: [c33b3a61] user: drh branch: trunk, size: 15425)
2004-08-20
18:34
[1a20ea72] part of check-in [e97c3313] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c3313] user: drh branch: trunk, size: 15401)
2004-07-19
00:39
[72768ec8] part of check-in [88a4e400] When comparing two expressions do not apply affinity to either operand. Ticket #805. (CVS 1810) (check-in: [88a4e400] user: drh branch: trunk, size: 15385)
2004-06-19
00:16
[a8eb48d3] part of check-in [d705d051] 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: [d705d051] user: drh branch: trunk, size: 15385)
2004-06-10
05:59
[8472d213] part of check-in [71e98d0d] Misc fixes for test cases failing due to the new locking model. (CVS 1561) (check-in: [71e98d0d] user: danielk1977 branch: trunk, size: 15392)
2004-06-09
09:55
[06e92b61] part of check-in [c634e71f] Some progress on user-defined collation sequences. (CVS 1544) (check-in: [c634e71f] user: danielk1977 branch: trunk, size: 15259)
2004-05-31
08:26
[508ef728] part of check-in [b8ed812c] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 14886)
2004-05-19
20:41
[2e1c0d59] part of check-in [34f03ba6] Correctly handle 64-bit integers in SQL statements. (CVS 1408) (check-in: [34f03ba6] user: drh branch: trunk, size: 14802)
2003-08-05
13:13
[0b98d493] part of check-in [086aa1c9] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c9] user: drh branch: trunk, size: 14868)
2003-06-03
01:47
[c7dc2f2b] part of check-in [3e8889d7] Additional testing of the ATTACH command with bug fixes for the new problems that the tests found. (CVS 998) (check-in: [3e8889d7] user: drh branch: trunk, size: 14869)
2003-02-26
13:52
[865c907d] part of check-in [66158843] Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) (check-in: [66158843] user: drh branch: trunk, size: 14187)
2003-02-01
13:53
[2876987a] part of check-in [65264780] When a CREATE TABLE ... AS SELECT statement fails, make sure the table name is removed from the internal hash tables. Ticket #238. (CVS 858) (check-in: [65264780] user: drh branch: trunk, size: 13320)
2003-01-29
18:46
[6d61d128] part of check-in [ccc82f1a] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1a] user: drh branch: trunk, size: 12930)
2003-01-18
20:11
[9f9e8b6f] part of check-in [71cc292d] Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) (check-in: [71cc292d] user: drh branch: trunk, size: 12919)
2002-12-07
21:45
[828ea289] part of check-in [1c58b4fc] 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) (check-in: [1c58b4fc] user: drh branch: trunk, size: 12713)
2002-10-22
23:38
[3c467206] part of check-in [3b68aa25] Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) (check-in: [3b68aa25] user: drh branch: trunk, size: 12344)
2002-09-17
03:20
[9b0fdc82] part of check-in [29145746] 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) (check-in: [29145746] user: drh branch: trunk, size: 12168)
2002-08-18
22:41
[3ee14f86] part of check-in [39bd52d3] 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) (check-in: [39bd52d3] user: drh branch: trunk, size: 10777)
2002-08-15
11:48
[834dce8b] part of check-in [048b16c1] Additional test cases and documentation updates. (CVS 717) (check-in: [048b16c1] user: drh branch: trunk, size: 9864)
2002-08-13
23:02
[064d7fbb] part of check-in [310ac4fb] Make the distinction between text and numeric data. (CVS 710) (check-in: [310ac4fb] user: drh branch: trunk, size: 8766)
2002-07-30
18:43
[eb47435b] part of check-in [5b814b5d] Fix for ticket #114: Correctly handle SQLITE_BUSY if it occurs during database initialization. (CVS 696) (check-in: [5b814b5d] user: drh branch: trunk, size: 8643)
2002-06-28
01:02
[13584dda] part of check-in [c07e493b] 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) (check-in: [c07e493b] user: drh branch: trunk, size: 8226)
2002-06-21
23:01
[18c74cdf] part of check-in [9d552310] Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) (check-in: [9d552310] user: drh branch: trunk, size: 6891)
2002-06-09
01:16
[faae0b01] part of check-in [ad962479] 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) (check-in: [ad962479] user: drh branch: trunk, size: 6892)
2002-06-06
23:42
[87490d33] part of check-in [d9392949] Bug fix: do not segfault if a SELECT without a FROM clause includes the * wildcard in the result column list. (CVS 609) (check-in: [d9392949] user: drh branch: trunk, size: 6351)
2002-05-24
02:14
[df281e9b] part of check-in [ffc49e56] Added tests for multi-column primary keys. (CVS 585) (check-in: [ffc49e56] user: drh branch: trunk, size: 6191)
2002-03-30
15:26
[a0321411] part of check-in [d2bdc0fe] Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) (check-in: [d2bdc0fe] user: drh branch: trunk, size: 5355)
2002-03-13
18:54
[84a3d8e8] part of check-in [c0e3f1c5] Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) (check-in: [c0e3f1c5] user: drh branch: trunk, size: 4422)
2002-02-14
12:50
[7fd54d33] part of check-in [08a68e09] Fix an incorrect assert() in pager.c. (CVS 369) (check-in: [08a68e09] user: drh branch: trunk, size: 3941)
2002-02-13
23:22
[5ed0df72] part of check-in [df6bf627] 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) (check-in: [df6bf627] user: drh branch: trunk, size: 3318)
2001-09-18
22:17
Added: [50a5ca34] part of check-in [22132ce1] Fix a problem in GROUP BY with multiple columns. (CVS 255) (check-in: [22132ce1] user: drh branch: trunk, size: 3032)