]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoMake sure that MATCH terms that a virtual table says should be omitted
drh [Tue, 27 Jun 2006 02:36:58 +0000 (02:36 +0000)] 
Make sure that MATCH terms that a virtual table says should be omitted
really are omitted. (CVS 3302)

FossilOrigin-Name: 3e1f5567dfd306bdb97275a32afd02ea693eaf58

19 years agoCleanup and refactor parts of the optimizer. (CVS 3301)
drh [Tue, 27 Jun 2006 02:33:40 +0000 (02:33 +0000)] 
Cleanup and refactor parts of the optimizer. (CVS 3301)

FossilOrigin-Name: 6609c25fbfa5ad7f55c356936abb1721686c47ca

19 years agoCache and reuse virtual table index information in the optimizer.
drh [Tue, 27 Jun 2006 01:54:26 +0000 (01:54 +0000)] 
Cache and reuse virtual table index information in the optimizer.
Improved diagnostics for virtual table index selection. (CVS 3300)

FossilOrigin-Name: 28413cf2b3f0e6f294e1f3c59fcce135b65c294f

19 years agoExport the sqlite3_bind_value API to loadable extensions. (CVS 3299)
drh [Tue, 27 Jun 2006 00:14:27 +0000 (00:14 +0000)] 
Export the sqlite3_bind_value API to loadable extensions. (CVS 3299)

FossilOrigin-Name: 1ca385bb39514cb73f506bfbbe38aabb6b70816c

19 years agoPublish APIs sqlite3_malloc() and sqlite3_realloc() that use the OS-layer
drh [Mon, 26 Jun 2006 21:35:44 +0000 (21:35 +0000)] 
Publish APIs sqlite3_malloc() and sqlite3_realloc() that use the OS-layer
memory allocator.  Convert sqlite3_free() and sqlite3_mprintf() to also
use the OS-layer memory allocator. (CVS 3298)

FossilOrigin-Name: 85a66a25e97471d3c459c8da6a96990b0537dc7d

19 years agoRemove the sqlite3_module.zName field which was used only for debugging. (CVS 3297)
drh [Mon, 26 Jun 2006 19:10:32 +0000 (19:10 +0000)] 
Remove the sqlite3_module.zName field which was used only for debugging. (CVS 3297)

FossilOrigin-Name: 74a3961f39b9a045518835b20940471ac97bca66

19 years agoFix a file descriptor leak following malloc failure on DROP TABLE IF EXISTS. (CVS...
drh [Mon, 26 Jun 2006 12:50:09 +0000 (12:50 +0000)] 
Fix a file descriptor leak following malloc failure on DROP TABLE IF EXISTS. (CVS 3296)

FossilOrigin-Name: 6a63f76c8de977b628c4cab258be5a11d7d7def9

19 years agoFix trivial compiler warnings. (CVS 3295)
danielk1977 [Mon, 26 Jun 2006 11:17:50 +0000 (11:17 +0000)] 
Fix trivial compiler warnings. (CVS 3295)

FossilOrigin-Name: 3538beace8ece6339fe8aaf40852ce5e5e7da283

19 years agoSyntax documentation updates. (CVS 3294)
drh [Mon, 26 Jun 2006 10:37:11 +0000 (10:37 +0000)] 
Syntax documentation updates. (CVS 3294)

FossilOrigin-Name: df601a7b374cb6ec21a2e91abf17af4fed404393

19 years ago(OS/2) Armor OS/2 against accidental deletion of files, too (patch by Daniel Kruse...
pweilbacher [Sat, 24 Jun 2006 12:38:59 +0000 (12:38 +0000)] 
(OS/2) Armor OS/2 against accidental deletion of files, too (patch by Daniel Kruse, verified by me) (CVS 3293)

FossilOrigin-Name: f357efb373b8631dbe4455530d060020b070bea2

19 years agoA few more test cases to improve coverage of virtual table module related code. ...
danielk1977 [Sat, 24 Jun 2006 11:51:33 +0000 (11:51 +0000)] 
A few more test cases to improve coverage of virtual table module related code. (CVS 3292)

FossilOrigin-Name: 255aa9121a2ef4fec7fa5523e52969acc96f4b40

19 years agoAdd tests to improve coverage of vtab.c. (CVS 3291)
danielk1977 [Sat, 24 Jun 2006 09:34:22 +0000 (09:34 +0000)] 
Add tests to improve coverage of vtab.c. (CVS 3291)

FossilOrigin-Name: 0c5f4ee39cb76747cf01398867fed2c7ae3edc84

19 years agoEnsure whitespace specified as part of a virtual table constructor argument is correc...
danielk1977 [Sat, 24 Jun 2006 08:51:05 +0000 (08:51 +0000)] 
Ensure whitespace specified as part of a virtual table constructor argument is correctly passed to the constructor function. (CVS 3290)

FossilOrigin-Name: 4630e11d9a697a7fa29a0a1bbca91da4ad2bde7b

19 years agoClean up and clarify code in test8.c. (CVS 3289)
danielk1977 [Sat, 24 Jun 2006 06:36:11 +0000 (06:36 +0000)] 
Clean up and clarify code in test8.c. (CVS 3289)

FossilOrigin-Name: 4acf7594a6c47142e7112d2cd9766a563401879b

19 years agoModify the test cases in tkt1444.test that were failing. I am convinced that the...
danielk1977 [Fri, 23 Jun 2006 14:43:30 +0000 (14:43 +0000)] 
Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288)

FossilOrigin-Name: 0534f6e15b84560124c3f1abd05f2967d10261c4

19 years agoAllow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287)
danielk1977 [Fri, 23 Jun 2006 14:32:08 +0000 (14:32 +0000)] 
Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287)

