/ Timeline
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.

51 check-ins using file src/select.c version 38eda11d

2006-06-16
16:08
Add code to invoke the virtual table transaction interface. Untested at this point. (CVS 3261) check-in: 61251402 user: danielk1977 tags: trunk
08:01
Add some tests (and fixes) for virtual tables and the authorization callback. Still more to come. (CVS 3260) check-in: 9497c66e user: danielk1977 tags: trunk
06:17
Arrange for sqlite3_last_insert_rowid() to work with virtual tables. (CVS 3259) check-in: afa39a46 user: danielk1977 tags: trunk
2006-06-15
16:26
Fix type in test_schema.c. (CVS 3258) check-in: d65d83d3 user: danielk1977 tags: trunk
15:59
Add test_schema.c, containing a module for viewing the database schema via a virtual table. (CVS 3257) check-in: de8d32ac user: danielk1977 tags: trunk
15:38
Add column_value, declare_vtab and create_module to the function table used by dynamic extensions. (CVS 3256) check-in: 25c47508 user: danielk1977 tags: trunk
14:31
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) check-in: fe3e70a7 user: drh tags: trunk
13:22
Asserts added that verify that the code works correctly that ticket #1849 claims is wrong. (CVS 3254) check-in: d145dc1c user: drh tags: trunk
10:41
Add tests (and modify test code) for writing to virtual tables. (CVS 3253) check-in: 6380a9b1 user: danielk1977 tags: trunk
07:29
Simple tests and fixes for writing to virtual tables. (CVS 3252) check-in: 88fa510e user: danielk1977 tags: trunk
04:28
Add void* argument to sqlite3_create_module to replace sqlite3_module.pAux. (CVS 3251) check-in: 470a3a0b user: danielk1977 tags: trunk
2006-06-14
23:43
Changes to test8.c to support UPDATE operations on xUpdate. (CVS 3250) check-in: 9e96511f user: drh tags: trunk
22:07
Bug fixes in the MATCH and ORDER BY processing of virtual tables. (CVS 3249) check-in: c996185a user: drh tags: trunk
19:00
Added code to INSERT, DELETE and UPDATE virtual tables. The new code is mostly untested. (CVS 3248) check-in: 32c97b88 user: drh tags: trunk
15:35
Better documentation on the limits of user-defined functions. And a marginally better error message when those limits are exceeded. Ticket #1847. (CVS 3247) check-in: 0d369ff0 user: drh tags: trunk
15:16
Add xUpdate method to the echo test module. Currently untested. (CVS 3246) check-in: 676de55b user: danielk1977 tags: trunk
15:14
Fix segfault introduced in (3243). (CVS 3245) check-in: e5fff87d user: danielk1977 tags: trunk
15:03
Fix a C++-ism in lempar.c. Ticket #1848. (CVS 3244) check-in: a0a3b34d user: drh tags: trunk
13:03
Add the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module with xUpdate. (CVS 3243) check-in: 15ba5cbf user: danielk1977 tags: trunk
13:03
Add the opcode OP_VUpdate and replace the xInsert/xDelete members of sqlite3_module with xUpdate. (CVS 3242) check-in: 418f3ca8 user: danielk1977 tags: trunk
10:55
Add code to test8.c to check that the correct idxNum value is passed to the xFilter method. (CVS 3241) check-in: 77bcaf99 user: danielk1977 tags: trunk
10:47
Fix typo in test8.c. (CVS 3240) check-in: 75be7d49 user: danielk1977 tags: trunk
10:38
Add some tests for sqlite3_load_extension(). (CVS 3239) check-in: 402a77c4 user: danielk1977 tags: trunk
08:48
Add tests for the new MATCH operator. (CVS 3238) check-in: b4024c39 user: danielk1977 tags: trunk
07:41
Add a test case for ORDER BY using the echo module. (CVS 3237) check-in: f459f034 user: danielk1977 tags: trunk
06:58
Change the pModule parameter of the xCreate and xConnect methods to a void*. (CVS 3236) check-in: 3ffa51b5 user: danielk1977 tags: trunk
06:31
Add tests for error conditions surrounding the creation/connection of virtual tables. (CVS 3235) check-in: 5e592c42 user: danielk1977 tags: trunk
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) check-in: 29199eee user: drh tags: trunk
19:26
The (unsupported) soundex() function returns '?000' when given a NULL. Ticket #1845. (CVS 3233) check-in: 9372481f user: drh tags: trunk
17:39
The optimizer recognizes MATCH operators and allows virtual-tables to make use of them. (CVS 3232) check-in: 136bed49 user: drh tags: trunk
15:37
Add support for the MATCH operator. (CVS 3231) check-in: 815b84d5 user: drh tags: trunk
15:36
Get the code to compile with -DSQLITE_OMIT_VIRTUALTABLE=1 (CVS 3230) check-in: ea4bc5a0 user: drh tags: trunk
15:12
Improved comments and documentation of sqlite3_load_extension(). (CVS 3229) check-in: 0bcec959 user: drh tags: trunk
15:00
Add the tentative sqlite3_allocate_queryplan() API. (CVS 3228) check-in: 7a3e97f7 user: danielk1977 tags: trunk
14:16
Add simple tests for the xFilter and xBestIndex methods. (CVS 3227) check-in: 0f4657ea user: danielk1977 tags: trunk
13:27
Lemon correctly recognizes an empty grammar and errors out. Fix for a bug reported on the sqlite-users mailing list. (CVS 3226) check-in: 55392922 user: drh tags: trunk
11:27
Free error message string in the quick start example. (CVS 3225) check-in: 1273261b user: drh tags: trunk
11:15
Minor changes to lempar.c to reduce warnings on some compilers. (CVS 3224) check-in: dae71de1 user: drh tags: trunk
10:24
Add implementations for opcodes required for linear scans of virtual tables. (CVS 3223) check-in: 1f20e183 user: danielk1977 tags: trunk
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 3222) check-in: 00f3c249 user: danielk1977 tags: trunk
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) check-in: f9ea9704 user: danielk1977 tags: trunk
01:04
Progress toward getting the virtual-table code generator to work. (CVS 3220) check-in: 3532f134 user: drh tags: trunk
2006-06-12
21:59
Added code to iterate through virtual tables. All regression tests pass but the new code is completely untested. (CVS 3219) check-in: 01096543 user: drh tags: trunk
16:01
Add code to invoke the xDestroy method of a virtual table when it is dropped. (CVS 3218) check-in: f0c7c8d1 user: danielk1977 tags: trunk
12:57
Patches to get things working better for OS2. Ticket #1836. (CVS 3217) check-in: 65c6e5e1 user: drh tags: trunk
12:50
Fixes so that builds work with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3216) check-in: 54b30fe1 user: drh tags: trunk
12:46
Get builds working again when extension loading is not enabled. Ticket #1839. (CVS 3215) check-in: 89ead801 user: drh tags: trunk
12:08
Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214) check-in: b63dbc79 user: danielk1977 tags: trunk
11:24
Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213) check-in: bbeb93b5 user: danielk1977 tags: trunk
06:09
Incremental work on parsing/storing and invoking the xCreate callback for virtual tables. (CVS 3212) check-in: 8ffbab79 user: danielk1977 tags: trunk
2006-06-11
23:41
Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) check-in: 898ec36b user: drh tags: trunk