Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/misc/series.c
|
2025-04-10
| ||
| 10:18 | [e212edb2aa] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 27731) | |
|
2025-03-22
| ||
| 23:03 | [2ef2f7452d] part of check-in [f5aea14e6e] Fixes for two problems with the generate_series() table-valued function. (check-in: [f5aea14e6e] user: drh branch: branch-3.49, size: 27734) | |
| 22:55 | [0c285a2182] part of check-in [c113e31b81] Fix the generate_series() enhancement from check-in [d50b784807333c54] so that it works even if the number that "value" is being compared against is a non-integer floating point number. Bug reported by forum post 0d5d63257. (check-in: [c113e31b81] user: drh branch: trunk, size: 27735) | |
|
2025-03-18
| ||
| 20:28 | [cb6b6ad582] part of check-in [1a8f763c31] Fix two obscure logic problems that cause incorrect answers, found by a third-party fuzzer. (check-in: [1a8f763c31] user: drh branch: branch-3.49, size: 26952) | |
| 20:15 | [076a4c85dd] part of check-in [77db4d85e7] Change the generate_series() table-valued function so that its rowid is just an alias for its value. This allows it to be used as the RHS operand of a RIGHT JOIN. This fixes the issue raised by forum post 1e17219c88. (check-in: [77db4d85e7] user: drh branch: trunk, size: 26803) | |
|
2025-03-13
| ||
| 18:51 | [69e0d2b5d1] part of check-in [75e72e3b0d] Fix the generate_series extension for the case where the termination value is not an even multiple of the step from the start value and there is also a value=NNN constraint in the WHERE clause. Forum post bf2dc8e9 (check-in: [75e72e3b0d] user: drh branch: trunk, size: 26951) | |
|
2025-02-27
| ||
| 21:17 | [13c13768db] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 27101) | |
|
2024-11-05
| ||
| 18:25 | [cbdda2e2eb] part of check-in [f5113a2ef8] Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. (check-in: [f5113a2ef8] user: dan branch: trunk, size: 27100) | |
|
2024-10-24
| ||
| 15:57 | [ea604a16f9] part of check-in [cd82e4c0f5] Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (check-in: [cd82e4c0f5] user: stephan branch: ifdef-SQLITE_CORE, size: 27077) | |
|
2024-10-09
| ||
| 16:32 | [596afbfbbc] part of check-in [41d58a014c] Fix a problem in the generate_series() extension introduced by [d50b784807333c54]. (check-in: [41d58a014c] user: drh branch: trunk, size: 26942) | |
|
2024-08-22
| ||
| 18:12 | [a6089b5e8e] part of check-in [d50b784807] 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: [d50b784807] user: drh branch: trunk, size: 26798) | |
|
2024-04-26
| ||
| 17:09 | [d96e5aac21] part of check-in [b7d9bd7ee2] Further fixes and improvements to the generate_series() enhancements on this branch. (check-in: [b7d9bd7ee2] user: drh branch: vtab-limit-fix, size: 20879) | |
| 14:36 | [ba7c22c607] part of check-in [a94e2cd028] Use hex flag masks rather than decimals in ext/misc/series.c. (check-in: [a94e2cd028] user: drh branch: vtab-limit-fix, size: 20511) | |
| 13:30 | [69df6c989a] part of check-in [408d47ecaa] 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: [408d47ecaa] user: drh branch: vtab-limit-fix, size: 20506) | |
|
2024-01-16
| ||
| 14:54 | [384f93a8a0] part of check-in [f106bc0d21] Remove the LLONG_MAX preprocessor macro from the series.c extension as it is apparently only C99 and later. Forum post 4af649419b. (check-in: [f106bc0d21] user: drh branch: trunk, size: 19426) | |
|
2023-10-06
| ||
| 12:51 | [80692f675d] part of check-in [f3b3d712d6] Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: [f3b3d712d6] user: drh branch: trunk, size: 19447) | |
|
2023-06-19
| ||
| 13:09 | [dde5ba69cb] part of check-in [3c94f87806] Fix large integer constants so that they work on older C compilers. (check-in: [3c94f87806] user: drh branch: trunk, size: 19401) | |
|
2023-05-15
| ||
| 19:17 | [d4001360b2] part of check-in [1d3e008905] Fix a C++-style variable declaration in the generate_series() extension. (check-in: [1d3e008905] user: drh branch: trunk, size: 19303) | |
| 03:48 | [387381db0f] part of check-in [4c5cd3e696] Make generate_series() correct on ones complement ALUs and acceptable to UBSAN. (check-in: [4c5cd3e696] user: larrybr branch: trunk, size: 19289) | |
|
2023-04-29
| ||
| 12:29 | [37d2737768] part of check-in [ecbf7e13e6] Sync w/trunk, improve generate_series() variable names. (check-in: [ecbf7e13e6] user: larrybr branch: generate_series-revamp, size: 18216) | |
|
2023-04-28
| ||
| 23:39 | [bc7cb3bb61] part of check-in [9605db4ae3] 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: [9605db4ae3] user: larrybr branch: generate_series-revamp, size: 18209) | |
| 21:25 | [9553821737] part of check-in [beeea3e1b0] 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: [beeea3e1b0] user: larrybr branch: generate_series-revamp, size: 18116) | |
|
2022-07-22
| ||
| 20:24 | [fba5f7221b] part of check-in [57beb700c0] Add experimental 'xShadowName2' method for virtual table modules. (check-in: [57beb700c0] user: mistachkin branch: xShadowName2, size: 14910) | |
|
2021-12-14
| ||
| 18:11 | [8d79354f2c] part of check-in [a2e50712fc] Minor fix to the ORDER BY elimination logic in generate_series(). (check-in: [a2e50712fc] user: drh branch: trunk, size: 14862) | |
|
2021-10-02
| ||
| 16:39 | [f9896e76b0] part of check-in [bdb9dc8a02] Fix harmless compiler warnings (check-in: [bdb9dc8a02] user: drh branch: trunk, size: 14826) | |
|
2021-07-16
| ||
| 17:04 | [233804fd4e] part of check-in [459d85a289] 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: [459d85a289] user: drh branch: trunk, size: 14811) | |
|
2020-12-03
| ||
| 14:21 | [c6bd5d249e] part of check-in [9b60fc4870] Enhance the generate_series() table-valued function to support negative step values. (check-in: [9b60fc4870] user: drh branch: trunk, size: 14228) | |
|
2020-11-25
| ||
| 16:28 | [fbb8e6be97] part of check-in [25d067c270] Fix harmless compiler warnings about unused function parameters. (check-in: [25d067c270] user: drh branch: trunk, size: 13989) | |
|
2020-01-21
| ||
| 12:29 | [4057dda357] part of check-in [9265cb7f02] 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: [9265cb7f02] user: drh branch: trunk, size: 13630) | |
|
2020-01-07
| ||
| 19:45 | [a733a77d15] part of check-in [4c21373c21] Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: [4c21373c21] user: drh branch: new-security-options, size: 13625) | |
|
2018-11-16
| ||
| 15:41 | [0c97f63378] part of check-in [cd13b499a2] Add an assert() to the generate_series virtual table to verify assumptions about the design. (check-in: [cd13b499a2] user: drh branch: trunk, size: 13578) | |
| 15:08 | [2141a38d14] part of check-in [4372ad644d] Update the generate_series() table-valued function to make use of the new SQLITE_CONSTRAINT return from xBestIndex. (check-in: [4372ad644d] user: drh branch: trunk, size: 13544) | |
|
2018-04-03
| ||
| 14:25 | [c7197db304] part of check-in [3328e828e2] Fix the generate_series virtual table so that it correctly returns no rows if any of its constraints are NULL. Ticket [fac496b61722daf28]. (check-in: [3328e828e2] user: drh branch: trunk, size: 13453) | |
|
2017-09-05
| ||
| 17:23 | [f3c0dba5c5] part of check-in [868cd19600] Fix a comment describing the xRowid method of the "series" virtual table. No code changes. (check-in: [868cd19600] user: dan branch: trunk, size: 13156) | |
|
2017-06-02
| ||
| 13:16 | [b0f5f346ac] part of check-in [d637feb4e3] Fix a typo in the header comment of the "series.c" virtual table extension. (check-in: [d637feb4e3] user: drh branch: trunk, size: 13081) | |
|
2016-03-02
| ||
| 03:28 | [e11e534ada] part of check-in [1622623cbb] Allow the left-hand side of IN operators on virtual tables to have the aConstraintUsage[].omit flag clear. (check-in: [1622623cbb] user: drh branch: vtab-IN-opt, size: 13084) | |
| 00:58 | [e1ef8bc233] part of check-in [3d9daa929c] Add the optional -DSERIES_OMIT_CONSTRAINT_VERIFY=0 option to the series.c extension that implements the generate_series() virtual table. (check-in: [3d9daa929c] user: drh branch: trunk, size: 13078) | |
|
2016-03-01
| ||
| 02:11 | [235d628139] part of check-in [f2c16094a5] Better estimatedCost in the xBestIndex method of the generate_series vtab. (check-in: [f2c16094a5] user: drh branch: trunk, size: 12697) | |
|
2015-08-21
| ||
| 17:14 | [b8fb7befd8] part of check-in [552bc9cb88] 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: [552bc9cb88] user: drh branch: trunk, size: 12677) | |
|
2015-08-20
| ||
| 23:21 | [6f94daf590] part of check-in [774e6a14b1] 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: [774e6a14b1] user: drh branch: trunk, size: 12591) | |
| 18:28 | [610bf80e8e] part of check-in [3efc79427e] Prevent the series.c extension from loading on older versions of SQLite that do not support xCreate==NULL. (check-in: [3efc79427e] user: drh branch: table-valued-functions, size: 12550) | |
| 16:16 | [e9b658e442] part of check-in [23db7f50f1] Fix a typo in series.c. (check-in: [23db7f50f1] user: dan branch: table-valued-functions, size: 12381) | |
|
2015-08-19
| ||
| 19:01 | [5b84c6584a] part of check-in [a325a08599] 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: [a325a08599] user: drh branch: table-valued-functions, size: 12380) | |
| 18:19 | [1484bc674b] part of check-in [fef44c37f3] Improved comments on the generate_series virtual table. Test cases for ORDER BY rowid DESC with generate_series. (check-in: [fef44c37f3] user: drh branch: table-valued-functions, size: 12297) | |
| 13:54 | Added: [c2be7ee419] part of check-in [c58426dbd5] 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: [c58426dbd5] user: drh branch: table-valued-functions, size: 7463) | |