FossilOrigin-Name: a56bfa560425a5dc9273229f8838471dfc402024

19 years agoFix some memory leaks that occur when malloc() fails. (CVS 3286)
danielk1977 [Fri, 23 Jun 2006 11:34:54 +0000 (11:34 +0000)] 
Fix some memory leaks that occur when malloc() fails. (CVS 3286)

FossilOrigin-Name: b56cc035f2be5c1a3f63efbb4c181e405a140fbb

19 years agoAdd tests and fixes for handling malloc() failures related to the virtual table featu...
danielk1977 [Fri, 23 Jun 2006 08:05:19 +0000 (08:05 +0000)] 
Add tests and fixes for handling malloc() failures related to the virtual table feature. (CVS 3285)

FossilOrigin-Name: 5d1d907189ff3ca7afada83033280cf258984ac0

19 years agoTest the handling of errors in virtual table methods. (CVS 3284)
danielk1977 [Thu, 22 Jun 2006 09:53:48 +0000 (09:53 +0000)] 
Test the handling of errors in virtual table methods. (CVS 3284)

FossilOrigin-Name: 51b729d9d9f8a60cdfb552809e4aa10012f4eb68

19 years agoMake the last_insert_rowid method in the TCL interface work with
drh [Wed, 21 Jun 2006 19:30:34 +0000 (19:30 +0000)] 
Make the last_insert_rowid method in the TCL interface work with
64-bit rowids. (CVS 3283)

FossilOrigin-Name: d50c37975de7639627422cbed40eb03a431874d5

19 years agoAdd the database name to the parameters passed to virtual table module xCreate and...
danielk1977 [Wed, 21 Jun 2006 16:02:42 +0000 (16:02 +0000)] 
Add the database name to the parameters passed to virtual table module xCreate and xConnect methods. (CVS 3282)

FossilOrigin-Name: 2d2805785f473afc202df532df84c45e6f0dc0f1

19 years agoAdd the table name to the arguments passed to the virtual table methods xCreate/xConn...
danielk1977 [Wed, 21 Jun 2006 13:21:50 +0000 (13:21 +0000)] 
Add the table name to the arguments passed to the virtual table methods xCreate/xConnect. (CVS 3281)

FossilOrigin-Name: 7dc36d1c798aa8b30b88a528fc9e69b342f278c7

19 years agoAdd tests to make sure altering or adding an index to a virtual table is prohibited...
danielk1977 [Wed, 21 Jun 2006 12:36:25 +0000 (12:36 +0000)] 
Add tests to make sure altering or adding an index to a virtual table is prohibited. (CVS 3280)

FossilOrigin-Name: 6c3e8852ffbaf5ab52ffdf7ed3767fa1d4fd5882

19 years agoTest cases for accessing virtual tables when the corresponding module is undefined...
danielk1977 [Wed, 21 Jun 2006 07:34:11 +0000 (07:34 +0000)] 
Test cases for accessing virtual tables when the corresponding module is undefined. (CVS 3279)

FossilOrigin-Name: bcef48c54dd01cf089db16192e670cb0717988ac

19 years agoFix a problem with virtual tables and joins. (CVS 3278)
danielk1977 [Wed, 21 Jun 2006 07:02:33 +0000 (07:02 +0000)] 
Fix a problem with virtual tables and joins. (CVS 3278)

