SQLite

All files named ”test/attach.test”
Login

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

History for test/attach.test

2025-03-27
14:32
[12b2a9872c] part of check-in [f96a5346e3] In Tcl, always use eq/ne for comparing strings, not ==/!= (check-in: [f96a5346e3] user: jan.nijtmans branch: cygwin-fixes, size: 21794)
2021-05-10
13:28
[3a0e14ca69] part of check-in [905085a75d] Add new output columns to the "PRAGMA database_list" statement. (check-in: [905085a75d] user: drh branch: database-list-enhancement, size: 21787)
2021-03-10
16:35
[54f8e49e88] part of check-in [7b65fb9f7b] Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. Forum post a006d86f72. (check-in: [7b65fb9f7b] user: drh branch: trunk, size: 21792)
2020-04-09
18:51
[9dda4f69b4] part of check-in [d6fda470fe] Merge recent trunk changes into the apple-osx branch. (check-in: [d6fda470fe] user: drh branch: apple-osx, size: 21323)
2020-03-20
20:54
[d42862c72f] part of check-in [75c85ca32f] Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: [75c85ca32f] user: dan branch: main-alias-fix, size: 21312)
2018-11-30
18:22
[5f20de6f9a] part of check-in [2c76ce4f42] Merge the pre-3.26.0 fixes from trunk. (check-in: [2c76ce4f42] user: drh branch: apple-osx, size: 21342)
2018-11-28
11:49
[21bce8681f] part of check-in [b53a9a3dc6] Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: [b53a9a3dc6] user: dan branch: trunk, size: 21331)
2018-11-26
23:35
[9843454e89] part of check-in [e8c20a88c1] Merge recent enhancements from trunk. (check-in: [e8c20a88c1] user: drh branch: apple-osx, size: 21336)
2018-11-16
20:50
[fb03859ee3] part of check-in [2d92d25fae] Fix a test case so that it works on windows. (check-in: [2d92d25fae] user: drh branch: trunk, size: 21325)
2018-11-05
13:53
[8dc49f58f7] part of check-in [62acf7a09e] Merge recent trunk enhancements. (check-in: [62acf7a09e] user: drh branch: apple-osx, size: 21314)
2018-11-02
17:38
[dff436fd94] part of check-in [1fa74930ab] Enhance triggers so that they can use table-valued-functions that exist in schemas outside of the schema in which the trigger is defined. (check-in: [1fa74930ab] user: drh branch: trunk, size: 21303)
2017-07-17
20:21
[402747cea8] part of check-in [e181225dc7] Merge all the latest fixes and enhancements from trunk. (check-in: [e181225dc7] user: drh branch: apple-osx, size: 20699)
2017-07-15
20:33
[f4b8918ba2] part of check-in [253945d480] Fix a register allocation problem in PRAGMA integrity_check that caused the same register to be used for two different purposes on the first ATTACHed database if the schema for the ATTACHed database was noticable more complex than the schema for the first database. Fix for ticket [a4e06e75a9ab61a1]. (check-in: [253945d480] user: drh branch: trunk, size: 20688)
2017-07-10
12:07
[b4c269f780] part of check-in [f27b637040] Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. (check-in: [f27b637040] user: drh branch: trunk, size: 20065)
2016-12-16
21:29
[f4ff7d4634] part of check-in [4b1e780433] Merge recent enhancements from trunk, and especially the pragma-as-vtab change. (check-in: [4b1e780433] user: drh branch: apple-osx, size: 20092)
01:00
[9976867b1a] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 20081)
2015-04-01
16:13
[1e7275728d] part of check-in [71b6f507f1] Merge all recent trunk fixes and enhancements into the apple-osx branch. (check-in: [71b6f507f1] user: drh branch: apple-osx, size: 20092)
2015-03-31
16:33
[437107943f] part of check-in [586a94e85b] Handle very large URI pathnames for in-memory shared-cache databases. (check-in: [586a94e85b] user: drh branch: trunk, size: 20081)
2012-05-26
18:06
[29cf17b579] part of check-in [4590e433f2] Enable the use of shared cache for an in-memory database, so that separate database connections can share the same in-memory database. (check-in: [4590e433f2] user: drh branch: shared-cache-memdb, size: 19793)
2012-02-22
20:08
[8511625fa8] part of check-in [c81fc40b2b] Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. (check-in: [c81fc40b2b] user: drh branch: file-control-pragma, size: 19789)
18:21
[80762134ca] part of check-in [a1f29fa653] Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. (check-in: [a1f29fa653] user: drh branch: file-control-pragma, size: 20030)
16:58
[064911a24b] part of check-in [fd8d744027] Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. (check-in: [fd8d744027] user: drh branch: file-control-pragma, size: 19994)
2011-12-08
21:08
[63033baa59] part of check-in [59e0d4f3d9] Merge the latest trunk changes into the apple-osx branch. (check-in: [59e0d4f3d9] user: drh branch: apple-osx, size: 19798)
2011-11-17
00:56
[0d112b7713] part of check-in [93a947989b] Add the sqlite3_db_filename() interface. (check-in: [93a947989b] user: drh branch: trunk, size: 19787)
2011-08-23
18:06
[a1ddc40e5d] part of check-in [c5f7977b89] Merge latest trunk changes into the apple-osx branch. (check-in: [c5f7977b89] user: dan branch: apple-osx, size: 19376)
2011-08-02
00:57
[0e6f8de258] 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: 19365)
2011-04-04
13:11
[e26b6c050d] part of check-in [6d78a25ddc] Merge in the latest changes from trunk. (check-in: [6d78a25ddc] user: drh branch: apple-osx, size: 19453)
2011-03-23
18:22
[2bb09073d7] part of check-in [7aaf877227] Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. (check-in: [7aaf877227] user: drh branch: trunk, size: 19442)
2010-11-18
16:14
[f2b4ac6931] part of check-in [ae089ec881] Update test cases to account for the change in the previous commit. (check-in: [ae089ec881] user: dan branch: blocking-checkpoint, size: 19342)
2009-12-16
23:46
[ccdedd5496] part of check-in [5754a3a561] Merge the latest changes on trunk (and especially the fix for the (xANDy)OR(z) bug) into apple-osx. (check-in: [5754a3a561] user: drh branch: apple-osx, size: 19352)
2009-12-08
13:44
[ce9660e517] part of check-in [4eb9bf0b93] Add test cases for ticket [abe728bbc311]. (check-in: [4eb9bf0b93] user: drh branch: trunk, size: 19341)
2009-12-07
23:53
[ebbaeb5032] part of check-in [ad08794d72] Merge all changes associated with the version 3.6.21 release into the OS-X branch. (check-in: [ad08794d72] user: drh branch: apple-osx, size: 18819)
2009-12-03
04:32
[826f7676c4] part of check-in [59e2e2c630] Fix cut-and-paste error affecting a couple of attach tests on Windows. (check-in: [59e2e2c630] user: shaneh branch: trunk, size: 18808)
2009-11-20
17:18
[7f07ec54a8] part of check-in [1c4984c62f] Add a test to make sure a database can be attached to a single handle twice if not in shared-cache mode. (check-in: [1c4984c62f] user: dan branch: trunk, size: 18868)
2009-11-03
22:34
[5519fbeb99] part of check-in [941a01eb86] Customizations for OSX contributed by Apple. (check-in: [941a01eb86] user: adam branch: apple-osx, size: 18161)
2009-05-29
14:39
[1d1be27b9e] part of check-in [bd89f2c29b] Refinements in expression handling logic that have resulted from recent structural testing. (CVS 6690) (check-in: [bd89f2c29b] user: drh branch: trunk, size: 18150)
2009-05-28
01:00
[e710d54376] part of check-in [4ac2bdfbb4] Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: [4ac2bdfbb4] user: drh branch: trunk, size: 18145)
2009-05-27
10:31
[27635c3445] part of check-in [7cb1c3ba07] Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) (check-in: [7cb1c3ba07] user: drh branch: trunk, size: 18145)
2008-07-12
14:52
[75a5d22f88] part of check-in [dcb160249f] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (check-in: [dcb160249f] user: drh branch: trunk, size: 18272)
2008-02-06
14:11
[4ab582932e] part of check-in [c246162043] Add the sqlite3_result_error_code() application interface. Use it in the ATTACH function so that a failed attach returns a proper error code. Ticket #2914. (CVS 4775) (check-in: [c246162043] user: drh branch: trunk, size: 18344)
2007-10-09
08:29
[72529edb04] part of check-in [07c00fffe5] Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) (check-in: [07c00fffe5] user: danielk1977 branch: trunk, size: 17550)
2007-09-12
17:01
[8880661ee0] 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: 17504)
2007-08-29
17:43
[b849e1baae] part of check-in [2732af0ec7] Improvements to mutex asserts. The quick test runs to completion without assertion faults. (CVS 4324) (check-in: [2732af0ec7] user: drh branch: trunk, size: 17455)
2007-05-09
20:31
[cf289abdb1] part of check-in [0c91dc9ee0] Fix a problem with strange expressions being fed to an ATTACH or DETACH statement. (CVS 3965) (check-in: [0c91dc9ee0] user: drh branch: trunk, size: 17438)
2006-05-25
12:17
[c616a88eab] part of check-in [5031ffc665] Syntax errors override errors from the code generator, not the other way around. (CVS 3192) (check-in: [5031ffc665] user: drh branch: trunk, size: 17047)
2006-01-16
16:24
[036315207c] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 17056)
2005-11-29
03:13
[dae07fa155] part of check-in [058f317538] Make the OsFile structure opaque with its internal structure known only to the appropriate os_*.c implementation. Omit the os_unix.h and os_win.h include files. The crash tests are broken by this patch. (CVS 2791) (check-in: [058f317538] user: drh branch: trunk, size: 17211)
2005-03-29
03:10
[f320e98bcc] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 17220)
2005-03-15
02:04
[e6bda19cc9] part of check-in [24e8877352] Allow the database name in a DETACH statement to be quoted. Ticket #1151. (CVS 2386) (check-in: [24e8877352] user: drh branch: trunk, size: 16608)
2005-03-02
05:18
[3c951c8220] part of check-in [9b96078763] Print an error message and quit if the regression tests are run as root. Ticket #1153. (CVS 2366) (check-in: [9b96078763] user: drh branch: trunk, size: 16604)
2005-01-24
10:25
[5147d531ca] part of check-in [d5233e0747] Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: [d5233e0747] user: danielk1977 branch: trunk, size: 16457)
2005-01-23
13:14
[4f83c2edc4] part of check-in [6c631b86e5] ATTACH and DETACH cause prepared statements to expire. sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265) (check-in: [6c631b86e5] user: drh branch: trunk, size: 16449)
2005-01-21
15:52
[a16731cdd3] part of check-in [17122c7e8e] Final preparations for the 3.1.0 alpha release. (CVS 2255) (check-in: [17122c7e8e] user: drh branch: trunk, size: 16432)
11:55
[3391776495] part of check-in [9c4d0e13e8] Improve test coverage for minimum feature builds. (CVS 2254) (check-in: [9c4d0e13e8] user: danielk1977 branch: trunk, size: 16407)
04:25
[660ed5ed29] 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: 16075)
2004-11-23
10:13
[f39069efd4] part of check-in [6ccb589bd9] Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: [6ccb589bd9] user: danielk1977 branch: trunk, size: 15950)
2004-11-22
13:35
[a71117bab0] 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: 15635)
08:43
[bb0ff048b0] 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: 15336)
2004-11-04
14:47
[e305dd59a3] part of check-in [158a2d16a8] All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) (check-in: [158a2d16a8] user: drh branch: trunk, size: 15290)
04:42
[ff7fc16b45] part of check-in [c33b3a6137] All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: [c33b3a6137] user: drh branch: trunk, size: 15247)
2004-10-31
02:22
[6ad560eb3e] part of check-in [be661acfa8] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acfa8] user: drh branch: trunk, size: 14696)
2004-08-18
15:58
[feb2ce54e7] part of check-in [6b2b6b2dbd] Be more agressive about not creating or opening the TEMP database if there are no TEMP tables. (CVS 1891) (check-in: [6b2b6b2dbd] user: drh branch: trunk, size: 13980)
2004-08-01
03:52
[8fd75d2939] part of check-in [7ecff04a61] Fix a memory leak when the auxiliary data of a database structure is used. (CVS 1874) (check-in: [7ecff04a61] user: drh branch: trunk, size: 13994)
2004-06-19
00:16
[3acdffccbf] 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: 13994)
2004-06-09
00:48
[aed659e526] part of check-in [1086196460] Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) (check-in: [1086196460] user: drh branch: trunk, size: 13986)
2004-06-07
01:52
[1635022d7e] part of check-in [4f7c0961ad] Progress towards getting locking to work on windows. (CVS 1536) (check-in: [4f7c0961ad] user: drh branch: trunk, size: 13137)
2004-05-31
18:21
[5f7e21fce5] part of check-in [48226a7380] Get the attach.test working on windows. (CVS 1508) (check-in: [48226a7380] user: drh branch: trunk, size: 13069)
08:55
[cbc9c5286e] part of check-in [9029274b61] Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) (check-in: [9029274b61] user: danielk1977 branch: trunk, size: 13068)
08:26
[379d5b1c6b] part of check-in [b8ed812c92] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c92] user: danielk1977 branch: trunk, size: 13117)
2004-05-29
10:23
[0dd7cf9bf9] part of check-in [4feb4b9a71] Fix vacuum so that it works with blobs. (CVS 1490) (check-in: [4feb4b9a71] user: danielk1977 branch: trunk, size: 12919)
02:37
[e872e1cf3e] part of check-in [4060a37d0b] Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) (check-in: [4060a37d0b] user: danielk1977 branch: trunk, size: 13047)
2004-05-11
09:57
[cb9b884344] part of check-in [93deaf54c6] A different fix for the problem with opening existing files. See also check-in (1358). (CVS 1359) (check-in: [93deaf54c6] user: drh branch: trunk, size: 13039)
09:31
[3afaf8e3df] part of check-in [6d378cb7e7] Fix an offset problem in the meta values that was causing problems for many tests. (CVS 1357) (check-in: [6d378cb7e7] user: drh branch: trunk, size: 13039)
2004-05-10
23:29
[76f096f384] part of check-in [bc5a2dafa1] Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) (check-in: [bc5a2dafa1] user: drh branch: trunk, size: 13039)
2004-02-14
01:39
[ba8261d38d] part of check-in [41b6ad78a6] Disable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239) (check-in: [41b6ad78a6] user: drh branch: trunk, size: 13021)
2004-02-12
15:31
[09ff5eec8e] part of check-in [12c7a83f8e] Always reload the schema after a rollback. Ticket #594. (CVS 1229) (check-in: [12c7a83f8e] user: drh branch: trunk, size: 13016)
2003-07-18
01:25
[c26848402e] part of check-in [93a2c961b1] In the test scripts, do not try to delete files that are still open. Windows does not like it when you do. Ticket #397. (CVS 1055) (check-in: [93a2c961b1] user: drh branch: trunk, size: 12916)
2003-06-15
23:42
[eccea29379] part of check-in [c9734c2707] Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: [c9734c2707] user: drh branch: trunk, size: 12904)
2003-06-04
15:53
[71905b5e7a] part of check-in [fa10c6df5a] Adjust test cases to cope with the extra column returned by the database_list pragma. (CVS 1004) (check-in: [fa10c6df5a] user: drh branch: trunk, size: 12871)
12:31
[fa2fd071e5] part of check-in [4bfb30d20b] Disable the unreadable file test (attach-6.2) under windows because of problems in the OS. (CVS 1000) (check-in: [4bfb30d20b] user: drh branch: trunk, size: 12849)
2003-06-03
01:47
[771334395b] part of check-in [3e8889d7ce] Additional testing of the ATTACH command with bug fixes for the new problems that the tests found. (CVS 998) (check-in: [3e8889d7ce] user: drh branch: trunk, size: 12846)
2003-05-31
16:21
[f050eebbb7] part of check-in [7202d4f1a8] Tighter binding of views, triggers, and indices to their respective databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) (check-in: [7202d4f1a8] user: drh branch: trunk, size: 9924)
2003-05-17
19:23
[20b35533a5] part of check-in [2419137379] Additional attach testing. I now believe that ticket #317 was fixed by check-in (981). (CVS 985) (check-in: [2419137379] user: drh branch: trunk, size: 7843)
17:35
[ca8304e0f2] part of check-in [01398fb78b] Fix problems with TEMP indices that lead to corrupt databases. These problems were discovered while working on ticket #317. No sure yet if that ticket is fixed. (CVS 981) (check-in: [01398fb78b] user: drh branch: trunk, size: 6284)
2003-04-17
22:57
[b311c83e37] part of check-in [1e5e00fb73] Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (check-in: [1e5e00fb73] user: drh branch: trunk, size: 5018)
2003-04-05
16:56
[4912f001bf] part of check-in [51f515f28c] More testing of ATTACH and DETACH. (CVS 899) (check-in: [51f515f28c] user: drh branch: trunk, size: 4293)
03:42
Added: [93414915d0] part of check-in [7a0f8024a1] Begin testing the new ATTACH and DETACH commands. (CVS 898) (check-in: [7a0f8024a1] user: drh branch: trunk, size: 1537)