/ File History
Login

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

History of test/tclsqlite.test

2019-11-18
17:46
Add support for SQLITE_OPEN_NOFOLLOW. file: [c4a5f5af] check-in: [cb79c828] user: drh branch: trunk, size: 21444
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [47dded95] check-in: [27eb2236] user: drh branch: reuse-schema, size: 21490
2019-08-17
00:53
The SQLITE_DIRECTONLY flag, when added to sqlite3_create_function() prevents the function from being used inside a trigger or view. file: [f9acb831] check-in: [de767376] user: drh branch: trunk, size: 21424
2019-08-15
21:27
Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config" command in the TCL interface that can access that option as well as all the other sqlite3_db_config() boolean options. file: [f7bacdbe] check-in: [61b4bccd] user: drh branch: trunk, size: 21410
20:04
Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. file: [6c736855] check-in: [fc745845] user: drh branch: directonly, size: 21416
2019-03-21
17:13
Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. file: [7ea484c9] check-in: [b8e53608] user: dan branch: reuse-schema, size: 21468
2019-03-04
07:25
Merge latest trunk changes into this branch. file: [b30e975c] check-in: [97a9604d] user: dan branch: reuse-schema, size: 21427
2019-02-28
17:29
Add the new "bind_fallback" method to the "sqlite3" object in the TCL interface. file: [5a06962d] check-in: [c7f70b6d] user: drh branch: trunk, size: 21402
2019-02-27
16:38
Add the "-returntype" option to the "db function" Tcl method. file: [0037c0ca] check-in: [789a492b] user: dan branch: trunk, size: 19726
2019-02-14
21:04
Fix SQLITE_DBSTATUS_SCHEMA_USED so that it works with SQLITE_OPEN_SHARED_SCHEMA connections. file: [74cc8404] check-in: [d43b3c05] user: dan branch: reuse-schema, size: 17341
2018-10-08
18:58
Merge latest trunk changes into this branch. file: [049da602] check-in: [2ac72114] user: dan branch: reuse-schema, size: 17340
2018-09-19
15:08
Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. file: [dca8aa30] check-in: [2034fa80] user: drh branch: trunk, size: 17316
2018-01-03
19:03
Replace sqlite3_memdb_config() with sqlite3_deserialize(). Remove the "db memdb" command from the TCL interface, replacing it with "db serialize" and "db deserialize". file: [5337e889] check-in: [2f6e9df9] user: drh branch: memdb, size: 17143
13:20
Simplify the "sqlite3" command in the TCL interface. The filename is now optional. There is a new --memdb option with an argument that is the blob to which the database content should be initialized. file: [45462ee8] check-in: [47398ae7] user: drh branch: memdb, size: 17126
2017-08-09
20:35
Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. file: [d1fc2876] check-in: [a6256980] user: dan branch: reuse-schema, size: 17140
2017-06-26
21:08
Add the -withoutnulls option to the "db eval" method in the TCL interface. file: [c3d7ac94] check-in: [18f0616e] user: drh branch: trunk, size: 17116
16:13
Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. file: [464d8201] check-in: [cbe441b2] user: drh branch: unsetnull-option, size: 17226
2016-07-15
02:55
Merge fixes from trunk. Fix the tclsqlite.test script. file: [1d73b920] check-in: [d2b1fa55] user: drh branch: sqlite3_trace_v2, size: 16092
2016-06-13
12:34
Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. file: [cf0d0a3f] check-in: [d362ba15] user: drh branch: trunk, size: 16082
2016-03-16
01:16
Merge all recent enhancements from trunk. file: [e1306001] check-in: [6a7ee04b] user: drh branch: sessions, size: 15418
2016-03-14
18:34
Many more test cases fixed. Only a few remain. file: [c6d9f546] check-in: [99b9d7ee] user: drh branch: see-testing, size: 15407
2015-03-17
18:54
Merge all recent trunk enhancements into the sessions branch. file: [7179b4e0] check-in: [1d1c57c3] user: drh branch: sessions, size: 15454
2015-03-13
08:31
Extra tests for commit [0f250957]. file: [7fb86644] check-in: [5aa522dc] user: dan branch: trunk, size: 15443
2012-10-09
14:58
Merge the latest trunk changes, especially the ORDER BY optimizer enhancements but also other fixes, onto the sessions branch. file: [a7308276] check-in: [f1fbb8c5] user: drh branch: sessions, size: 15457
2012-10-04
22:45
Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. file: [2052ca66] check-in: [17644c0e] user: drh branch: sessions-3.7.14, size: 15457
2012-10-03
11:11
Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. file: [952b7728] check-in: [9bf64b66] user: drh branch: branch-3.7.14, size: 15446
11:02
Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. file: [37a61c2d] check-in: [c1f10a26] user: drh branch: trunk, size: 15446
2012-09-28
13:05
Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. file: [02b2c268] check-in: [6ca8eae1] user: drh branch: sessions, size: 15168
2012-09-10
23:44
Correct two duplicated test names. file: [a3d2df21] check-in: [ced49974] user: mistachkin branch: trunk, size: 15157
2012-01-14
13:50
Update sessions branch with latest changes from trunk. file: [2f2aa887] check-in: [01c84fd3] user: dan branch: sessions, size: 15168
2012-01-13
16:16
Add the -uri option to the usage comment that is printed by the "sqlite3" TCL command when an unknown command-line option is supplied. file: [1597d353] check-in: [7987e285] user: drh branch: trunk, size: 15157
2011-08-26
19:20
Merge the latest trunk changes into the sessions branch. file: [d5298750] check-in: [eb036d6f] user: drh branch: sessions, size: 15153
2011-08-18
17:47
Ensure that the Tcl "db onecolumn" command returns an empty string if the SELECT statement returns zero rows. file: [5ebcbb0d] check-in: [928bcaf0] user: dan branch: trunk, size: 15142
2011-03-03
20:06
Add the experimental sqlite3_transaction_hook() API. file: [550f2268] check-in: [093d8cd8] user: dan branch: sessions, size: 14962
2011-03-01
18:42
Add the experimental sqlite3_preupdate_hook() API. file: [1ce9b634] check-in: [6145d7b8] user: dan branch: sessions, size: 14944
2010-06-07
17:47
Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file. file: [8c154101] check-in: [7c33eb5a] user: dan branch: trunk, size: 14933
2010-04-28
14:42
Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to wal.h. file: [013133fa] check-in: [bbc38511] user: drh branch: wal, size: 14929
2010-04-19
18:03
Add the sqlite3_log_hook() interface for scheduling checkpoints. file: [7378a4e7] check-in: [9bda6014] user: dan branch: wal, size: 14929
2009-10-13
18:38
Update the TCL wrapper to provide a non-NULL objProc pointer to the Tcl_NRCreateCommand() interface. The TCL gurus say this is needed to support legacy TCL extensions. file: [bf4227eb] check-in: [1b3cfa01] user: drh branch: trunk, size: 14919
2009-03-16
13:19
Add the sqlite3_unlock_notify() API. (CVS 6348) file: [8b1150d0] check-in: [b649a6cc] user: danielk1977 branch: trunk, size: 14838
2009-02-04
22:46
Add "backup" and "restore" methods to the TCL interfaces and test cases to exercise those methods. (CVS 6260) file: [413a8a88] check-in: [e420a3ce] user: drh branch: trunk, size: 14815
2009-01-02
17:33
Modify the (transaction) method of the tcl interface to use savepoints. This makes nested calls to (transaction) work more intuitively. (CVS 6101) file: [30636c31] check-in: [f047758d] user: danielk1977 branch: trunk, size: 14806
2008-10-09
14:45
Minor cleanup of the new "status" command on the TCL bindings. (CVS 5783) file: [001682e3] check-in: [ec01bd72] user: drh branch: trunk, size: 12208
2008-09-09
12:31
Calling sqlite3_create_function with nArg==(-1) does not override prior calls on the same function name with nArg>=0. Ticket #3345. Add the new -argcount option to the "function" method in the TCL interface. (CVS 5684) file: [b2074cf3] check-in: [5aa5b804] user: drh branch: trunk, size: 12200
2008-09-03
00:43
Add support for SQLITE_OPEN_FULLMUTEX. (CVS 5669) file: [9689ded2] check-in: [f2f361a5] user: drh branch: trunk, size: 12186
2008-08-29
15:54
Modify tclsqlite.test so that it works reliably with tcl 8.5.4. (CVS 5640) file: [401358dc] check-in: [790d329f] user: danielk1977 branch: trunk, size: 12173
2008-08-25
19:09
Fix obscure permutation test problems. (CVS 5611) file: [642869f9] check-in: [aa92a1be] user: drh branch: trunk, size: 12165
2008-07-10
17:52
Add the SQLITE_OPEN_NOMUTEX flag. Used for opening connections that are not protected by an internal mutex. (CVS 5387) file: [aa178180] check-in: [7e58b787] user: danielk1977 branch: trunk, size: 12128
2008-04-28
13:02
Changes to test scripts to accommodate different architectures and different versions of Tcl. (CVS 5057) file: [3dfb48f4] check-in: [8eb2c07c] user: drh branch: trunk, size: 12101
2007-10-23
08:17
Fix an error message in the tcl interface. (CVS 4503) file: [3fac87cb] check-in: [2449e080] user: danielk1977 branch: trunk, size: 12141
2007-09-12
17:01
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [c7feea19] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 11893
2007-09-01
06:51
Fix for registration of non-default vfs objects. (CVS 4360) file: [a868898e] check-in: [5f48fb95] user: danielk1977 branch: trunk, size: 11814
2007-08-31
14:31
Convert the TCL interface to use sqlite3_open_v2 (CVS 4352) file: [3addd6a8] check-in: [3434b7a9] user: drh branch: trunk, size: 11683
2007-06-19
23:01
Change the TCL bindings so that @aaa always treats the variable aaa as a bytearray and binds the value as a BLOB. This change is backwards compatible since the $ behavior is unchanged and @ was not accepted until the current round of changes. (CVS 4094) file: [593f3b30] check-in: [6f7d55ac] user: drh branch: trunk, size: 11698
17:15
In the TCL bindings, if a TCL variable has a bytearray representation and the host parameter starts with @ instead of $, then always store the content as a BLOB not as a string even if a string representation is also available. (CVS 4092) file: [649d4cec] check-in: [dcb104bd] user: drh branch: trunk, size: 11610
2007-05-01
17:49
First approximation of incremental blob IO API. (CVS 3892) file: [726c301d] check-in: [c444836e] user: danielk1977 branch: trunk, size: 10970
2006-10-24
11:26
Fix a bad variable reference. The reference is actually in unreachable code and is therefore harmless. The fix is to remove the code. (CVS 3483) file: [0089f84f] check-in: [46b91807] user: drh branch: version_2, size: 3384
2006-09-01
15:49
Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) file: [51334389] check-in: [bedbac54] user: drh branch: trunk, size: 10952
2006-07-17
00:02
Add the "interrupt" method to the TCL interface. Ticket #1889. (CVS 3332) file: [e7f7b891] check-in: [b0d19e57] user: drh branch: trunk, size: 10943
2006-07-06
17:08
Make the sqlite3_enable_load_extension() interface accessible from the TCL bindings. (CVS 3321) file: [e1ae0280] check-in: [ce96b890] user: drh branch: trunk, size: 10932
2006-02-09
16:52
Back out check-in (3058) - it breaks too much application code. (CVS 3063) file: [93c39941] check-in: [731f1e32] user: drh branch: trunk, size: 10909
2006-02-06
21:34
Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) file: [1b9edb34] check-in: [7940a590] user: drh branch: trunk, size: 10927
2006-01-24
10:58
General test coverage improvements. (CVS 3022) file: [96f5dbba] check-in: [153940af] user: danielk1977 branch: trunk, size: 10917
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [9b5c4a09] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 10740
2006-01-05
15:50
Move TCL interface for sqlite3_release_memory() and sqlite3_soft_heap_limit() out of tclsqlite.c and into test1.c. Update the TCL interface documention to describe the "exists" method. (CVS 2862) file: [2c4b5fb2] check-in: [98194a45] user: drh branch: trunk, size: 10687
2005-12-20
09:19
Add simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837) file: [19578d32] check-in: [c2c52854] user: danielk1977 branch: trunk, size: 10728
2005-12-16
06:54
Add the sqlite3_rollback_hook() API. Still requires further testing. (CVS 2823) file: [26ee144c] check-in: [3baa3ff3] user: danielk1977 branch: trunk, size: 10712
2005-12-12
06:53
Fix minor malloc() related problems and add sqlite3_soft_heap_limit() stubs. (CVS 2814) file: [9890d58c] check-in: [1637f379] user: danielk1977 branch: trunk, size: 10684
2005-12-10
21:19
Add the "exists" method to the TCL interface. (CVS 2813) file: [07729a3b] check-in: [8a355d7a] user: drh branch: trunk, size: 10659
2005-08-29
23:00
Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) file: [2da3e4b3] check-in: [ed2ca087] user: drh branch: trunk, size: 10441
2005-08-02
17:15
Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) file: [a8d9afe6] check-in: [68dd0ed5] user: drh branch: trunk, size: 10432
12:21
Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) file: [2679b0fa] check-in: [a5ce6c58] user: drh branch: trunk, size: 8598
2005-06-26
17:55
Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing BLOB values to be transferred correctly. Ticket #1304. (CVS 2530) file: [faa15080] check-in: [514aaab3] user: drh branch: trunk, size: 8585
2005-05-05
10:30
In the TCL interface, user-defined functions preserve the datatype returned by the Tcl procedure. (CVS 2453) file: [75937333] check-in: [99dcba1f] user: drh branch: trunk, size: 8262
2005-04-03
23:54
Apply Tcl 'nullvalue' patch from Stefan Finzel. (CVS 2441) file: [7112be2a] check-in: [9906ae37] user: danielk1977 branch: trunk, size: 7888
2005-02-26
17:31
Fix an assertion fault that can occur while autovacuuming a corrupt database file. Add the SQLITE_OMIT_COMPLETE compile-time parameter. (CVS 2361) file: [4ac312b4] check-in: [bb0e7e38] user: drh branch: trunk, size: 7534
2005-01-24
00:28
Change the TCL interface so that it can cache VMs and reuse them without recompiling. But for now leave the cache turned off by default. (CVS 2269) file: [4b26cad2] check-in: [8db6bfef] user: drh branch: trunk, size: 7501
2005-01-12
12:44
Tests to improve coverage of main.c. (CVS 2202) file: [f467d906] check-in: [4e28c82a] user: danielk1977 branch: trunk, size: 7502
2004-12-17
15:41
Add 'copy' method for tcl interface. Behaves similar to shell .import or COPY statment in 2.x. (CVS 2167) file: [8b9dae3b] check-in: [a9311d9d] user: tpoindex branch: trunk, size: 7443
2004-11-23
10:13
Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) file: [861464af] check-in: [6ccb589b] user: danielk1977 branch: trunk, size: 7270
2004-11-03
16:27
Update tests to work even if some features of the library are disabled. (CVS 2050) file: [5e262df8] check-in: [b11fc9b3] user: drh branch: trunk, size: 7196
2004-09-13
13:46
Remove the encode/decode from the version 3.0 source tree. (CVS 1959) file: [1288e627] check-in: [c1f1320b] user: drh branch: trunk, size: 6979
2004-09-07
13:20
Fix the onecolumn method in the TCL interface so that it works the same as the eval method in all ways except for returning just the first value in the result set. (CVS 1944) file: [de670bec] check-in: [f323e4f8] user: drh branch: trunk, size: 6339
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [d84b91f5] check-in: [e97c3313] user: drh branch: trunk, size: 5946
16:02
Add support for named wildcards in SQL statements. (CVS 1897) file: [7f2322f9] check-in: [d3be0b7c] user: drh branch: trunk, size: 5252
2004-07-26
12:24
Fix problems for 64-bit machines and when SQLITE_OMIT_AUTHORIZATION is defined. (CVS 1868) file: [9bb1ee91] check-in: [e3cad1ab] user: drh branch: trunk, size: 5248
2004-07-19
19:30
Fix for ticket #813. (CVS 1820) file: [109ed5fb] check-in: [0cc612f8] user: drh branch: version_2, size: 3357
17:25
Store schema cookies on the TEMP database. Ticket #807. (CVS 1817) file: [0ef39b02] check-in: [c6c13dc4] user: drh branch: trunk, size: 5207
2004-06-29
12:39
Improved test coverage of tclsqlite.c (CVS 1761) file: [7a773d27] check-in: [008e57dc] user: drh branch: trunk, size: 5182
2004-06-21
06:50
Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) file: [2517b10e] check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 2959
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: [a69e99b9] check-in: [d705d051] user: drh branch: trunk, size: 2960
2004-06-10
10:51
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1563) file: [2ff5abfd] check-in: [518d82d3] user: danielk1977 branch: trunk, size: 2964
2004-06-09
09:55
Some progress on user-defined collation sequences. (CVS 1544) file: [ab5e5c5a] check-in: [c634e71f] user: danielk1977 branch: trunk, size: 2946
2004-06-02
00:41
Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523) file: [853e4372] check-in: [b53640ed] user: drh branch: trunk, size: 2929
2004-02-25
22:51
Add comments and prototype for experimental sqlite_last_statement_changes() API function. Also, allow function to be called from tcl. (CVS 1273) file: [a684fc19] check-in: [ca99920b] user: rdc branch: trunk, size: 3328
2004-02-11
02:18
Pass all (relevant) regression tests when using the codec. (CVS 1223) file: [602c7317] check-in: [5200e9ed] user: drh branch: trunk, size: 3304
2004-02-01
01:22
Fix the handling of -init option to the sqlite shell. Ticket #568. Also add hooks for encrypting the database. (CVS 1206) file: [97233f45] check-in: [3c796de8] user: drh branch: trunk, size: 3300
2004-01-15
02:44
Reinsert the experimental sqlite_commit_hook() API. (CVS 1179) file: [6921477a] check-in: [72bc84f2] user: drh branch: trunk, size: 3143
2003-10-23
15:27
Fix progress test error 1-2 (CVS 1115) file: [f141303e] check-in: [c3a49502] user: peter branch: trunk, size: 3132
2003-08-23
22:40
Add a "pk" column to the table_info pragma which is true for each column that is part of the primary key. Add a "foreign_key_list" pragma that gives information about all foreign keys for a table. Both changes are experimental. (CVS 1081) file: [964fd2f6] check-in: [5232b066] user: drh branch: trunk, size: 3120
2003-08-19
14:31
Add the "onecolumn" method to the TCL language bindings. (CVS 1076) file: [751b358b] check-in: [c7b4c28f] user: drh branch: trunk, size: 3112
2003-04-23
12:25
Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a "trace" method to the TCL interface. (CVS 929) file: [d9bdfc0a] check-in: [6289b863] user: drh branch: trunk, size: 2648
2003-04-22
20:30
Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) file: [42b8f014] check-in: [c675a550] user: drh branch: trunk, size: 2666
2003-04-03
15:46
Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896) file: [62773bcb] check-in: [5efbf623] user: drh branch: trunk, size: 2654
2003-03-30
19:17
Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 889) file: [4a69bd22] check-in: [b6d6e07f] user: drh branch: trunk, size: 2629
2003-01-31
17:21
The sqlite_exec() function now returns SQLITE_AUTH when authorization fails. Ticket #231. (CVS 857) file: [f650195b] check-in: [d93c1aeb] user: drh branch: trunk, size: 2643
2002-09-14
13:47
Do not put a write lock on the main database file when writing to a temporary table. (CVS 750) file: [2441ab13] check-in: [3f253afe] user: drh branch: trunk, size: 2632
2002-06-25
19:31
Add the sqlite_open_aux_file() API. (CVS 646) file: [6f4b9760] check-in: [332164d6] user: drh branch: trunk, size: 2622
2002-04-12
10:08
Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) file: [79deeffd] check-in: [6e71493b] user: drh branch: trunk, size: 2607
2002-01-16
21:00
Added the last_insert_rowid API function. Improved documentation of the random ROWID algorithm. (CVS 349) file: [ca8dd89b] check-in: [f74d61aa] user: drh branch: trunk, size: 2598
2002-01-15
18:39
Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) file: [9cbac5a3] check-in: [f8a026a3] user: drh branch: trunk, size: 2579
2001-10-22
02:58
More changes for 2.0.7. (CVS 293) file: [feca0f2b] check-in: [f8328a5f] user: drh branch: trunk, size: 2551
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [a57bb478] check-in: [4e926efe] user: drh branch: trunk, size: 1808
2001-04-03
16:53
Bug fixes from Oleg Oleinick (CVS 195) file: [d2aa5592] check-in: [1f0197d5] user: drh branch: trunk, size: 2351 Added