FossilOrigin-Name: 643e63e5883eec109a91a44dae62b58650646575

19 years agoFix some problems with virtual tables and joins in where.c. (CVS 3277)
danielk1977 [Tue, 20 Jun 2006 13:07:27 +0000 (13:07 +0000)] 
Fix some problems with virtual tables and joins in where.c. (CVS 3277)

FossilOrigin-Name: 3e19a7d8eabcd2fa71ced3f76c5f9bc1f3900b81

19 years agoModifications so that compilation and testing with the various OMIT macros defined...
danielk1977 [Tue, 20 Jun 2006 11:01:07 +0000 (11:01 +0000)] 
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

FossilOrigin-Name: c6ea353bd9f5fe6c9cc3349d2034ada283f9c80e

19 years agoUpdate the news column on the homepage. (CVS 3275)
drh [Tue, 20 Jun 2006 00:22:37 +0000 (00:22 +0000)] 
Update the news column on the homepage. (CVS 3275)

FossilOrigin-Name: 24a94bb07589c04305eceec1dc9a1a9a2c39e2c5

19 years agoAvoid returning MISUSE when sqlite is called recursively by an xBestIndex callback...
danielk1977 [Mon, 19 Jun 2006 12:02:58 +0000 (12:02 +0000)] 
Avoid returning MISUSE when sqlite is called recursively by an xBestIndex callback. (CVS 3274)

FossilOrigin-Name: 4339e1bf664c4287aabe0993a9c5a2b783019cb3

19 years agoAdd tests to ensure triggers cannot be created on virtual tables. (CVS 3273)
danielk1977 [Mon, 19 Jun 2006 06:32:23 +0000 (06:32 +0000)] 
Add tests to ensure triggers cannot be created on virtual tables. (CVS 3273)

FossilOrigin-Name: 9470e27962d2fe9c0d1921d9aab7d8f0047ac1fd

19 years agoRespect default collation sequences assigned to virtual table columns. (CVS 3272)
danielk1977 [Mon, 19 Jun 2006 05:33:45 +0000 (05:33 +0000)] 
Respect default collation sequences assigned to virtual table columns. (CVS 3272)

FossilOrigin-Name: d9b205acac34ba9703bc35dfb101aedd95cb5a16

19 years agoFix memory leak in where.c. (CVS 3271)
danielk1977 [Mon, 19 Jun 2006 04:49:34 +0000 (04:49 +0000)] 
Fix memory leak in where.c. (CVS 3271)

FossilOrigin-Name: 3d10e8f36113a189aa19ecd99007cd0a926b2f8a

19 years agoAdd tests to ensure an INSERT/UPDATE/DELETE immediately after virtual table construct...
danielk1977 [Mon, 19 Jun 2006 03:05:10 +0000 (03:05 +0000)] 
Add tests to ensure an INSERT/UPDATE/DELETE immediately after virtual table construction does not fail. (CVS 3270)

FossilOrigin-Name: 144d0eb13aed4507e93edec781b1819a068f4a70

19 years agoAdd the load_extension() SQL function. (CVS 3269)
drh [Sat, 17 Jun 2006 14:12:47 +0000 (14:12 +0000)] 
Add the load_extension() SQL function. (CVS 3269)

FossilOrigin-Name: e08e2ddafe909ae6073ec56dfa3fdca23e36bf2e

19 years agoThe default entry point for loadable extensions is now
drh [Sat, 17 Jun 2006 13:21:32 +0000 (13:21 +0000)] 
The default entry point for loadable extensions is now
always sqlite3_extension_init(). (CVS 3268)

FossilOrigin-Name: 059b1f61406ca60fdbd3ec59c5b15fadc6552564

19 years agoAdd newly created virtual tables to the current transaction. (CVS 3267)
danielk1977 [Sat, 17 Jun 2006 11:30:32 +0000 (11:30 +0000)] 
Add newly created virtual tables to the current transaction. (CVS 3267)

FossilOrigin-Name: ea7e4eca106cea27d5dc447d2afcd45448152151

19 years agoClear a compiler warning by adding a prototype to sqliteInt.h. (CVS 3266)
drh [Sat, 17 Jun 2006 10:44:42 +0000 (10:44 +0000)] 
Clear a compiler warning by adding a prototype to sqliteInt.h. (CVS 3266)

FossilOrigin-Name: ca541ef3c464c5627596a48ee7f1ec40948cf65d

