/ File History
Login

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

History of test/vtab1.test

2018-11-07
02:17
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. file: [60b4f70a] check-in: [3212733c] user: drh branch: read-only-shadow, size: 39599
2017-07-10
12:07
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. file: [8f91b953] check-in: [f27b6370] user: drh branch: trunk, size: 39564
2017-07-07
19:43
Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). file: [f7d743a1] check-in: [732f90d6] user: drh branch: trunk, size: 39569
2017-02-10
21:37
Enhance the LIKE optimization so that it works for arbitrary expressions on the LHS as long as the pattern on the RHS does not begin with a digit or a minus sign. file: [ed4a5762] check-in: [158290c0] user: drh branch: trunk, size: 39589
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: [7c4b81ab] check-in: [116b2064] user: dan branch: vtab-colused, size: 39573
2015-11-23
21:09
Add experimental support for LIKE, GLOB and REGEXP to the virtual table interface. file: [ec5cb767] check-in: [277a5b40] user: dan branch: vtab-like-operator, size: 39280
2015-06-10
23:02
More test output refinements. file: [6210e076] check-in: [e64a5681] user: mistachkin branch: testerOutput, size: 39208
2015-05-21
17:24
Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. file: [2ec3981c] check-in: [b3bb660a] user: dan branch: branch-3.8.6, size: 36750
2015-05-14
13:41
More test cases. Remove some invalid testcase() macros. Rearrange some code for improved testability. file: [dbe0e9e1] check-in: [b3676377] user: drh branch: index-is-operator, size: 39264
2015-04-18
16:25
Ensure that if a "ROLLBACK TO" statement is used to rollback (but not close) theoutermost transaction, the xRollbackTo() method of any virtual tables involved in the transaction is invoked. file: [d1e5ec7a] check-in: [e98d481d] user: dan branch: trunk, size: 39041
2015-03-24
14:57
Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. file: [c9dc2a73] check-in: [5ee625b1] user: dan branch: nVDestroy, size: 38017
2014-11-27
11:36
Fix a buffer overread during compilation of CREATE VIRTUAL TABLE statements that featured an explicit database name but no virtual table arguments. For example, "CREATE VIRTUAL TABLE main.ft USING fts4". file: [1cef1431] check-in: [f095cde5] user: dan branch: trunk, size: 36422
2014-01-20
19:55
In where.c, do not allocate space in sqlite3_index_info structures for the internal WHERE clause "terms" generated to record column equivalencies. Fix for ticket [1a1a194d1e5f8]. file: [b631d147] check-in: [7d9e2218] user: dan branch: trunk, size: 35127
2013-11-05
13:33
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. file: [45ddde57] check-in: [54b22192] user: drh branch: omit-rowid, size: 34728
2013-06-12
17:08
"make test" now passing. file: [1550abf9] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 34707
2012-12-14
15:54
Merge in all the trunk changes that have occurred since this branch was opened. file: [4403f987] check-in: [6d507e4d] user: drh branch: vtab-IN-opt, size: 34658
2012-12-04
05:21
Add a test to ensure that the fix in [b0c1ba655d] has worked. file: [36c9935e] check-in: [59c23394] user: dan branch: mistake, size: 33158
2012-10-16
23:17
Enable optimization of IN operators on constraints to virtual tables. file: [524beb67] check-in: [aa650746] user: drh branch: vtab-IN-opt, size: 33701
2012-06-08
11:48
Fix a problem in vtab1.test causing it to fail when run with any permutation that executes SQL within the tcl "sqlite3" command. file: [10fb9e65] check-in: [006db555] user: dan branch: trunk, size: 32201
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: [331ca61b] check-in: [ea2cd55e] user: dan branch: shared-schema, size: 32109
2012-03-29
14:29
Disable the LIKE optimization if the column on the left-hand-side of the LIKE operator belongs to a virtual table. file: [e429a683] check-in: [0bacb879] user: dan branch: trunk, size: 31753
2012-01-28
19:41
Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. file: [17d0db10] check-in: [230983e8] user: drh branch: trunk, size: 29934
2011-10-29
15:29
Add a test for [48f29963] that does not depend on FTS. file: [12fbb309] check-in: [fb15f545] user: dan branch: trunk, size: 29232
2011-08-02
00:57
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. file: [b40b7e53] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 28937
2010-10-21
15:12
Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers. file: [7b798328] check-in: [f91471e7] user: dan branch: trunk, size: 28951
2009-09-29
06:33
Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. file: [9bc4a349] check-in: [e4eb227b] user: dan branch: trunk, size: 28387
2008-08-01
17:51
Also test that setting sqlite3_vtab.zErrMsg works from within the xRename method. (CVS 5520) file: [e321e3c8] check-in: [4f4a9cca] user: danielk1977 branch: trunk, size: 28350
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: [2108cfb3] check-in: [007359b7] user: danielk1977 branch: trunk, size: 28103
2008-07-23
21:07
Error messages from virtual tables store on the sqlite3_vtab->zErrMsg field are reported back up to the application interface and memory is reclaimed. (CVS 5466) file: [905a1aed] check-in: [4a9dd5e7] user: drh branch: trunk, size: 26866
2008-07-04
10:56
Fix for explicitly inserting a NULL value into the rowid column of a virtual table. (CVS 5343) file: [4421276b] check-in: [a7f3b431] user: danielk1977 branch: trunk, size: 26743
2008-06-16
06:31
Add a test to verify that IN(...) WHERE clause terms are not handled by virtual table implemetations. (CVS 5221) file: [47092e3a] check-in: [85483c8f] user: danielk1977 branch: trunk, size: 26230
2008-04-10
16:42
Make sure check-in (4976) also fixes ticket #2935. (CVS 4981) file: [b1e4bf53] check-in: [e3f798b1] user: drh branch: trunk, size: 25281
14:00
Make sure changes to virtual tables are counted the same as real tables. Ticket #3038. (CVS 4976) file: [4a2015db] check-in: [55591fc4] user: drh branch: trunk, size: 25153
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: [bd905d1d] check-in: [4e91a267] user: drh branch: trunk, size: 24114
2007-12-10
05:03
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) file: [9e0d27cf] check-in: [0b34a186] user: danielk1977 branch: trunk, size: 24123
2007-11-05
05:12
Handle "IS NULL" constraints on virtual table scans. IS NULL constraints are not passed to the virtual table layer. Ticket #2759. (CVS 4523) file: [3573ad50] check-in: [7027368c] user: danielk1977 branch: trunk, size: 24001
2007-10-09
08:29
Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) file: [3271e7c5] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 23243
2007-09-03
15:03
Fix a problem in hash.c when replacing entries in tables configured with copyKey==0. (CVS 4375) file: [2f0afae6] check-in: [a19d3a73] user: danielk1977 branch: trunk, size: 23183
2007-08-22
02:57
Remove a debugging btree_breakpoint from vtab1.test. (CVS 4267) file: [607cddf5] check-in: [6cc8641e] user: drh branch: trunk, size: 22853
02:56
A complete run of quick.test with mutex debugging enabled. (CVS 4266) file: [f05e77fa] check-in: [783e07d5] user: drh branch: trunk, size: 22870
2007-06-27
15:53
Allow ALTER TABLE on virtual tables. (CVS 4142) file: [e740d476] check-in: [37d1f9f3] user: danielk1977 branch: trunk, size: 22861
2007-03-30
14:56
Coverage improvements for where.c. (CVS 3764) file: [bf129928] check-in: [7e0aa964] user: danielk1977 branch: trunk, size: 21851
2007-03-02
08:12
Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670) file: [92410029] check-in: [52885ed8] user: danielk1977 branch: trunk, size: 21847
2007-02-21
16:52
Fix for an UPDATE on a virtual table when the WHERE clause matches zero rows. Ticket #2244. (CVS 3652) file: [bbfeb479] check-in: [43bf7978] user: danielk1977 branch: trunk, size: 22353
2007-01-09
14:01
When an automatic re-prepare occurs, take care not to reset the internal schema symbol table. Ticket #2156. This change also includes some debugging enhancements. (CVS 3578) file: [03c4ad31] check-in: [43fe7fc1] user: drh branch: trunk, size: 21837
2006-09-16
21:45
Add the sqlite3_overload_function() API - part of the virtual table interface. (CVS 3426) file: [30f82f7c] check-in: [aa7728f9] user: drh branch: trunk, size: 21190
2006-09-02
22:14
Fix bugs in test scripts so that fulltest will pass. (CVS 3390) file: [c7275c6c] check-in: [367bd837] user: drh branch: trunk, size: 21161
2006-08-15
14:21
Tighten an assert (ticket #1920). Change to "sqlite3.h" from <sqlite3.h> on the sqlite3ext.h header (ticket #1916). Fix a bug in the test scripts. (CVS 3354) file: [20715bc2] check-in: [3ebedbb6] user: drh branch: trunk, size: 21122
2006-07-08
18:35
For infix functions (LIKE, GLOB, REGEXP, and MATCH) treat the left operand as the first argument for the purposes of virtual table function overloading, even though the left operand is really the the second argument. (CVS 3324) file: [c794695b] check-in: [6e98373c] user: drh branch: trunk, size: 21098
18:09
Add tests and minor fixes to the xFindFunction method of virtual tables. (CVS 3323) file: [21df0e83] check-in: [3c4233e0] user: drh branch: trunk, size: 20935
2006-06-24
11:51
A few more test cases to improve coverage of virtual table module related code. (CVS 3292) file: [d78c94f5] check-in: [255aa912] user: danielk1977 branch: trunk, size: 20536
09:34
Add tests to improve coverage of vtab.c. (CVS 3291) file: [566632d6] check-in: [0c5f4ee3] user: danielk1977 branch: trunk, size: 19842
08:51
Ensure whitespace specified as part of a virtual table constructor argument is correctly passed to the constructor function. (CVS 3290) file: [1513060e] check-in: [4630e11d] user: danielk1977 branch: trunk, size: 19171
2006-06-23
14:32
Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) file: [55c7415e] check-in: [a56bfa56] user: danielk1977 branch: trunk, size: 18757
2006-06-22
09:53
Test the handling of errors in virtual table methods. (CVS 3284) file: [3f21d81e] check-in: [51b729d9] user: danielk1977 branch: trunk, size: 18863
2006-06-21
16:02
Add the database name to the parameters passed to virtual table module xCreate and xConnect methods. (CVS 3282) file: [5bb366f1] check-in: [2d280578] user: danielk1977 branch: trunk, size: 18317
13:21
Add the table name to the arguments passed to the virtual table methods xCreate/xConnect. (CVS 3281) file: [482d1a59] check-in: [7dc36d1c] user: danielk1977 branch: trunk, size: 18022
07:34
Test cases for accessing virtual tables when the corresponding module is undefined. (CVS 3279) file: [a4a613ab] check-in: [bcef48c5] user: danielk1977 branch: trunk, size: 18016
07:02
Fix a problem with virtual tables and joins. (CVS 3278) file: [ab6cf267] check-in: [643e63e5] user: danielk1977 branch: trunk, size: 17141
2006-06-20
13:07
Fix some problems with virtual tables and joins in where.c. (CVS 3277) file: [1a523315] check-in: [3e19a7d8] user: danielk1977 branch: trunk, size: 17046
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [e5e66809] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 14959
2006-06-19
03:05
Add tests to ensure an INSERT/UPDATE/DELETE immediately after virtual table construction does not fail. (CVS 3270) file: [97d68ca0] check-in: [144d0eb1] user: danielk1977 branch: trunk, size: 14931
2006-06-17
11:30
Add newly created virtual tables to the current transaction. (CVS 3267) file: [cb90ff68] check-in: [ea7e4eca] user: danielk1977 branch: trunk, size: 14883
03:27
Fixes for UPDATE statements on virtual tables. (CVS 3263) file: [6a7defe5] check-in: [81c5a5b4] user: danielk1977 branch: trunk, size: 14816
2006-06-16
21:13
Rework the way UPDATE works for virtual tables. (CVS 3262) file: [028298f8] check-in: [2119e7bf] user: drh branch: trunk, size: 14945
06:17
Arrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259) file: [a31c323c] check-in: [afa39a46] user: danielk1977 branch: trunk, size: 14919
2006-06-15
10:41
Add tests (and modify test code) for writing to virtual tables. (CVS 3253) file: [519f360d] check-in: [6380a9b1] user: danielk1977 branch: trunk, size: 12944
07:29
Simple tests and fixes for writing to virtual tables. (CVS 3252) file: [89937da8] check-in: [88fa510e] user: danielk1977 branch: trunk, size: 11604
2006-06-14
22:07
Bug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249) file: [3897a140] check-in: [c996185a] user: drh branch: trunk, size: 10795
08:48
Add tests for the new MATCH operator. (CVS 3238) file: [c7432812] check-in: [b4024c39] user: danielk1977 branch: trunk, size: 10825
07:41
Add a test case for ORDER BY using the echo module. (CVS 3237) file: [8f123ec9] check-in: [f459f034] user: danielk1977 branch: trunk, size: 9950
06:31
Add tests for error conditions surrounding the creation/connection of virtual tables. (CVS 3235) file: [e445b10c] check-in: [5e592c42] user: danielk1977 branch: trunk, size: 8480
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: [86e4c90c] check-in: [29199eee] user: drh branch: trunk, size: 5282
15:00
Add the tentative sqlite3_allocate_queryplan() API. (CVS 3228) file: [c94c8bda] check-in: [7a3e97f7] user: danielk1977 branch: trunk, size: 4943
14:16
Add simple tests for the xFilter and xBestIndex methods. (CVS 3227) file: [56b29fcd] check-in: [0f4657ea] user: danielk1977 branch: trunk, size: 4889
10:24
Add implementations for opcodes required for linear scans of virtual tables. (CVS 3223) file: [67fed6f9] check-in: [1f20e183] user: danielk1977 branch: trunk, size: 4166
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: [b3a93d0b] check-in: [f9ea9704] user: danielk1977 branch: trunk, size: 3257
2006-06-12
16:01
Add code to invoke the xDestroy method of a virtual table when it is dropped. (CVS 3218) file: [d3d4d38b] check-in: [f0c7c8d1] user: danielk1977 branch: trunk, size: 3005
12:50
Fixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216) file: [79369c49] check-in: [54b30fe1] user: drh branch: trunk, size: 2544
12:08
Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214) file: [abc34e3a] check-in: [b63dbc79] user: danielk1977 branch: trunk, size: 2509
11:24
Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213) file: [5c7f4a2a] check-in: [bbeb93b5] user: danielk1977 branch: trunk, size: 1971
06:09
Incremental work on parsing/storing and invoking the xCreate callback for virtual tables. (CVS 3212) file: [5bf2bebe] check-in: [8ffbab79] user: danielk1977 branch: trunk, size: 1323
2006-06-11
23:41
Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [9029c3ef] check-in: [898ec36b] user: drh branch: trunk, size: 1371 Added