Documentation Source Text

All files named "pages/vtab.in"
Login

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

History for pages/vtab.in

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)