19 years agoAdd tests (and fixes) for the virtual table transaction interface. (CVS 3265)
danielk1977 [Sat, 17 Jun 2006 09:39:55 +0000 (09:39 +0000)] 
Add tests (and fixes) for the virtual table transaction interface. (CVS 3265)

FossilOrigin-Name: 8a5b121f2f26bebe3f1164bc2f504d29b74400f4

19 years agoWhen updating a view, invoke the authorization callback for reading the view before...
danielk1977 [Sat, 17 Jun 2006 06:31:18 +0000 (06:31 +0000)] 
When updating a view, invoke the authorization callback for reading the view before setting the authorization-context to the view name. (CVS 3264)

FossilOrigin-Name: 48d297c561b8d3d670ab425115ef50d1901523b6

19 years agoFixes for UPDATE statements on virtual tables. (CVS 3263)
danielk1977 [Sat, 17 Jun 2006 03:27:21 +0000 (03:27 +0000)] 
Fixes for UPDATE statements on virtual tables. (CVS 3263)

FossilOrigin-Name: 81c5a5b48b05186a1690198092ac92006d9f7020

19 years agoRework the way UPDATE works for virtual tables. (CVS 3262)
drh [Fri, 16 Jun 2006 21:13:21 +0000 (21:13 +0000)] 
Rework the way UPDATE works for virtual tables. (CVS 3262)

FossilOrigin-Name: 2119e7bf5577350e4e1236ea729568085620a826

19 years agoAdd code to invoke the virtual table transaction interface. Untested at this point...
danielk1977 [Fri, 16 Jun 2006 16:08:53 +0000 (16:08 +0000)] 
Add code to invoke the virtual table transaction interface. Untested at this point. (CVS 3261)

FossilOrigin-Name: 6125140228e09cad2029a48e92aa0123d3daecfb

19 years agoAdd some tests (and fixes) for virtual tables and the authorization callback. Still...
danielk1977 [Fri, 16 Jun 2006 08:01:02 +0000 (08:01 +0000)] 
Add some tests (and fixes) for virtual tables and the authorization callback. Still more to come. (CVS 3260)

FossilOrigin-Name: 9497c66e5533ec143d0efda4a419e4bdf922ae8c

19 years agoArrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259)
danielk1977 [Fri, 16 Jun 2006 06:17:47 +0000 (06:17 +0000)] 
Arrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259)

FossilOrigin-Name: afa39a46320e9996a5478ea6e19eb4c2014327ac

19 years agoFix type in test_schema.c. (CVS 3258)
danielk1977 [Thu, 15 Jun 2006 16:26:45 +0000 (16:26 +0000)] 
Fix type in test_schema.c. (CVS 3258)

FossilOrigin-Name: d65d83d38321258a7bb8c38f4b2657650b0f1033

19 years agoAdd test_schema.c, containing a module for viewing the database schema via a virtual...
danielk1977 [Thu, 15 Jun 2006 15:59:19 +0000 (15:59 +0000)] 
Add test_schema.c, containing a module for viewing the database schema via a virtual table. (CVS 3257)

FossilOrigin-Name: de8d32ac71a6e113e83b952813424cb3fb5a2e59

19 years agoAdd column_value, declare_vtab and create_module to the function table used by dynami...
danielk1977 [Thu, 15 Jun 2006 15:38:41 +0000 (15:38 +0000)] 
Add column_value, declare_vtab and create_module to the function table used by dynamic extensions. (CVS 3256)

FossilOrigin-Name: 25c475087892fea83bce9d140b46651793b85a86

19 years agoWrite database pages in sorted order to reduce file fragmentation.
drh [Thu, 15 Jun 2006 14:31:06 +0000 (14:31 +0000)] 
Write database pages in sorted order to reduce file fragmentation.
This is an experimental change.  It is not clear if it will help any.
It may well be removed in the future. (CVS 3255)

FossilOrigin-Name: fe3e70a7275d68acb6fb8ea5d62bed3e9d8d2766

19 years agoAsserts added that verify that the code works correctly
drh [Thu, 15 Jun 2006 13:22:22 +0000 (13:22 +0000)] 
Asserts added that verify that the code works correctly
that ticket #1849 claims is wrong. (CVS 3254)

FossilOrigin-Name: d145dc1c4bce403ec967bfd0024002d4de57f833

19 years agoAdd tests (and modify test code) for writing to virtual tables. (CVS 3253)
danielk1977 [Thu, 15 Jun 2006 10:41:15 +0000 (10:41 +0000)] 
Add tests (and modify test code) for writing to virtual tables. (CVS 3253)

