SQLite

All files named ”test/misc2.test”
Login

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

History for test/misc2.test

2024-03-19
15:27
[a1a3573cc0] part of check-in [495b8c7b08] Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW. (check-in: [495b8c7b08] user: dan branch: rowid-in-view, size: 11724)
2021-04-07
15:45
[71e746af47] part of check-in [14b1d56ef8] Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. (check-in: [14b1d56ef8] user: drh branch: no-rowid-on-view, size: 11362)
2021-04-06
19:13
[3d8f161cc5] part of check-in [7a73c6166b] Raise an error if a query tries to access the "rowid" of a view, as views do not have rowids. (check-in: [7a73c6166b] user: drh branch: no-rowid-on-view, size: 11161)
2011-08-02
00:57
[00d7de54ed] 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: 11165)
2009-09-01
17:11
[a628db7b03] part of check-in [e016cca363] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (check-in: [e016cca363] user: dan branch: trunk, size: 11186)
2009-08-30
11:42
[0bd5a44926] part of check-in [9eb91efda5] Fixes for new triggers scheme. (check-in: [9eb91efda5] user: dan branch: trunk, size: 11198)
2007-09-12
17:01
[1ee89298de] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 10913)
2007-04-06
01:03
[d35faf7df2] part of check-in [bebf8d2f88] Make sure the sqlite3BtreePrevious() routine terminates properly if the table is deleted out from under it. Ticket #2286. This bug was discovered while trying to increase test coverage from 98.5% to 99% - once again showing the value of full coverage testing. (CVS 3818) (check-in: [bebf8d2f88] user: drh branch: trunk, size: 10494)
2006-09-29
14:01
[0b45deedcf] part of check-in [fcde639119] Make sure memory does not leak when patching up column names so that they are unique in a join or view. Tickets #1952 and #2002. (CVS 3451) (check-in: [fcde639119] user: drh branch: trunk, size: 8158)
2006-08-16
16:42
[9740c2fb7e] part of check-in [8c52d2ad46] Allows UPDATE, INSERT, and DELETEs to occur while a SELECT is pending on the same table. (CVS 3355) (check-in: [8c52d2ad46] user: drh branch: trunk, size: 7982)
2006-01-17
09:35
[09388e5a2c] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 6877)
2006-01-14
08:02
[17949ae34d] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 6868)
2005-04-29
02:10
[5c699af2fe] part of check-in [0667eae9a9] Prevent a segfault described by ticket #1229. (CVS 2450) (check-in: [0667eae9a9] user: drh branch: trunk, size: 6819)
2005-03-29
03:10
[d51379cc67] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 6326)
2005-01-21
04:25
[fc052267d5] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 6223)
2005-01-20
02:17
[51f45f56af] part of check-in [d267fb3ca3] Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: [d267fb3ca3] user: danielk1977 branch: trunk, size: 6164)
2004-11-22
15:05
[bc852f1622] part of check-in [894c142d11] Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: [894c142d11] user: danielk1977 branch: trunk, size: 6083)
13:35
[a655f2453d] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 6042)
10:02
[d3bea4b809] part of check-in [af635cab8a] Back out changes allowing writes to tables that have open cursors. (CVS 2134) (check-in: [af635cab8a] user: danielk1977 branch: trunk, size: 6042)
08:43
[851e63fcc8] part of check-in [711e8d7695] Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: [711e8d7695] user: danielk1977 branch: trunk, size: 4872)
2004-11-16
15:50
[53cf5e9315] part of check-in [a2e1c35b32] Perform deletes in a single pass. (CVS 2104) (check-in: [a2e1c35b32] user: danielk1977 branch: trunk, size: 4816)
2004-11-04
04:42
[9d9403f7e6] part of check-in [c33b3a6137] All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: [c33b3a6137] user: drh branch: trunk, size: 5978)
2004-06-19
00:16
[703734f581] 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: 5937)
2003-12-17
23:57
[10c2ce2640] part of check-in [da00efb13f] Make sure the pagers in-memory cache states in sync with the disk file. Ticket #529. (CVS 1133) (check-in: [da00efb13f] user: drh branch: trunk, size: 5934)
2003-12-10
01:31
[b5813a4add] part of check-in [230a4ff2c8] Fix the code generator to a void a VDBE stack overflow on 3-way joins. Ticket #519. (CVS 1129) (check-in: [230a4ff2c8] user: drh branch: trunk, size: 5921)
2003-09-12
02:08
[5818bfafd0] part of check-in [4fbca3ab09] The tokenizer should never return a negative size of the next token. Ticket #453. (CVS 1098) (check-in: [4fbca3ab09] user: drh branch: trunk, size: 4766)
2003-08-27
22:54
[d7bc75fae9] part of check-in [3403d28a49] Add locks to the in-memory backend so that recursive writes will be detected and rejected. Ticket #436. (CVS 1089) (check-in: [3403d28a49] user: drh branch: trunk, size: 4528)
2003-08-26
11:25
[48f1f21878] part of check-in [da53369f0b] If the database filename is an empty string, open a temporary file to hold the database. Ticket #432. (CVS 1085) (check-in: [da53369f0b] user: drh branch: trunk, size: 3360)
2003-07-30
12:34
[6400032fe0] part of check-in [da62732554] The {quote: SrcList} object was not being expanded correctly by a call to sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by a call to sqliteSrcListDup(). Ticket #416. This check-in fixes that problem by keeping a separate nAlloc field on {quote: SrcList}. A similar change is made to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067) (check-in: [da62732554] user: drh branch: trunk, size: 3027)
2003-07-27
17:16
[d8a0b59399] part of check-in [7514c3db16] In the VDBE, when an integer value will not fit into a 32-bit int, store it in a double instead. Ticket #408. (CVS 1064) (check-in: [7514c3db16] user: drh branch: trunk, size: 2502)
2003-07-09
16:34
[36410e371d] part of check-in [6a07ac3782] An an extra test associated with ticket #387. (CVS 1050) (check-in: [6a07ac3782] user: drh branch: trunk, size: 1639)
2003-06-29
20:25
[5389f9aa90] part of check-in [fc490f677b] The prior fix of ticket #360 was incorrect and caused a memory leak. This check-in plugs the memory leak and correctly fixes ticket #360. (CVS 1040) (check-in: [fc490f677b] user: drh branch: trunk, size: 1458)
2003-06-24
10:39
[c896dd7c87] part of check-in [bad8b55833] In a SELECT, the rowid of a view or subquery which is really a join is set to NULL if the join is flattened. Ticket #364. (CVS 1034) (check-in: [bad8b55833] user: drh branch: trunk, size: 1373)
2003-06-22
01:41
Added: [afbb067879] part of check-in [cb70ee67ea] Make sure the source of a PULL opcode is not an ephemeral string. Ticket #360. (CVS 1031) (check-in: [cb70ee67ea] user: drh branch: trunk, size: 951)