SQLite

All files named ”test/vtab1.test”
Login

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

History for test/vtab1.test

2021-12-16
00:36
[cd6aabc23a] part of check-in [da3aae7bcf] Change the query planner so that it excludes virtual table constraints that do not have the correct collation. This breaks the expert extension. (check-in: [da3aae7bcf] user: drh branch: vtab-collation-fix, size: 41442)
2021-11-06
07:08
[09a72330d0] part of check-in [b1fc3de81e] Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: [b1fc3de81e] user: dan branch: reuse-schema, size: 41041)
2021-07-05
11:27
[772c94825d] part of check-in [740cb43025] Allow sub-queries in the FROM clause of an UPDATE...FROM statement to access the object being updated without using an alias, as is required in the parent query. (check-in: [740cb43025] user: dan branch: trunk, size: 40654)
02:40
[e576091143] part of check-in [2547cfe38f] Improved rebustness in sqlite3ExprListDup() when it contains a vector assignment from an UPDATE where the initial term is omitted. This can happen during a UNION ALL query flattening while processing a virtual table update in which the first term of the vector is repeated. Forum post 16ca0e9f32. (check-in: [2547cfe38f] user: drh branch: trunk, size: 40707)
2021-05-17
13:11
[99c0c13b53] part of check-in [391c73132c] When deleting an SQL function that does not exist, return without doing anything at all rather than creating a tombstone function. In this way, function deletes that happen inside virtual-table destructors that are run when a database connection is closing do not create new tombstones in the function table after the function table has already been purged. forum post 726219164b. (check-in: [391c73132c] user: drh branch: trunk, size: 40202)
2019-08-16
22:58
[c5d9e90ed0] part of check-in [31e34fa339] Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. (check-in: [31e34fa339] user: drh branch: trunk, size: 40168)
2019-08-13
17:56
[efb4c4a451] part of check-in [408144a183] Update test cases so that they work with ICU enabled. (check-in: [408144a183] user: dan branch: trunk, size: 40172)
2019-07-17
12:42
[fa6baded08] part of check-in [340378c1e6] New test cases for PRAGMA index_xinfo on a WITHOUT ROWID table. And new testcases using index_xinfo to verify that WITHOUT ROWID tables are constructed correctly. (check-in: [340378c1e6] user: drh branch: wor-pk-dups, size: 40113)
2019-06-14
12:28
[47b935205d] part of check-in [b4a9e09e60] Refactor the LIKE optimization decision logic so that it uses sqlite3AtoF() on both boundary keys to determine if the optimization can be used when the LHS is something that might not have TEXT affinity. Ticket [ce8717f0885af975]. See also [c94369cae9b561b1], [b043a54c3de54b28], [fd76310a5e843e07], and [158290c0abafde67]. (check-in: [b4a9e09e60] user: drh branch: trunk, size: 39933)
2018-11-07
02:17
[60b4f70aaf] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 39599)
2017-07-10
12:07
[8f91b9538d] 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: 39564)
2017-07-07
19:43
[f7d743a1d7] part of check-in [732f90d632] 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). (check-in: [732f90d632] user: drh branch: trunk, size: 39569)
2017-02-10
21:37
[ed4a576231] part of check-in [158290c0ab] 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. (check-in: [158290c0ab] user: drh branch: trunk, size: 39589)
2015-11-26
19:33
[7c4b81abd8] part of check-in [116b206494] 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. (check-in: [116b206494] user: dan branch: vtab-colused, size: 39573)
2015-11-23
21:09
[ec5cb76727] part of check-in [277a5b4027] Add experimental support for LIKE, GLOB and REGEXP to the virtual table interface. (check-in: [277a5b4027] user: dan branch: vtab-like-operator, size: 39280)
2015-06-10
23:02
[6210e07699] part of check-in [e64a568179] More test output refinements. (check-in: [e64a568179] user: mistachkin branch: testerOutput, size: 39208)
2015-05-21
17:24
[2ec3981c68] part of check-in [b3bb660af9] 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]. (check-in: [b3bb660af9] user: dan branch: branch-3.8.6, size: 36750)
2015-05-14
13:41
[dbe0e9e121] part of check-in [b3676377b2] More test cases. Remove some invalid testcase() macros. Rearrange some code for improved testability. (check-in: [b3676377b2] user: drh branch: index-is-operator, size: 39264)
2015-04-18
16:25
[d1e5ec7a81] part of check-in [e98d481d84] 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. (check-in: [e98d481d84] user: dan branch: trunk, size: 39041)
2015-03-24
14:57
[c9dc2a73e9] part of check-in [5ee625b198] Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. (check-in: [5ee625b198] user: dan branch: nVDestroy, size: 38017)
2014-11-27
11:36
[1cef143101] part of check-in [f095cde579] 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". (check-in: [f095cde579] user: dan branch: trunk, size: 36422)
2014-01-20
19:55
[b631d147b1] part of check-in [7d9e22187d] 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]. (check-in: [7d9e22187d] user: dan branch: trunk, size: 35127)
2013-11-05
13:33
[45ddde5776] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 34728)
2013-06-12
17:08
[1550abf90b] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 34707)
2012-12-14
15:54
[4403f98786] part of check-in [6d507e4de9] Merge in all the trunk changes that have occurred since this branch was opened. (check-in: [6d507e4de9] user: drh branch: vtab-IN-opt, size: 34658)
2012-12-04
05:21
[36c9935e4b] part of check-in [59c233942e] Add a test to ensure that the fix in [b0c1ba655d] has worked. (check-in: [59c233942e] user: dan branch: mistake, size: 33158)
2012-10-16
23:17
[524beb672c] part of check-in [aa650746b1] Enable optimization of IN operators on constraints to virtual tables. (check-in: [aa650746b1] user: drh branch: vtab-IN-opt, size: 33701)
2012-06-08
11:48
[10fb9e656f] part of check-in [006db55526] Fix a problem in vtab1.test causing it to fail when run with any permutation that executes SQL within the tcl "sqlite3" command. (check-in: [006db55526] user: dan branch: trunk, size: 32201)
2012-05-16
14:29
[331ca61ba0] part of check-in [ea2cd55e09] Return SQLITE_MISUSE if an application attempts to register a virtual table module with the same name as an existing module. (check-in: [ea2cd55e09] user: dan branch: shared-schema, size: 32109)
2012-03-29
14:29
[e429a6835f] part of check-in [0bacb879e1] Disable the LIKE optimization if the column on the left-hand-side of the LIKE operator belongs to a virtual table. (check-in: [0bacb879e1] user: dan branch: trunk, size: 31753)
2012-01-28
19:41
[17d0db1096] part of check-in [230983e86a] Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. (check-in: [230983e86a] user: drh branch: trunk, size: 29934)
2011-10-29
15:29
[12fbb309ce] part of check-in [fb15f5458e] Add a test for [48f29963] that does not depend on FTS. (check-in: [fb15f5458e] user: dan branch: trunk, size: 29232)
2011-08-02
00:57
[b40b7e531d] 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: 28937)
2010-10-21
15:12
[7b79832824] part of check-in [f91471e723] Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers. (check-in: [f91471e723] user: dan branch: trunk, size: 28951)
2009-09-29
06:33
[9bc4a349a1] part of check-in [e4eb227b14] Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (check-in: [e4eb227b14] user: dan branch: trunk, size: 28387)
2008-08-01
17:51
[e321e3c804] part of check-in [4f4a9ccae7] Also test that setting sqlite3_vtab.zErrMsg works from within the xRename method. (CVS 5520) (check-in: [4f4a9ccae7] user: danielk1977 branch: trunk, size: 28350)
17:37
[2108cfb3ff] part of check-in [007359b770] 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) (check-in: [007359b770] user: danielk1977 branch: trunk, size: 28103)
2008-07-23
21:07
[905a1aedad] part of check-in [4a9dd5e782] 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) (check-in: [4a9dd5e782] user: drh branch: trunk, size: 26866)
2008-07-04
10:56
[4421276b90] part of check-in [a7f3b43166] Fix for explicitly inserting a NULL value into the rowid column of a virtual table. (CVS 5343) (check-in: [a7f3b43166] user: danielk1977 branch: trunk, size: 26743)
2008-06-16
06:31
[47092e3ac5] part of check-in [85483c8fb3] Add a test to verify that IN(...) WHERE clause terms are not handled by virtual table implemetations. (CVS 5221) (check-in: [85483c8fb3] user: danielk1977 branch: trunk, size: 26230)
2008-04-10
16:42
[b1e4bf536e] part of check-in [e3f798b1ca] Make sure check-in (4976) also fixes ticket #2935. (CVS 4981) (check-in: [e3f798b1ca] user: drh branch: trunk, size: 25281)
14:00
[4a2015dbf8] part of check-in [55591fc49c] Make sure changes to virtual tables are counted the same as real tables. Ticket #3038. (CVS 4976) (check-in: [55591fc49c] user: drh branch: trunk, size: 25153)
2007-12-13
21:54
[bd905d1d43] part of check-in [4e91a267fe] 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) (check-in: [4e91a267fe] user: drh branch: trunk, size: 24114)
2007-12-10
05:03
[9e0d27cf0a] part of check-in [0b34a18651] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (check-in: [0b34a18651] user: danielk1977 branch: trunk, size: 24123)
2007-11-05
05:12
[3573ad5045] part of check-in [7027368c15] Handle "IS NULL" constraints on virtual table scans. IS NULL constraints are not passed to the virtual table layer. Ticket #2759. (CVS 4523) (check-in: [7027368c15] user: danielk1977 branch: trunk, size: 24001)
2007-10-09
08:29
[3271e7c512] 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: 23243)
2007-09-03
15:03
[2f0afae624] part of check-in [a19d3a73a9] Fix a problem in hash.c when replacing entries in tables configured with copyKey==0. (CVS 4375) (check-in: [a19d3a73a9] user: danielk1977 branch: trunk, size: 23183)
2007-08-22
02:57
[607cddf5b4] part of check-in [6cc8641ed2] Remove a debugging btree_breakpoint from vtab1.test. (CVS 4267) (check-in: [6cc8641ed2] user: drh branch: trunk, size: 22853)
02:56
[f05e77fa16] part of check-in [783e07d561] A complete run of quick.test with mutex debugging enabled. (CVS 4266) (check-in: [783e07d561] user: drh branch: trunk, size: 22870)
2007-06-27
15:53
[e740d4761b] part of check-in [37d1f9f37e] Allow ALTER TABLE on virtual tables. (CVS 4142) (check-in: [37d1f9f37e] user: danielk1977 branch: trunk, size: 22861)
2007-03-30
14:56
[bf12992844] part of check-in [7e0aa96412] Coverage improvements for where.c. (CVS 3764) (check-in: [7e0aa96412] user: danielk1977 branch: trunk, size: 21851)
2007-03-02
08:12
[92410029a2] part of check-in [52885ed8b7] Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670) (check-in: [52885ed8b7] user: danielk1977 branch: trunk, size: 21847)
2007-02-21
16:52
[bbfeb479bc] part of check-in [43bf797842] Fix for an UPDATE on a virtual table when the WHERE clause matches zero rows. Ticket #2244. (CVS 3652) (check-in: [43bf797842] user: danielk1977 branch: trunk, size: 22353)
2007-01-09
14:01
[03c4ad3180] part of check-in [43fe7fc1c3] 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) (check-in: [43fe7fc1c3] user: drh branch: trunk, size: 21837)
2006-09-16
21:45
[30f82f7c3e] part of check-in [aa7728f9f5] Add the sqlite3_overload_function() API - part of the virtual table interface. (CVS 3426) (check-in: [aa7728f9f5] user: drh branch: trunk, size: 21190)
2006-09-02
22:14
[c7275c6c65] part of check-in [367bd8376f] Fix bugs in test scripts so that fulltest will pass. (CVS 3390) (check-in: [367bd8376f] user: drh branch: trunk, size: 21161)
2006-08-15
14:21
[20715bc233] part of check-in [3ebedbb6f9] 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) (check-in: [3ebedbb6f9] user: drh branch: trunk, size: 21122)
2006-07-08
18:35
[c794695b32] part of check-in [6e98373ca1] 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) (check-in: [6e98373ca1] user: drh branch: trunk, size: 21098)
18:09
[21df0e83d8] part of check-in [3c4233e074] Add tests and minor fixes to the xFindFunction method of virtual tables. (CVS 3323) (check-in: [3c4233e074] user: drh branch: trunk, size: 20935)
2006-06-24
11:51
[d78c94f5eb] part of check-in [255aa9121a] A few more test cases to improve coverage of virtual table module related code. (CVS 3292) (check-in: [255aa9121a] user: danielk1977 branch: trunk, size: 20536)
09:34
[566632d6c0] part of check-in [0c5f4ee39c] Add tests to improve coverage of vtab.c. (CVS 3291) (check-in: [0c5f4ee39c] user: danielk1977 branch: trunk, size: 19842)
08:51
[1513060e02] part of check-in [4630e11d9a] Ensure whitespace specified as part of a virtual table constructor argument is correctly passed to the constructor function. (CVS 3290) (check-in: [4630e11d9a] user: danielk1977 branch: trunk, size: 19171)
2006-06-23
14:32
[55c7415e8b] part of check-in [a56bfa5604] Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) (check-in: [a56bfa5604] user: danielk1977 branch: trunk, size: 18757)
2006-06-22
09:53
[3f21d81e59] part of check-in [51b729d9d9] Test the handling of errors in virtual table methods. (CVS 3284) (check-in: [51b729d9d9] user: danielk1977 branch: trunk, size: 18863)
2006-06-21
16:02
[5bb366f182] part of check-in [2d2805785f] Add the database name to the parameters passed to virtual table module xCreate and xConnect methods. (CVS 3282) (check-in: [2d2805785f] user: danielk1977 branch: trunk, size: 18317)
13:21
[482d1a593c] part of check-in [7dc36d1c79] Add the table name to the arguments passed to the virtual table methods xCreate/xConnect. (CVS 3281) (check-in: [7dc36d1c79] user: danielk1977 branch: trunk, size: 18022)
07:34
[a4a613abd0] part of check-in [bcef48c54d] Test cases for accessing virtual tables when the corresponding module is undefined. (CVS 3279) (check-in: [bcef48c54d] user: danielk1977 branch: trunk, size: 18016)
07:02
[ab6cf2670f] part of check-in [643e63e588] Fix a problem with virtual tables and joins. (CVS 3278) (check-in: [643e63e588] user: danielk1977 branch: trunk, size: 17141)
2006-06-20
13:07
[1a5233154c] part of check-in [3e19a7d8ea] Fix some problems with virtual tables and joins in where.c. (CVS 3277) (check-in: [3e19a7d8ea] user: danielk1977 branch: trunk, size: 17046)
11:01
[e5e668092b] part of check-in [c6ea353bd9] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353bd9] user: danielk1977 branch: trunk, size: 14959)
2006-06-19
03:05
[97d68ca03f] part of check-in [144d0eb13a] Add tests to ensure an INSERT/UPDATE/DELETE immediately after virtual table construction does not fail. (CVS 3270) (check-in: [144d0eb13a] user: danielk1977 branch: trunk, size: 14931)
2006-06-17
11:30
[cb90ff6852] part of check-in [ea7e4eca10] Add newly created virtual tables to the current transaction. (CVS 3267) (check-in: [ea7e4eca10] user: danielk1977 branch: trunk, size: 14883)
03:27
[6a7defe569] part of check-in [81c5a5b48b] Fixes for UPDATE statements on virtual tables. (CVS 3263) (check-in: [81c5a5b48b] user: danielk1977 branch: trunk, size: 14816)
2006-06-16
21:13
[028298f87b] part of check-in [2119e7bf55] Rework the way UPDATE works for virtual tables. (CVS 3262) (check-in: [2119e7bf55] user: drh branch: trunk, size: 14945)
06:17
[a31c323cf1] part of check-in [afa39a4632] Arrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259) (check-in: [afa39a4632] user: danielk1977 branch: trunk, size: 14919)
2006-06-15
10:41
[519f360d15] part of check-in [6380a9b118] Add tests (and modify test code) for writing to virtual tables. (CVS 3253) (check-in: [6380a9b118] user: danielk1977 branch: trunk, size: 12944)
07:29
[89937da89d] part of check-in [88fa510e4c] Simple tests and fixes for writing to virtual tables. (CVS 3252) (check-in: [88fa510e4c] user: danielk1977 branch: trunk, size: 11604)
2006-06-14
22:07
[3897a14010] part of check-in [c996185a9e] Bug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249) (check-in: [c996185a9e] user: drh branch: trunk, size: 10795)
08:48
[c74328129c] part of check-in [b4024c394d] Add tests for the new MATCH operator. (CVS 3238) (check-in: [b4024c394d] user: danielk1977 branch: trunk, size: 10825)
07:41
[8f123ec98d] part of check-in [f459f034f6] Add a test case for ORDER BY using the echo module. (CVS 3237) (check-in: [f459f034f6] user: danielk1977 branch: trunk, size: 9950)
06:31
[e445b10cb9] part of check-in [5e592c422b] Add tests for error conditions surrounding the creation/connection of virtual tables. (CVS 3235) (check-in: [5e592c422b] user: danielk1977 branch: trunk, size: 8480)
2006-06-13
23:51
[86e4c90c96] part of check-in [29199eeea4] The echo module test is now running. Added the tclvar module test but have not yet done anything with it. (CVS 3234) (check-in: [29199eeea4] user: drh branch: trunk, size: 5282)
15:00
[c94c8bdadf] part of check-in [7a3e97f76b] Add the tentative sqlite3_allocate_queryplan() API. (CVS 3228) (check-in: [7a3e97f76b] user: danielk1977 branch: trunk, size: 4943)
14:16
[56b29fcdaf] part of check-in [0f4657ea69] Add simple tests for the xFilter and xBestIndex methods. (CVS 3227) (check-in: [0f4657ea69] user: danielk1977 branch: trunk, size: 4889)
10:24
[67fed6f9b9] part of check-in [1f20e1832b] Add implementations for opcodes required for linear scans of virtual tables. (CVS 3223) (check-in: [1f20e1832b] user: danielk1977 branch: trunk, size: 4166)
04:11
[b3a93d0b46] part of check-in [f9ea970475] Bugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory in the Destroy() method of the echo module. (CVS 3221) (check-in: [f9ea970475] user: danielk1977 branch: trunk, size: 3257)
2006-06-12
16:01
[d3d4d38bd6] part of check-in [f0c7c8d12c] Add code to invoke the xDestroy method of a virtual table when it is dropped. (CVS 3218) (check-in: [f0c7c8d12c] user: danielk1977 branch: trunk, size: 3005)
12:50
[79369c49f7] part of check-in [54b30fe1bd] Fixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216) (check-in: [54b30fe1bd] user: drh branch: trunk, size: 2544)
12:08
[abc34e3ac7] part of check-in [b63dbc7947] Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214) (check-in: [b63dbc7947] user: danielk1977 branch: trunk, size: 2509)
11:24
[5c7f4a2a53] part of check-in [bbeb93b5bb] Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213) (check-in: [bbeb93b5bb] user: danielk1977 branch: trunk, size: 1971)
06:09
[5bf2bebe96] part of check-in [8ffbab79d5] Incremental work on parsing/storing and invoking the xCreate callback for virtual tables. (CVS 3212) (check-in: [8ffbab79d5] user: danielk1977 branch: trunk, size: 1323)
2006-06-11
23:41
Added: [9029c3ef19] part of check-in [898ec36b41] Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) (check-in: [898ec36b41] user: drh branch: trunk, size: 1371)