FossilOrigin-Name: 6380a9b118cf972c3c7d4886ecdb62c44f2208ca

19 years agoSimple tests and fixes for writing to virtual tables. (CVS 3252)
danielk1977 [Thu, 15 Jun 2006 07:29:00 +0000 (07:29 +0000)] 
Simple tests and fixes for writing to virtual tables. (CVS 3252)

FossilOrigin-Name: 88fa510e4c684513bbb59031d034fdb5c51a6a15

19 years agoAdd void* argument to sqlite3_create_module to replace sqlite3_module.pAux. (CVS...
danielk1977 [Thu, 15 Jun 2006 04:28:13 +0000 (04:28 +0000)] 
Add void* argument to sqlite3_create_module to replace sqlite3_module.pAux. (CVS 3251)

FossilOrigin-Name: 470a3a0b20775be1226fb4d477c798d8da2d5708

19 years agoChanges to test8.c to support UPDATE operations on xUpdate. (CVS 3250)
drh [Wed, 14 Jun 2006 23:43:31 +0000 (23:43 +0000)] 
Changes to test8.c to support UPDATE operations on xUpdate. (CVS 3250)

FossilOrigin-Name: 9e96511f83476e489fa62a05241393a851cbac5c

19 years agoBug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249)
drh [Wed, 14 Jun 2006 22:07:10 +0000 (22:07 +0000)] 
Bug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249)

FossilOrigin-Name: c996185a9e0671e46bed06e5803b1ca3b42d61e2

19 years agoAdded code to INSERT, DELETE and UPDATE virtual tables. The new code is
drh [Wed, 14 Jun 2006 19:00:20 +0000 (19:00 +0000)] 
Added code to INSERT, DELETE and UPDATE virtual tables.  The new code is
mostly untested. (CVS 3248)

FossilOrigin-Name: 32c97b884b104d120db3c0a87f5eab28f36851f8

19 years agoBetter documentation on the limits of user-defined functions. And a
drh [Wed, 14 Jun 2006 15:35:36 +0000 (15:35 +0000)] 
Better documentation on the limits of user-defined functions.  And a
marginally better error message when those limits are exceeded.
Ticket #1847. (CVS 3247)

FossilOrigin-Name: 0d369ff071d296501cc33d4622144b22946ac555

19 years agoAdd xUpdate method to the echo test module. Currently untested. (CVS 3246)
danielk1977 [Wed, 14 Jun 2006 15:16:35 +0000 (15:16 +0000)] 
Add xUpdate method to the echo test module. Currently untested. (CVS 3246)

FossilOrigin-Name: 676de55b28f0b22cf78f5e71f4a960f3d76c2d72

19 years agoFix segfault introduced in (3243). (CVS 3245)
danielk1977 [Wed, 14 Jun 2006 15:14:50 +0000 (15:14 +0000)] 
Fix segfault introduced in (3243). (CVS 3245)

FossilOrigin-Name: e5fff87d004ccf0cf8ba1f6afa032f31144527d9

19 years agoFix a C++-ism in lempar.c. Ticket #1848. (CVS 3244)
drh [Wed, 14 Jun 2006 15:03:49 +0000 (15:03 +0000)] 
Fix a C++-ism in lempar.c.  Ticket #1848. (CVS 3244)

FossilOrigin-Name: a0a3b34db86ef1c31d172ca1b56afd26d18e429f

19 years agoAdd the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module...
danielk1977 [Wed, 14 Jun 2006 13:03:24 +0000 (13:03 +0000)] 
Add the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module with xUpdate. (CVS 3243)

FossilOrigin-Name: 15ba5cbf07da46319897e9a2519a6dba3b142103

19 years agoAdd the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module...
danielk1977 [Wed, 14 Jun 2006 13:03:23 +0000 (13:03 +0000)] 
Add the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module with xUpdate. (CVS 3242)

FossilOrigin-Name: 418f3ca84abf0d0876d2c4430f7f6ceaa9c0a17b

19 years agoAdd code to test8.c to check that the correct idxNum value is passed to the xFilter...
danielk1977 [Wed, 14 Jun 2006 10:55:52 +0000 (10:55 +0000)] 
Add code to test8.c to check that the correct idxNum value is passed to the xFilter method. (CVS 3241)

FossilOrigin-Name: 77bcaf99b3aba0f482e0504a5409c8f79cc441b4

19 years agoFix typo in test8.c. (CVS 3240)
danielk1977 [Wed, 14 Jun 2006 10:47:03 +0000 (10:47 +0000)] 
Fix typo in test8.c. (CVS 3240)

