/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of src/test8.c

2017-09-09
19:41
Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. file: [3f7d0cc4] check-in: [34c8e952] user: dan branch: vtab-extra-ops, size: 41716
2016-07-28
17:11
Make sure the SQLITE_TCLAPI macro is always defined and use it for all callback functions that must interface with the Tcl C API. file: [4f490472] check-in: [f2f1323c] user: mistachkin branch: callbackConv, size: 41691
14:37
Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. file: [33cefbf2] check-in: [e8be3dfe] user: mistachkin branch: callbackConv, size: 41663
2015-12-16
22:06
Fix some more harmless compiler warnings. file: [fa262391] check-in: [18f531e1] user: mistachkin branch: msvcWarn, size: 41588
2015-11-26
19:33
Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan. file: [b3a41629] check-in: [116b2064] user: dan branch: vtab-colused, size: 41573
2015-11-24
17:44
Merge latest trunk changes with this branch. file: [85b8c6a0] check-in: [99222bb3] user: dan branch: vtab-like-operator, size: 40551
01:17
Add a clarifying comment to the virtual table test module 'test8'. file: [697c9c84] check-in: [e92f97a6] user: mistachkin branch: trunk, size: 40325
2015-11-23
21:09
Add experimental support for LIKE, GLOB and REGEXP to the virtual table interface. file: [59d91e1f] check-in: [277a5b40] user: dan branch: vtab-like-operator, size: 40123
2015-01-19
00:35
Eliminate all use of sprintf(), strcpy() and strcat() from test logic because OpenBSD hates those functions. file: [610e3d52] check-in: [10321910] user: drh branch: trunk, size: 39897
2015-01-12
19:49
Harmless compiler warning fixes for 'testfixture' and the miscellaneous extensions when built with the MSVC makefile. file: [df8dd4c9] check-in: [923fd660] user: mistachkin branch: msvcW4, size: 39866
2015-01-01
23:02
Add logic to releasetest.tcl that detects -fsanitize=undefined errors. Fix a few false-positivies that come up when running the sanitize=undefined test. file: [bf3bad9a] check-in: [2835e79a] user: drh branch: trunk, size: 39854
2014-05-19
15:16
Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. file: [610ec4c5] check-in: [17349a49] user: drh branch: safer-malloc, size: 39846
2014-01-24
22:58
Fixes for various clang warnings. file: [54ccd7b1] check-in: [87bf6063] user: drh branch: trunk, size: 39836
2013-10-05
20:18
Fix an issue in the test8.c test module that arises because of the change to PRAGMA index_list(). Remove an unused local variable. file: [c7aab1d9] check-in: [029430c5] user: drh branch: row-size-est, size: 39834
2013-04-29
03:09
More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. file: [7ee77ea5] check-in: [05ba5e23] user: mistachkin branch: winOsTrace, size: 39806
2013-04-25
14:59
Move the test_spellfix.c module to ext/misc/spellfix.c. file: [f7e729e3] check-in: [de556add] user: drh branch: std-ext, size: 39821
2013-01-25
19:11
Fix the test_spellfix.c extension so that it can be made loadable at run-time. Add spellfix to the shell when building using the build-shell.sh script. file: [58ea1d96] check-in: [7813b17d] user: drh branch: trunk, size: 40328
2012-07-16
22:16
Fix compiler warnings about unused code in spellfix. Fix the editDist3Core() routine to return the matchlen in characters instead of bytes. file: [8bcce65e] check-in: [f96d4e7b] user: drh branch: spellfix-matchlen, size: 40326
2012-07-13
16:15
Update test_spellfix.c with latest changes. file: [c4bcd39c] check-in: [cba2a658] user: dan branch: trunk, size: 40371
2012-07-12
19:43
Add the "matchlen" column to the spellfix virtual table. file: [6efb8bab] check-in: [4a582c4d] user: dan branch: spellfix-matchlen, size: 40380
2012-05-16
14:29
Return SQLITE_MISUSE if an application attempts to register a virtual table module with the same name as an existing module. file: [235f1d19] check-in: [ea2cd55e] user: dan branch: shared-schema, size: 39813
2012-04-19
18:04
Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in tclsqlite.c and in the FTS4 module. file: [5ecbffe6] check-in: [3281972e] user: drh branch: trunk, size: 39625
2012-03-20
03:10
Fix out-of-bounds array references in the "echo" virtual table module used for testing. No changes to the SQLite core. file: [61b41d79] check-in: [7b449b30] user: drh branch: trunk, size: 39615
2011-10-29
15:29
Add a test for [48f29963] that does not depend on FTS. file: [99f70341] check-in: [fb15f545] user: dan branch: trunk, size: 39621
2010-07-24
16:34
Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). file: [6b1d1291] check-in: [ac1f37a6] user: drh branch: malloc-enhancement, size: 38007
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [f959db9a] check-in: [f6c045f6] user: drh branch: trunk, size: 38004
2009-04-29
11:50
Fix a case in where.c where a crash can follow a malloc failure. Also modify test code in test8.c to check a return code that was being dropped (causing a test in vtab_err.test to fail). (CVS 6567) file: [34719910] check-in: [9664e2b6] user: danielk1977 branch: trunk, size: 38068
2009-04-21
09:02
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) file: [b1061548] check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 38063
2009-04-08
15:45
Remove a pair unnecessary conditions from printf.c. The "db" parameter is now required for sqlite3MPrintf(). (CVS 6471) file: [dd7fc453] check-in: [6fe8b5d7] user: drh branch: trunk, size: 38058
2008-08-31
00:29
Changed to used sqlite3_snprintf instead of snprintf (test code only). (CVS 5648) file: [36374394] check-in: [d68791e3] user: shane branch: trunk, size: 38078
2008-08-20
14:49
Add the pcache module from the experimental branch. Also change things so that most of the built-in SQL functions are kept in single static hash-table, rather than creating and populating a separate hash table for each open database connection. (CVS 5566) file: [2f821eab] check-in: [cb494e10] user: danielk1977 branch: trunk, size: 38076
2008-08-12
14:48
Fix warnings and a compilation error in test code. (CVS 5556) file: [7da15177] check-in: [80c129e6] user: danielk1977 branch: trunk, size: 38104
2008-08-05
21:36
Remove a reference to snprintf() in test8.c. (CVS 5538) file: [8cd3382b] check-in: [32d32b74] user: drh branch: trunk, size: 38096
2008-08-01
17:51
Also test that setting sqlite3_vtab.zErrMsg works from within the xRename method. (CVS 5520) file: [0517adad] check-in: [4f4a9cca] user: danielk1977 branch: trunk, size: 38076
17:37
Test that virtual table methods xBestIndex, xOpen, xFilter, xNext, xColumn, xRowid, xUpdate, xSync and xBegin can all return error messages using the sqlite3_vtab.zErrMsg variable. (CVS 5519) file: [f869497d] check-in: [007359b7] user: danielk1977 branch: trunk, size: 37991
2008-07-28
19:34
Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) file: [ae09a70c] check-in: [e48f9697] user: drh branch: trunk, size: 36279
2008-07-23
18:17
Read the sqlite3_vtab.zErrMsg after each call to a virtual table method and transfer any error into the database connection. Fix the fts2.test and fts3.test scripts to that they return silently rather than failing the test sequence if the appropriate FTS implementation is unavailable. (CVS 5463) file: [cc541736] check-in: [e2c6771d] user: drh branch: trunk, size: 36274
2008-07-07
14:50
Additional test cases added on the sqlite3_create_function() interface. (CVS 5349) file: [3b85c05b] check-in: [4e941f3d] user: drh branch: trunk, size: 36168
2008-06-20
14:59
Add a mode to the sqlite3_test_control() interface to register hooks called at the beginning and end of "benign malloc failure" blocks. This allows malloc() failure testing to be done using public APIs only. (CVS 5254) file: [7230aff5] check-in: [56c8af14] user: danielk1977 branch: trunk, size: 36237
2008-06-16
14:19
Fix a problem with the incremental blob API. sqlite3_blob_open() was always reading the data for the leftmost column of the row that the opened blob was stored in. If this column happened to contain a (the) large blob, sqlite would make a large memory allocation to read the data into. Which defeats the purpose of using incremental blobs. (CVS 5222) file: [de8b2d25] check-in: [1b9478da] user: danielk1977 branch: trunk, size: 36289
2008-05-13
13:27
Make the benign-fault setting recursive. Make all malloc failures during a rollback benign since there is nothing we can do about them. (CVS 5128) file: [bfebbeed] check-in: [a9d1d931] user: drh branch: trunk, size: 36271
2008-05-05
13:23
Fix a couple of minor problems with transactions in virtual tables. (CVS 5081) file: [beca5318] check-in: [2275fc6e] user: drh branch: trunk, size: 36269
2008-04-28
20:27
Add test cases to verify that multiple virtual tables can be updated within a trigger and that xSync, xCommit, and xRollback are never called except following xBegin or xCreate. Ticket #3083. (CVS 5064) file: [a7fdf75d] check-in: [76175199] user: drh branch: trunk, size: 36281
2008-03-17
09:36
Return an error when an xBestIndex() method indicates that it intends to use the value of an unusable constraint. Related to #2998. (CVS 4867) file: [7933b27f] check-in: [ffd47027] user: danielk1977 branch: trunk, size: 35261
2008-02-13
18:25
Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) file: [25e127f0] check-in: [990237e2] user: danielk1977 branch: trunk, size: 35071
2008-01-22
21:30
Add the fault injector module in fault.c. Use it as a basis for memory allocation failure testing. (CVS 4742) file: [cab3f576] check-in: [1a335e18] user: drh branch: trunk, size: 34862
2007-12-13
21:54
Change all instances of "it's" in comments to either "its" or "it is", as appropriate, in case the comments are ever again read by a pedantic grammarian. Ticket #2840. (CVS 4629) file: [6399d2f0] check-in: [4e91a267] user: drh branch: trunk, size: 34766
2007-09-03
15:03
Fix a problem in hash.c when replacing entries in tables configured with copyKey==0. (CVS 4375) file: [f113aa37] check-in: [a19d3a73] user: danielk1977 branch: trunk, size: 34775
11:51
Add a module-destructor to the echo module (test8.c) to improve code coverage. (CVS 4372) file: [146cb2c2] check-in: [e3dd3651] user: danielk1977 branch: trunk, size: 34609
2007-08-29
12:31
Modifications to the malloc failure tests to test transient and persistent failures. (CVS 4321) file: [88e033ae] check-in: [e38ef81b] user: danielk1977 branch: trunk, size: 34336
2007-08-25
13:37
Update the rest of the malloc failure test scripts to use the new interface. (CVS 4296) file: [a91b8d28] check-in: [b076e165] user: danielk1977 branch: trunk, size: 33625
2007-08-23
02:47
Improvements to memory leak detection. The --backtrace=NNN option is now recognized by tester.tcl. Memory leak summaries are automatically written to the file ./memleak.txt and each leak is tagged with the test in which it occurred. The quick.test script runs on Linux with no errors and no leaks. (CVS 4273) file: [e6a543c8] check-in: [21f6b310] user: drh branch: trunk, size: 33493
2007-08-21
10:44
Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) file: [4bf571b8] check-in: [fbbd5bda] user: drh branch: trunk, size: 33493
2007-08-16
11:36
Fix some more small problems introduced by recent refactoring. (CVS 4235) file: [719c2846] check-in: [5e2795d0] user: danielk1977 branch: trunk, size: 33517
10:09
More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [0dc64e1a] check-in: [77b16713] user: danielk1977 branch: trunk, size: 33454
04:30
Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) file: [95c9e063] check-in: [deb7ecd6] user: drh branch: trunk, size: 33419
2007-07-20
00:35
Fix a memory leak in the Rename method of the echo test virtual table. No changes to the core. (CVS 4166) file: [27a61c60] check-in: [e5c132ff] user: drh branch: trunk, size: 33376
2007-06-27
15:53
Allow ALTER TABLE on virtual tables. (CVS 4142) file: [4f0a8624] check-in: [37d1f9f3] user: danielk1977 branch: trunk, size: 33362
2007-04-18
17:04
Better handle malloc() failures in the "echo" virtual table test module. (CVS 3855) file: [c3c4aeea] check-in: [6881f921] user: danielk1977 branch: trunk, size: 31455
2007-03-30
14:56
Coverage improvements for where.c. (CVS 3764) file: [2af036d7] check-in: [7e0aa964] user: danielk1977 branch: trunk, size: 31381
2007-01-03
23:37
Clean up memory leaks and uninitialized variables detected by valgrind. Identify all tests where we deliberately derefence freed memory by adding a "-misuse" tag. (CVS 3550) file: [628ec89f] check-in: [70a86270] user: drh branch: trunk, size: 31018
2006-10-08
18:56
Website changes for version 3.3.8. Remove a C++-ism from test8.c. (CVS 3468) file: [48b7ac78] check-in: [465ce5b2] user: drh branch: trunk, size: 30994
2006-09-11
00:34
Add a rudimentary tokenizer and parser to FTS1 for parsing the module arguments during initialization. Recognized arguments include a tokenizer selector and a list of virtual table columns. (CVS 3403) file: [cdde31e4] check-in: [227dc3fe] user: drh branch: trunk, size: 30984
2006-09-10
17:31
Add pzErr parameters to the xConnect and xCreate methods of virtual tables in order to provide better error reporting. This is an interface change for virtual tables. Prior virtual table implementations will need to be modified and recompiled. (CVS 3402) file: [f86da05e] check-in: [f44b8bae] user: drh branch: trunk, size: 30940
2006-07-08
18:09
Add tests and minor fixes to the xFindFunction method of virtual tables. (CVS 3323) file: [56d891ac] check-in: [3c4233e0] user: drh branch: trunk, size: 30878
17:06
Allow virtual table implementations to overload function that use a column of the virtual table as their first argument. Untested. (CVS 3322) file: [32b800e7] check-in: [12cc7af4] user: drh branch: trunk, size: 29154
2006-06-26
19:10
Remove the sqlite3_module.zName field which was used only for debugging. (CVS 3297) file: [6a4d1bd4] check-in: [74a3961f] user: drh branch: trunk, size: 29084
2006-06-24
11:51
A few more test cases to improve coverage of virtual table module related code. (CVS 3292) file: [257b310d] check-in: [255aa912] user: danielk1977 branch: trunk, size: 29133
09:34
Add tests to improve coverage of vtab.c. (CVS 3291) file: [3e0d66d6] check-in: [0c5f4ee3] user: danielk1977 branch: trunk, size: 29017
06:36
Clean up and clarify code in test8.c. (CVS 3289) file: [c7aa1d06] check-in: [4acf7594] user: danielk1977 branch: trunk, size: 27682
2006-06-23
14:32
Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) file: [054989bf] check-in: [a56bfa56] user: danielk1977 branch: trunk, size: 23184
11:34
Fix some memory leaks that occur when malloc() fails. (CVS 3286) file: [9ea0fd17] check-in: [b56cc035] user: danielk1977 branch: trunk, size: 23157
08:05
Add tests and fixes for handling malloc() failures related to the virtual table feature. (CVS 3285) file: [e09bf265] check-in: [5d1d9071] user: danielk1977 branch: trunk, size: 23114
2006-06-22
09:53
Test the handling of errors in virtual table methods. (CVS 3284) file: [b8014836] check-in: [51b729d9] user: danielk1977 branch: trunk, size: 22810
2006-06-21
16:02
Add the database name to the parameters passed to virtual table module xCreate and xConnect methods. (CVS 3282) file: [d584dc94] check-in: [2d280578] user: danielk1977 branch: trunk, size: 21856
13:21
Add the table name to the arguments passed to the virtual table methods xCreate/xConnect. (CVS 3281) file: [58134b50] check-in: [7dc36d1c] user: danielk1977 branch: trunk, size: 21856
07:02
Fix a problem with virtual tables and joins. (CVS 3278) file: [03563ba0] check-in: [643e63e5] user: danielk1977 branch: trunk, size: 21856
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [ec03e990] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 21752
2006-06-19
12:02
Avoid returning MISUSE when sqlite is called recursively by an xBestIndex callback. (CVS 3274) file: [ac1def5e] check-in: [4339e1bf] user: danielk1977 branch: trunk, size: 21602
2006-06-17
09:39
Add tests (and fixes) for the virtual table transaction interface. (CVS 3265) file: [9641e41a] check-in: [8a5b121f] user: danielk1977 branch: trunk, size: 20703
2006-06-16
06:17
Arrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259) file: [75d9ef60] check-in: [afa39a46] user: danielk1977 branch: trunk, size: 18959
2006-06-15
15:38
Add column_value, declare_vtab and create_module to the function table used by dynamic extensions. (CVS 3256) file: [9579de46] check-in: [25c47508] user: danielk1977 branch: trunk, size: 18839
10:41
Add tests (and modify test code) for writing to virtual tables. (CVS 3253) file: [f3082601] check-in: [6380a9b1] user: danielk1977 branch: trunk, size: 18648
07:29
Simple tests and fixes for writing to virtual tables. (CVS 3252) file: [e88baeff] check-in: [88fa510e] user: danielk1977 branch: trunk, size: 19248
04:28
Add void* argument to sqlite3_create_module to replace sqlite3_module.pAux. (CVS 3251) file: [c8da12c2] check-in: [470a3a0b] user: danielk1977 branch: trunk, size: 19160
2006-06-14
23:43
Changes to test8.c to support UPDATE operations on xUpdate. (CVS 3250) file: [2f38a6c2] check-in: [9e96511f] user: drh branch: trunk, size: 19204
22:07
Bug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249) file: [e923b74e] check-in: [c996185a] user: drh branch: trunk, size: 17094
15:16
Add xUpdate method to the echo test module. Currently untested. (CVS 3246) file: [a698ff6a] check-in: [676de55b] user: danielk1977 branch: trunk, size: 16929
10:55
Add code to test8.c to check that the correct idxNum value is passed to the xFilter method. (CVS 3241) file: [4ef86f83] check-in: [77bcaf99] user: danielk1977 branch: trunk, size: 14846
10:47
Fix typo in test8.c. (CVS 3240) file: [cbf59c05] check-in: [75be7d49] user: danielk1977 branch: trunk, size: 14222
07:41
Add a test case for ORDER BY using the echo module. (CVS 3237) file: [0ad60b5e] check-in: [f459f034] user: danielk1977 branch: trunk, size: 14510
06:58
Change the pModule parameter of the xCreate and xConnect methods to a void*. (CVS 3236) file: [06c0a7b6] check-in: [3ffa51b5] user: danielk1977 branch: trunk, size: 13706
06:31
Add tests for error conditions surrounding the creation/connection of virtual tables. (CVS 3235) file: [f91c78d8] check-in: [5e592c42] user: danielk1977 branch: trunk, size: 13815
2006-06-13
23:51
The echo module test is now running. Added the tclvar module test but have not yet done anything with it. (CVS 3234) file: [d21b301a] check-in: [29199eee] user: drh branch: trunk, size: 13725
15:00
Add the tentative sqlite3_allocate_queryplan() API. (CVS 3228) file: [34b04bd8] check-in: [7a3e97f7] user: danielk1977 branch: trunk, size: 13670
14:16
Add simple tests for the xFilter and xBestIndex methods. (CVS 3227) file: [61d89b51] check-in: [0f4657ea] user: danielk1977 branch: trunk, size: 13402
10:24
Add implementations for opcodes required for linear scans of virtual tables. (CVS 3223) file: [d29427a0] check-in: [1f20e183] user: danielk1977 branch: trunk, size: 8515
04:11
Bugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory in the Destroy() method of the echo module. (CVS 3221) file: [c85eba7e] check-in: [f9ea9704] user: danielk1977 branch: trunk, size: 5646
01:04
Progress toward getting the virtual-table code generator to work. (CVS 3220) file: [2a8676c4] check-in: [3532f134] user: drh branch: trunk, size: 5975
2006-06-12
12:50
Fixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216) file: [9bfd5b76] check-in: [54b30fe1] user: drh branch: trunk, size: 5395
12:08
Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214) file: [d25e2c7b] check-in: [b63dbc79] user: danielk1977 branch: trunk, size: 5363
11:24
Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213) file: [9eb1d2e4] check-in: [bbeb93b5] user: danielk1977 branch: trunk, size: 5273
06:09
Incremental work on parsing/storing and invoking the xCreate callback for virtual tables. (CVS 3212) file: [c1a91a33] check-in: [8ffbab79] user: danielk1977 branch: trunk, size: 3955
2006-06-11
23:41
Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [210f2109] check-in: [898ec36b] user: drh branch: trunk, size: 3535 Added