Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/misc/series.c
|
2024-11-05
| ||
| 18:25 | [cbdda2e2] part of check-in [f5113a2e] Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. (check-in: [f5113a2e] user: dan branch: trunk, size: 27100) | |
|
2024-10-24
| ||
| 15:57 | [ea604a16] part of check-in [cd82e4c0] Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (check-in: [cd82e4c0] user: stephan branch: ifdef-SQLITE_CORE, size: 27077) | |
|
2024-10-09
| ||
| 16:32 | [596afbfb] part of check-in [41d58a01] Fix a problem in the generate_series() extension introduced by [d50b784807333c54]. (check-in: [41d58a01] user: drh branch: trunk, size: 26942) | |
|
2024-08-22
| ||
| 18:12 | [a6089b5e] part of check-in [d50b7848] Enhance the generate_series() table-valued function such that it is able to recognize equality and inequality constraints on the "value" column and optimize its operating accordingly. (check-in: [d50b7848] user: drh branch: trunk, size: 26798) | |
|
2024-04-26
| ||
| 17:09 | [d96e5aac] part of check-in [b7d9bd7e] Further fixes and improvements to the generate_series() enhancements on this branch. (check-in: [b7d9bd7e] user: drh branch: vtab-limit-fix, size: 20879) | |
| 14:36 | [ba7c22c6] part of check-in [a94e2cd0] Use hex flag masks rather than decimals in ext/misc/series.c. (check-in: [a94e2cd0] user: drh branch: vtab-limit-fix, size: 20511) | |
| 13:30 | [69df6c98] part of check-in [408d47ec] Enhance the generated_series() table-valued-function to respond to LIMIT and OFFSET. Use this to add new test cases for LIMIT and OFFSET on virtual tables in a compound SELECT. (check-in: [408d47ec] user: drh branch: vtab-limit-fix, size: 20506) | |
|
2024-01-16
| ||
| 14:54 | [384f93a8] part of check-in [f106bc0d] Remove the LLONG_MAX preprocessor macro from the series.c extension as it is apparently only C99 and later. Forum post 4af649419b. (check-in: [f106bc0d] user: drh branch: trunk, size: 19426) | |
|
2023-10-06
| ||
| 12:51 | [80692f67] part of check-in [f3b3d712] Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: [f3b3d712] user: drh branch: trunk, size: 19447) | |
|
2023-06-19
| ||
| 13:09 | [dde5ba69] part of check-in [3c94f878] Fix large integer constants so that they work on older C compilers. (check-in: [3c94f878] user: drh branch: trunk, size: 19401) | |
|
2023-05-15
| ||
| 19:17 | [d4001360] part of check-in [1d3e0089] Fix a C++-style variable declaration in the generate_series() extension. (check-in: [1d3e0089] user: drh branch: trunk, size: 19303) | |
| 03:48 | [387381db] part of check-in [4c5cd3e6] Make generate_series() correct on ones complement ALUs and acceptable to UBSAN. (check-in: [4c5cd3e6] user: larrybr branch: trunk, size: 19289) | |
|
2023-04-29
| ||
| 12:29 | [37d27377] part of check-in [ecbf7e13] Sync w/trunk, improve generate_series() variable names. (check-in: [ecbf7e13] user: larrybr branch: generate_series-revamp, size: 18216) | |
|
2023-04-28
| ||
| 23:39 | [bc7cb3bb] part of check-in [9605db4a] Add tests for generate_series(), fix a so bug found, and change an existing test that enforced varying rowid-to-value mapping with query ordering. (That no longer varies.) (check-in: [9605db4a] user: larrybr branch: generate_series-revamp, size: 18209) | |
| 21:25 | [95538217] part of check-in [beeea3e1] Revise generate_series() extension (in CLI) to address overflow reported in forum post #754e2d4db2a5 and to make behavior better match the like-named PostgreSQL function. (check-in: [beeea3e1] user: larrybr branch: generate_series-revamp, size: 18116) | |
|
2022-07-22
| ||
| 20:24 | [fba5f722] part of check-in [57beb700] Add experimental 'xShadowName2' method for virtual table modules. (check-in: [57beb700] user: mistachkin branch: xShadowName2, size: 14910) | |
|
2021-12-14
| ||
| 18:11 | [8d79354f] part of check-in [a2e50712] Minor fix to the ORDER BY elimination logic in generate_series(). (check-in: [a2e50712] user: drh branch: trunk, size: 14862) | |
|
2021-10-02
| ||
| 16:39 | [f9896e76] part of check-in [bdb9dc8a] Fix harmless compiler warnings (check-in: [bdb9dc8a] user: drh branch: trunk, size: 14826) | |
|
2021-07-16
| ||
| 17:04 | [233804fd] part of check-in [459d85a2] Modify the generate_series() table-valued functions so that its first argument (the START value) is required. Throw an error if that argument is not supplied. In this was the series.c loadable extension can be used as a demonstration of how to code an xBestIndex function to require certain parameters. Compile with -DZERO_ARGUMENT_GENERATE_SERIES to obtain the legacy behavior. (check-in: [459d85a2] user: drh branch: trunk, size: 14811) | |
|
2020-12-03
| ||
| 14:21 | [c6bd5d24] part of check-in [9b60fc48] Enhance the generate_series() table-valued function to support negative step values. (check-in: [9b60fc48] user: drh branch: trunk, size: 14228) | |
|
2020-11-25
| ||
| 16:28 | [fbb8e6be] part of check-in [25d067c2] Fix harmless compiler warnings about unused function parameters. (check-in: [25d067c2] user: drh branch: trunk, size: 13989) | |
|
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) | |