FossilOrigin-Name: 75be7d4988a3618ea9e3c1b65d5c05380ec7d25d

19 years agoAdd some tests for sqlite3_load_extension(). (CVS 3239)
danielk1977 [Wed, 14 Jun 2006 10:38:02 +0000 (10:38 +0000)] 
Add some tests for sqlite3_load_extension(). (CVS 3239)

FossilOrigin-Name: 402a77c43d4e4dcd2e1197cfaaa2ed51249a1b8f

19 years agoAdd tests for the new MATCH operator. (CVS 3238)
danielk1977 [Wed, 14 Jun 2006 08:48:25 +0000 (08:48 +0000)] 
Add tests for the new MATCH operator. (CVS 3238)

FossilOrigin-Name: b4024c394d25e5a0abdb07be779ae41581834c42

19 years agoAdd a test case for ORDER BY using the echo module. (CVS 3237)
danielk1977 [Wed, 14 Jun 2006 07:41:31 +0000 (07:41 +0000)] 
Add a test case for ORDER BY using the echo module. (CVS 3237)

FossilOrigin-Name: f459f034f659a4c418aa1bc72135cc93d04565df

19 years agoChange the pModule parameter of the xCreate and xConnect methods to a void*. (CVS...
danielk1977 [Wed, 14 Jun 2006 06:58:15 +0000 (06:58 +0000)] 
Change the pModule parameter of the xCreate and xConnect methods to a void*. (CVS 3236)

FossilOrigin-Name: 3ffa51b50a7831ef359bc40acf605decc922c498

19 years agoAdd tests for error conditions surrounding the creation/connection of virtual tables...
danielk1977 [Wed, 14 Jun 2006 06:31:28 +0000 (06:31 +0000)] 
Add tests for error conditions surrounding the creation/connection of virtual tables. (CVS 3235)

FossilOrigin-Name: 5e592c422b86deb5802c6536e91661717ee9bbe1

19 years agoThe echo module test is now running. Added the tclvar module test but have
drh [Tue, 13 Jun 2006 23:51:34 +0000 (23:51 +0000)] 
The echo module test is now running.  Added the tclvar module test but have
not yet done anything with it. (CVS 3234)

FossilOrigin-Name: 29199eeea4c46168ccaa7535d4941bd740479dee

19 years agoThe (unsupported) soundex() function returns '?000' when given a NULL.
drh [Tue, 13 Jun 2006 19:26:10 +0000 (19:26 +0000)] 
The (unsupported) soundex() function returns '?000' when given a NULL.
Ticket #1845. (CVS 3233)

FossilOrigin-Name: 9372481f233e1563b5ee137535f0fbf19851ffad

19 years agoThe optimizer recognizes MATCH operators and allows virtual-tables to make
drh [Tue, 13 Jun 2006 17:38:59 +0000 (17:38 +0000)] 
The optimizer recognizes MATCH operators and allows virtual-tables to make
use of them. (CVS 3232)

FossilOrigin-Name: 136bed496b89943522310ec511199b78198d0844

19 years agoAdd support for the MATCH operator. (CVS 3231)
drh [Tue, 13 Jun 2006 15:37:26 +0000 (15:37 +0000)] 
Add support for the MATCH operator. (CVS 3231)

FossilOrigin-Name: 815b84d5273b42978edcee0d4afe7f91a7933f4e

19 years agoGet the code to compile with -DSQLITE_OMIT_VIRTUALTABLE=1 (CVS 3230)
drh [Tue, 13 Jun 2006 15:36:06 +0000 (15:36 +0000)] 
Get the code to compile with -DSQLITE_OMIT_VIRTUALTABLE=1 (CVS 3230)

FossilOrigin-Name: ea4bc5a0be6cfc81ef1e9405f396c43205fe9cd8

19 years agoImproved comments and documentation of sqlite3_load_extension(). (CVS 3229)
drh [Tue, 13 Jun 2006 15:12:21 +0000 (15:12 +0000)] 
Improved comments and documentation of sqlite3_load_extension(). (CVS 3229)

FossilOrigin-Name: 0bcec95963603270ee053c83b1f6960b2029d378

19 years agoAdd the tentative sqlite3_allocate_queryplan() API. (CVS 3228)
danielk1977 [Tue, 13 Jun 2006 15:00:54 +0000 (15:00 +0000)] 
Add the tentative sqlite3_allocate_queryplan() API. (CVS 3228)

FossilOrigin-Name: 7a3e97f76b1f4f97a04f7c5a9daa400402b2ff25

19 years agoAdd simple tests for the xFilter and xBestIndex methods. (CVS 3227)
danielk1977 [Tue, 13 Jun 2006 14:16:58 +0000 (14:16 +0000)] 
Add simple tests for the xFilter and xBestIndex methods. (CVS 3227)

FossilOrigin-Name: 0f4657ea69314e49bc7c9faf9a653ef072f5082d

19 years agoLemon correctly recognizes an empty grammar and errors out.
drh [Tue, 13 Jun 2006 13:27:46 +0000 (13:27 +0000)] 
Lemon correctly recognizes an empty grammar and errors out.
Fix for a bug reported on the sqlite-users mailing list. (CVS 3226)

FossilOrigin-Name: 55392922686691db3d41525a7f4cb7f976e73467

19 years agoFree error message string in the quick start example. (CVS 3225)
drh [Tue, 13 Jun 2006 11:27:21 +0000 (11:27 +0000)] 
Free error message string in the quick start example. (CVS 3225)

FossilOrigin-Name: 1273261ba7a21062217e7fbc3447b5dadf53010f

19 years agoMinor changes to lempar.c to reduce warnings on some compilers. (CVS 3224)
drh [Tue, 13 Jun 2006 11:15:47 +0000 (11:15 +0000)] 
Minor changes to lempar.c to reduce warnings on some compilers. (CVS 3224)

FossilOrigin-Name: dae71de10d0f34a001b8070266d4016baafa6623

19 years agoAdd implementations for opcodes required for linear scans of virtual tables. (CVS...
danielk1977 [Tue, 13 Jun 2006 10:24:42 +0000 (10:24 +0000)] 
Add implementations for opcodes required for linear scans of virtual tables. (CVS 3223)

FossilOrigin-Name: 1f20e1832b38c76d2b0dde5fd720670c2ad0438b

19 years agoBugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory...
danielk1977 [Tue, 13 Jun 2006 04:11:43 +0000 (04:11 +0000)] 
Bugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory in the Destroy() method of the echo module. (CVS 3222)

FossilOrigin-Name: 00f3c249bc79556d0cb3999f543887bd4f160347

19 years agoBugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory...
danielk1977 [Tue, 13 Jun 2006 04:11:43 +0000 (04:11 +0000)] 
Bugfixes: Fix a segfault introduced as part of the new vtab code, deallocate memory in the Destroy() method of the echo module. (CVS 3221)

FossilOrigin-Name: f9ea9704755eee3fd29af7a47be1d41620be8835

19 years agoProgress toward getting the virtual-table code generator to work. (CVS 3220)
drh [Tue, 13 Jun 2006 01:04:52 +0000 (01:04 +0000)] 
Progress toward getting the virtual-table code generator to work. (CVS 3220)

FossilOrigin-Name: 3532f1340f939b0231c1d82a7b2d186cb096fb29

19 years agoAdded code to iterate through virtual tables. All regression tests pass
drh [Mon, 12 Jun 2006 21:59:13 +0000 (21:59 +0000)] 
Added code to iterate through virtual tables.  All regression tests pass
but the new code is completely untested. (CVS 3219)

FossilOrigin-Name: 010965433140fbe508a907d861dbad79343bf7c2

19 years agoAdd code to invoke the xDestroy method of a virtual table when it is dropped. (CVS...
danielk1977 [Mon, 12 Jun 2006 16:01:21 +0000 (16:01 +0000)] 
Add code to invoke the xDestroy method of a virtual table when it is dropped. (CVS 3218)

FossilOrigin-Name: f0c7c8d12c04376e48c6d53a29cfae3fa13b52cf

19 years agoPatches to get things working better for OS2. Ticket #1836. (CVS 3217)
drh [Mon, 12 Jun 2006 12:57:45 +0000 (12:57 +0000)] 
Patches to get things working better for OS2.  Ticket #1836. (CVS 3217)

FossilOrigin-Name: 65c6e5e117b9194015e382b1ad9bb9c88704eeb7

19 years agoFixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216)
drh [Mon, 12 Jun 2006 12:50:23 +0000 (12:50 +0000)] 
Fixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216)

FossilOrigin-Name: 54b30fe1bdf0c9e690e12f07dcce4382e863bf02

19 years agoGet builds working again when extension loading is not enabled. Ticket #1839. (CVS...
drh [Mon, 12 Jun 2006 12:46:21 +0000 (12:46 +0000)] 
Get builds working again when extension loading is not enabled.  Ticket #1839. (CVS 3215)

FossilOrigin-Name: 89ead80129ec934d2cb5f2447598a7253172f704

19 years agoAdd a simple test case (and corresponding bugfix) for the virtual table xConnect...
danielk1977 [Mon, 12 Jun 2006 12:08:45 +0000 (12:08 +0000)] 
Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214)

