/ All files named "ext/misc/series.c"
Login

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

History for ext/misc/series.c

2020-01-21
12:29
[4057dda3] part of check-in [9265cb7f] Fix the series.c and spellfix.c extensions to use SQLITE_VTAB_INNOCUOUS correctly. Fix the documentation on sqlite3_vtab_config() to take into account SQLITE_VTAB_INNOCUOUS and SQLITE_VTAB_DIRECTONLY. (check-in: [9265cb7f] user: drh branch: trunk, size: 13630)
2020-01-07
19:45
[a733a77d] part of check-in [4c21373c] Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: [4c21373c] user: drh branch: new-security-options, size: 13625)
2018-11-16
15:41
[0c97f633] part of check-in [cd13b499] Add an assert() to the generate_series virtual table to verify assumptions about the design. (check-in: [cd13b499] user: drh branch: trunk, size: 13578)
15:08
[2141a38d] part of check-in [4372ad64] Update the generate_series() table-valued function to make use of the new SQLITE_CONSTRAINT return from xBestIndex. (check-in: [4372ad64] user: drh branch: trunk, size: 13544)
2018-04-03
14:25
[c7197db3] part of check-in [3328e828] Fix the generate_series virtual table so that it correctly returns no rows if any of its constraints are NULL. Ticket [fac496b61722daf28]. (check-in: [3328e828] user: drh branch: trunk, size: 13453)
2017-09-05
17:23
[f3c0dba5] part of check-in [868cd196] Fix a comment describing the xRowid method of the "series" virtual table. No code changes. (check-in: [868cd196] user: dan branch: trunk, size: 13156)
2017-06-02
13:16
[b0f5f346] part of check-in [d637feb4] Fix a typo in the header comment of the "series.c" virtual table extension. (check-in: [d637feb4] user: drh branch: trunk, size: 13081)
2016-03-02
03:28
[e11e534a] part of check-in [1622623c] Allow the left-hand side of IN operators on virtual tables to have the aConstraintUsage[].omit flag clear. (check-in: [1622623c] user: drh branch: vtab-IN-opt, size: 13084)
00:58
[e1ef8bc2] part of check-in [3d9daa92] Add the optional -DSERIES_OMIT_CONSTRAINT_VERIFY=0 option to the series.c extension that implements the generate_series() virtual table. (check-in: [3d9daa92] user: drh branch: trunk, size: 13078)
2016-03-01
02:11
[235d6281] part of check-in [f2c16094] Better estimatedCost in the xBestIndex method of the generate_series vtab. (check-in: [f2c16094] user: drh branch: trunk, size: 12697)
2015-08-21
17:14
[b8fb7bef] part of check-in [552bc9cb] Fix a corner-case bug in table-valued functions. Update the generate_series() virtual table to increase the performance estimate penalty for being underspecified. (check-in: [552bc9cb] user: drh branch: trunk, size: 12677)
2015-08-20
23:21
[6f94daf5] part of check-in [774e6a14] Fix corner-case memory management issues in table-valued functions. Change virtual table handling so that if xDestroy is missing the table is eponymous only even if xCreate is present. (check-in: [774e6a14] user: drh branch: trunk, size: 12591)
18:28
[610bf80e] part of check-in [3efc7942] Prevent the series.c extension from loading on older versions of SQLite that do not support xCreate==NULL. (check-in: [3efc7942] user: drh branch: table-valued-functions, size: 12550)
16:16
[e9b658e4] part of check-in [23db7f50] Fix a typo in series.c. (check-in: [23db7f50] user: dan branch: table-valued-functions, size: 12381)
2015-08-19
19:01
[5b84c658] part of check-in [a325a085] Fix eponymous virtual tables so that they do not automatically make the first column the rowid. Enhance the generate_series virtual table to support rowid. (check-in: [a325a085] user: drh branch: table-valued-functions, size: 12380)
18:19
[1484bc67] part of check-in [fef44c37] Improved comments on the generate_series virtual table. Test cases for ORDER BY rowid DESC with generate_series. (check-in: [fef44c37] user: drh branch: table-valued-functions, size: 12297)
13:54
Added: [c2be7ee4] part of check-in [c58426db] Virtual table modules with a null xCreate method act as eponymous-only modules - they cannot be used in a CREATE VIRTUAL TABLE statement. Add the series.c extension that implements a postgres-like generate_series virtual table to demonstrate this capability. (check-in: [c58426db] user: drh branch: table-valued-functions, size: 7463)