Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for pages/vtab.in
|
2024-05-23
| ||
| 20:19 | [8bd8bca0f1] part of check-in [ee3e0094b5] Add a tag to a section in vtab.html, for easier linking. (check-in: [ee3e0094b5] user: drh branch: trunk, size: 79861) | |
|
2023-10-25
| ||
| 19:08 | [45e542fb54] part of check-in [1d9044b16d] Improvements to VTAB documentation regarding xIntegrity. (check-in: [1d9044b16d] user: drh branch: trunk, size: 79830) | |
| 11:22 | [143d050ac3] part of check-in [96096bc9c6] Update the xIntegrity documentation to describe the new parameters. (check-in: [96096bc9c6] user: drh branch: trunk, size: 79781) | |
|
2023-10-20
| ||
| 22:32 | [2f4da6d769] part of check-in [41f546be6a] Update the change log for version 3.44.0. (check-in: [41f546be6a] user: drh branch: trunk, size: 77802) | |
|
2023-10-06
| ||
| 10:46 | [725421190e] part of check-in [57bf6c4ae7] Global replace http://www.sqlite.org with https://www.sqlite.org in pages/*.in. (check-in: [57bf6c4ae7] user: stephan branch: trunk, size: 75797) | |
|
2022-12-05
| ||
| 12:38 | [6780b9cf46] part of check-in [e60bcd90e5] Minor typo fixes in vtab.in. (check-in: [e60bcd90e5] user: stephan branch: trunk, size: 75795) | |
|
2022-10-29
| ||
| 17:50 | [b387aa1e7c] part of check-in [028b4422d8] Fix a typo in the vtab documentation. (check-in: [028b4422d8] user: drh branch: trunk, size: 75800) | |
|
2022-09-29
| ||
| 16:00 | [a0bab2b855] part of check-in [0dda2171c3] Version 3.39.4 (check-in: [0dda2171c3] user: drh branch: trunk, size: 75805) | |
|
2022-08-10
| ||
| 18:45 | [45876e524c] part of check-in [436f0088f9] Fix duplicate words reported by forum post 54abbe9ccd. (check-in: [436f0088f9] user: drh branch: trunk, size: 75790) | |
|
2022-01-29
| ||
| 22:27 | [3277807492] part of check-in [89ff423f8d] Fix a link to the json virtual tables in the virtual table documentation. (check-in: [89ff423f8d] user: drh branch: trunk, size: 75794) | |
| 22:20 | [5c3ece72f0] part of check-in [3cca88e77e] Add documentation for the recent virtual table enhancements. (check-in: [3cca88e77e] user: drh branch: trunk, size: 75801) | |
|
2021-12-17
| ||
| 23:57 | [b2b2e34d25] part of check-in [fe558417b1] Improved virtual table documentation. (check-in: [fe558417b1] user: drh branch: trunk, size: 71960) | |
|
2021-07-19
| ||
| 16:45 | [e8058f1e1d] part of check-in [f6864997ba] Improvements to the description of how to get good error messages out of xBestIndex for required table-valued function parameters. (check-in: [f6864997ba] user: drh branch: xbestindex-errors, size: 71127) | |
|
2021-07-16
| ||
| 17:20 | [e2c9d38950] part of check-in [3008d3fbc2] Update the generate_series() documentation to show that the first argument is now required. Enhance the virtual-table documentation to explain in detail how to construct an xBestIndex method that forces some arguments to a table-valued function to be required. (check-in: [3008d3fbc2] user: drh branch: trunk, size: 72148) | |
|
2021-05-25
| ||
| 16:22 | [76c8ce2b4e] part of check-in [495a1efae0] Clarify vtable xBestIndex to xFilter communication. (check-in: [495a1efae0] user: larrybr branch: trunk, size: 70172) | |
|
2020-11-25
| ||
| 13:10 | [4dc8ff2cdd] part of check-in [2d468b65df] Clarify the differences between xFindFunction and xBestIndex with regard to handling the argument swapping behavior of LIKE, GLOB, REGEXP, and MATCH. See forum post 9440862379. (check-in: [2d468b65df] user: drh branch: trunk, size: 70122) | |
|
2020-05-04
| ||
| 23:18 | [b02ef440e1] part of check-in [708a0633a2] Initial documentation of the bytecode and tables_used virtual tables. (check-in: [708a0633a2] user: drh branch: trunk, size: 68462) | |
|
2020-04-06
| ||
| 18:59 | [3b1f9d4b8b] part of check-in [de7905fcbb] Fix various minor HTML coding errors pointed out by Gisbert on the forum. (check-in: [de7905fcbb] user: drh branch: branch-3.31, size: 68428) | |
|
2020-01-13
| ||
| 15:26 | [1a61d2ddac] part of check-in [36399c3c34] Template for the new "application-defined SQL function page". Improvements to security documentation. (check-in: [36399c3c34] user: drh branch: trunk, size: 68427) | |
|
2018-11-16
| ||
| 14:33 | [5afca8d8fd] part of check-in [70c4eaad4d] More fixes to the virtual table documentation. (check-in: [70c4eaad4d] user: drh branch: trunk, size: 67631) | |
| 14:30 | [633dd921e1] part of check-in [52c277f049] Explain the use of SQLITE_CONSTRAINT as a return value from xBestIndex. (check-in: [52c277f049] user: drh branch: trunk, size: 67428) | |
|
2018-11-12
| ||
| 15:24 | [f8600c18f3] part of check-in [7b6b7a791b] Enhancements to the documentation regarding security and shadow tables. (check-in: [7b6b7a791b] user: drh branch: trunk, size: 65051) | |
|
2018-09-25
| ||
| 16:26 | [40a259a11f] part of check-in [db3facf719] Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. (check-in: [db3facf719] user: drh branch: branch-3.25, size: 62122) | |
| 15:02 | [c0ba86d3c7] part of check-in [e00e728eae] Preliminary changes for version 3.25.2. (check-in: [e00e728eae] user: drh branch: branch-3.25, size: 62127) | |
|
2018-08-27
| ||
| 20:52 | [6f33d266c4] part of check-in [f3d8866e42] Enhancements to the virtual table documentation to describe the operation of SQLITE_INDEX_CONSTRAINT_FUNCTION. (check-in: [f3d8866e42] user: drh branch: trunk, size: 61557) | |
|
2018-06-15
| ||
| 19:12 | [a9369ba6bb] part of check-in [2ee890a53a] Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. (check-in: [2ee890a53a] user: drh branch: branch-3.24, size: 59519) | |
|
2018-06-08
| ||
| 13:21 | [c031632705] part of check-in [59e5f9e3da] Use https for all internal hyperlinks. (check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 59501) | |
|
2018-05-25
| ||
| 17:50 | [8a0e009314] part of check-in [3d073f02d7] Add the vtablist.html page. (check-in: [3d073f02d7] user: drh branch: trunk, size: 59499) | |
| 12:54 | [8ea396006e] part of check-in [36334d1830] Clarification of xUpdate behavior in the virtual table documentation. (check-in: [36334d1830] user: drh branch: trunk, size: 59398) | |
|
2018-04-30
| ||
| 22:27 | [f89efbdb0b] part of check-in [32c5dad1b2] Update the change log. Fix typo in virtual table documentation. (check-in: [32c5dad1b2] user: drh branch: trunk, size: 59333) | |
|
2018-02-07
| ||
| 20:35 | [16d989be23] part of check-in [ec9c8be989] Fix typo in the vtab.html document. (check-in: [ec9c8be989] user: drh branch: branch-3.22, size: 59332) | |
|
2018-01-22
| ||
| 18:05 | [1180bd8e8c] part of check-in [2105719672] Fix a typo in the vtab document. (check-in: [2105719672] user: drh branch: trunk, size: 59320) | |
|
2018-01-13
| ||
| 00:03 | [a9c09dd79f] part of check-in [92b3735966] Clarification and typo fixes in the sqlite3_value_nochange() description within the xUpdate documentation. (check-in: [92b3735966] user: drh branch: trunk, size: 59319) | |
|
2018-01-12
| ||
| 23:52 | [685f08e741] part of check-in [8d811e938b] Update documentation for the sqlite3_value_nochange() interface. (check-in: [8d811e938b] user: drh branch: trunk, size: 59223) | |
|
2017-09-12
| ||
| 00:44 | [33d26508d8] part of check-in [bd399e9806] Update the virtual table documentation with information about the new operators passed into xBestIndex. (check-in: [bd399e9806] user: drh branch: trunk, size: 58265) | |
|
2017-08-11
| ||
| 01:21 | [da69470a70] part of check-in [af4e59995a] Update the virtual table documentation to describe writable WITHOUT ROWID virtual tables. Also update the change log. (check-in: [af4e59995a] user: drh branch: trunk, size: 57890) | |
|
2017-08-09
| ||
| 20:03 | [4ccdc8bf50] part of check-in [ecec1e668b] Clarification on the operation of the xUpdate method in the virtual table interface. (check-in: [ecec1e668b] user: drh branch: trunk, size: 57360) | |
|
2016-09-14
| ||
| 21:12 | [60bb0e494a] part of check-in [aa59a746e9] Fix unescaped > characters in vtab.in. (check-in: [aa59a746e9] user: drh branch: trunk, size: 57337) | |
| 18:40 | [daba002df9] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 57328) | |
|
2016-09-12
| ||
| 21:06 | [77a77ba503] part of check-in [2262f22f31] Fix formatting problems in vtab.html associated with <yyterm> marks. (check-in: [2262f22f31] user: drh branch: trunk, size: 57212) | |
| 21:01 | [15c8b6489f] part of check-in [4df3244e10] Fix a typo in vtab.in. (check-in: [4df3244e10] user: dan branch: trunk, size: 57719) | |
|
2016-08-09
| ||
| 00:13 | [62b599d019] part of check-in [03ec352945] Properly escape "<" and ">" characters in the vtab.html document. (check-in: [03ec352945] user: drh branch: trunk, size: 57720) | |
|
2016-06-23
| ||
| 16:59 | [8f4fe32040] part of check-in [ad981b591f] Enhancements to the WITHOUT ROWID virtual table documentation. (check-in: [ad981b591f] user: drh branch: trunk, size: 57705) | |
|
2016-06-03
| ||
| 22:40 | [41e584b735] part of check-in [01b8f2aa54] Documentation on WITHOUT ROWID virtual tables and the LIKE OR EQUAL optimization for virtual tables. (check-in: [01b8f2aa54] user: drh branch: trunk, size: 57740) | |
|
2016-02-02
| ||
| 02:05 | [05e1679d19] part of check-in [be35c1ae8e] Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column. (check-in: [be35c1ae8e] user: drh branch: trunk, size: 56388) | |
|
2015-11-30
| ||
| 19:36 | [bf36b063cb] part of check-in [43d4cb5785] Add information about the sqlite3_index_info.colUsed field. (check-in: [43d4cb5785] user: drh branch: trunk, size: 56393) | |
|
2015-11-25
| ||
| 18:42 | [2557617a3d] part of check-in [6b8138c898] Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. (check-in: [6b8138c898] user: drh branch: trunk, size: 55497) | |
|
2015-11-11
| ||
| 20:52 | [384ed86023] part of check-in [04edad8b2f] Fix a typo in the virtual table documentation. (check-in: [04edad8b2f] user: drh branch: trunk, size: 55258) | |
|
2015-10-12
| ||
| 18:04 | [33d41c85c4] part of check-in [63898e2980] Fix typos. (check-in: [63898e2980] user: drh branch: trunk, size: 55258) | |
| 05:51 | [9df3fb379f] part of check-in [1c92bfea70] More documentation updates for 3.9.0. (check-in: [1c92bfea70] user: drh branch: trunk, size: 55259) | |
|
2015-10-07
| ||
| 22:42 | [7c82a6653b] part of check-in [255ed0fac7] Fix a couple typos in the new docs. (check-in: [255ed0fac7] user: mistachkin branch: trunk, size: 54705) | |
|
2015-09-11
| ||
| 17:17 | [fe1e3f8f23] part of check-in [a8cbed7cc9] Improvements and fixes to the eponymous virtual table documentation. (check-in: [a8cbed7cc9] user: drh branch: trunk, size: 54708) | |
| 16:14 | [e4342f884a] part of check-in [af1be7762c] Minor updates to json1 and table-valued function documentation. (check-in: [af1be7762c] user: drh branch: trunk, size: 54373) | |
|
2015-09-08
| ||
| 21:33 | [e6182d8b67] part of check-in [9b1f04e2d1] Improved documentation for table-valued functions and eponymous virtual tables. (check-in: [9b1f04e2d1] user: drh branch: trunk, size: 54255) | |
| 18:41 | [464f298fa9] part of check-in [456508e2ed] Updates to the change log for 3.8.12. Add documentation for eponymous virtual tables, for table-valued functions, and other new capabilities. (check-in: [456508e2ed] user: drh branch: trunk, size: 53024) | |
| 16:25 | [4cd63307ed] part of check-in [d9a422f858] Update language documentation to begin describing new features: (1) indexes on expressions (2) table-valued functions (3) column names on VIEWs. (check-in: [d9a422f858] user: drh branch: trunk, size: 49930) | |
|
2015-08-19
| ||
| 13:55 | [bc6a8ec068] part of check-in [26089f7cd9] Fix the argvIndex description in the virtual table documentation. (check-in: [26089f7cd9] user: drh branch: trunk, size: 49439) | |
|
2014-10-25
| ||
| 13:09 | [e47080223b] part of check-in [66c36ec0c8] Fix a paragraph number in the vtab.html document. (check-in: [66c36ec0c8] user: drh branch: trunk, size: 49438) | |
|
2014-07-24
| ||
| 14:39 | [f035907454] part of check-in [77f80a4186] Add documentation for sqlite3_index_info.estimatedRows, part of the virtual table interface. (check-in: [77f80a4186] user: dan branch: trunk, size: 49438) | |
|
2014-07-03
| ||
| 11:15 | [937faaebdf] part of check-in [34e181958c] Fix a typo in vtab.html. (check-in: [34e181958c] user: dan branch: trunk, size: 48580) | |
|
2013-06-21
| ||
| 08:00 | [7f5e298342] part of check-in [a93d66e412] Fix another minor typo in the vtable docs. (check-in: [a93d66e412] user: mistachkin branch: trunk, size: 48585) | |
|
2013-05-29
| ||
| 06:57 | [e1514410e4] part of check-in [44d1e198ca] Fix minor typo in the virtual table documentation for xCreate and xConnect. (check-in: [44d1e198ca] user: mistachkin branch: trunk, size: 48584) | |
|
2013-03-09
| ||
| 15:12 | [ca8fded095] part of check-in [8a8b9f4250] Fix various documentation typos. (check-in: [8a8b9f4250] user: drh branch: trunk, size: 48578) | |
|
2012-10-29
| ||
| 19:14 | [20cebe70db] part of check-in [1974081af3] Fix typos in the documentation of xDisconnect and xDestroy methods of virtual tables. (check-in: [1974081af3] user: drh branch: trunk, size: 48584) | |
|
2011-06-20
| ||
| 21:48 | [b88b3a0851] part of check-in [b503d1f516] Documentation typos. (check-in: [b503d1f516] user: drh branch: trunk, size: 48584) | |
|
2011-05-24
| ||
| 00:52 | [a4515675af] part of check-in [3dded2adf9] Added preliminary documentation for the SAVEPOINT methods in virtual tables. (check-in: [3dded2adf9] user: drh branch: trunk, size: 48583) | |
|
2010-11-26
| ||
| 21:06 | [f9833014be] part of check-in [b8865a0011] Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. (check-in: [b8865a0011] user: drh branch: trunk, size: 46974) | |
|
2010-09-02
| ||
| 04:20 | [a45745629e] part of check-in [db66d3a1d4] More typo fixes. (check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 46600) | |
|
2010-09-01
| ||
| 11:49 | [4b3954d964] part of check-in [ddcf89bab0] New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. (check-in: [ddcf89bab0] user: drh branch: trunk, size: 46601) | |
|
2010-08-28
| ||
| 05:48 | [f3723de64e] part of check-in [78fe166463] Fix documentation typos. (check-in: [78fe166463] user: shaneh branch: trunk, size: 46597) | |
|
2010-08-13
| ||
| 17:44 | [3f2067feb7] part of check-in [17093bc7d6] Enhancements to the description of how the COLLATE operator works. (check-in: [17093bc7d6] user: drh branch: trunk, size: 46596) | |
|
2010-08-09
| ||
| 15:45 | [86c15ceff2] part of check-in [d9e242f92a] Fix a bunch of documentation typos reported on the mailing list. (check-in: [d9e242f92a] user: drh branch: trunk, size: 46594) | |
|
2009-08-06
| ||
| 17:47 | [0208341f4b] part of check-in [68debd1491] Change docs to talk about the fact that virtual tables and shared cache can be used together beginning with version 3.6.17. (check-in: [68debd1491] user: drh branch: trunk, size: 46595) | |
|
2009-07-30
| ||
| 10:51 | [39187f02fc] part of check-in [f7aa8bfebf] Update documentation to talk about 100% test coverage in SQLite. (check-in: [f7aa8bfebf] user: drh branch: trunk, size: 46591) | |
|
2009-07-29
| ||
| 23:07 | [c906dae116] part of check-in [ab7c4f5247] Merge lang.html and vtab.html corrections that got marooned on a branch into the main line. (check-in: [ab7c4f5247] user: drh branch: trunk, size: 47234) | |
|
2009-04-15
| ||
| 12:56 | [79514e25ae] part of check-in [e9e994caf8] Fix typos in the vtab.html document. (check-in: [e9e994caf8] user: drh branch: trunk, size: 46731) | |
|
2009-04-14
| ||
| 18:20 | [f56b52a2e0] part of check-in [0d0a959a73] More virtual table documentation tweaks. (check-in: [0d0a959a73] user: drh branch: trunk, size: 46670) | |
| 18:15 | [b3b857dfdc] part of check-in [feccb40483] Update to the virtual table documentation - in particular the documentation on the xUpdate method. (check-in: [feccb40483] user: drh branch: trunk, size: 46462) | |
| 11:45 | [dcc0f7756a] part of check-in [9ef2178fee] Additional virtual table documentation improvements. Fix the "when-to-use" document to omit discussion of the obsolete bitmap size limits. (check-in: [9ef2178fee] user: drh branch: trunk, size: 45907) | |
|
2009-04-13
| ||
| 18:04 | [562ed5eb22] part of check-in [9acad193dd] Fix a requirement number conflict in fileformat.in. Enhanced and expanded vtab.in. (check-in: [9acad193dd] user: drh branch: trunk, size: 45551) | |
| 14:43 | [db095cd2aa] part of check-in [ebd923dab6] Further enhancements to the virtual table documentation. (check-in: [ebd923dab6] user: drh branch: trunk, size: 36532) | |
| 12:58 | Added: [7bfdd6afc6] part of check-in [0776bf4007] Initial check-in of documentation on the virtual table interface. (check-in: [0776bf4007] user: drh branch: trunk, size: 34909) | |