FossilOrigin-Name: b63dbc794795533f0bfd2d8e25633e6e3dea3ebd

19 years agoAdd first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213)
danielk1977 [Mon, 12 Jun 2006 11:24:37 +0000 (11:24 +0000)] 
Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213)

FossilOrigin-Name: bbeb93b5bb26ba83ee7b7ae439ca5ceebebac9a0

19 years agoIncremental work on parsing/storing and invoking the xCreate callback for virtual...
danielk1977 [Mon, 12 Jun 2006 06:09:17 +0000 (06:09 +0000)] 
Incremental work on parsing/storing and invoking the xCreate callback for virtual tables. (CVS 3212)

FossilOrigin-Name: 8ffbab79d5a76dea0f87cf551d5b6ad4f0fab337

19 years agoProgress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211)
drh [Sun, 11 Jun 2006 23:41:55 +0000 (23:41 +0000)] 
Progress toward CREATE VIRTUAL TABLE.  Still not even close to working... (CVS 3211)

FossilOrigin-Name: 898ec36b4102aaa03979f8f5c510936e57e2ae48

19 years agoBasic parsing of CREATE VIRTUAL TABLE statements. (CVS 3210)
drh [Sat, 10 Jun 2006 13:29:31 +0000 (13:29 +0000)] 
Basic parsing of CREATE VIRTUAL TABLE statements. (CVS 3210)

FossilOrigin-Name: 66370cb99bd93abb33e1e8433672da45e1795f78

19 years agoIn the shell, make sure the database is opened before trying to do
drh [Thu, 8 Jun 2006 16:10:14 +0000 (16:10 +0000)] 
In the shell, make sure the database is opened before trying to do
an ".import".  Bug reported on the mailing list. (CVS 3209)

FossilOrigin-Name: 39e3427813135601a7417c96e55b410fa89ac1f5

19 years agoUnload shared libraries when a database connection closes. (CVS 3208)
drh [Thu, 8 Jun 2006 15:48:00 +0000 (15:48 +0000)] 
Unload shared libraries when a database connection closes. (CVS 3208)

FossilOrigin-Name: 327e6909c9d35b651ab6f3a1a270022b354538c6

19 years agoNew shell command ".load" and the sqlite3_load_extension() API allow
drh [Thu, 8 Jun 2006 15:28:43 +0000 (15:28 +0000)] 
New shell command ".load" and the sqlite3_load_extension() API allow
new SQL functions and collating sequences to be loaded at run-time from
a DLL or shared library. (CVS 3207)

FossilOrigin-Name: 4ca932d3ae9bb97b819b5baf6fd3e1cebda9e0e2

19 years agoVersion 3.3.6 (CVS 3206)
drh [Tue, 6 Jun 2006 13:34:16 +0000 (13:34 +0000)] 
Version 3.3.6 (CVS 3206)

FossilOrigin-Name: c11cb07e4b3f0b815a7099c8d201b3473869cba2

19 years agoChanges in preparation for version 3.3.6. (CVS 3205)
drh [Tue, 6 Jun 2006 12:38:50 +0000 (12:38 +0000)] 
Changes in preparation for version 3.3.6. (CVS 3205)

FossilOrigin-Name: b2e11e02902d6fa8fc2fb95cda4810e837d6861e

19 years agoCommand "sqlite3 -version" returns 0 instead of 1. Ticket #1771. (CVS 3204)
drh [Tue, 6 Jun 2006 12:32:21 +0000 (12:32 +0000)] 
Command "sqlite3 -version" returns 0 instead of 1.  Ticket #1771. (CVS 3204)

FossilOrigin-Name: fd0fae4835a7d16b0186827b756c44bc984b42dc

19 years agoIn joins of the form "A left B, C" make sure they are not transformed into
drh [Tue, 6 Jun 2006 11:45:54 +0000 (11:45 +0000)] 
In joins of the form "A left B, C" make sure they are not transformed into
"A left C, B".  Ticket #1830.  See also #1652. (CVS 3203)

FossilOrigin-Name: 2baa983653796e16d36739e37b0be1672bf59a92