Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/tabfunc01.test
|
2025-04-10
| ||
| 10:18 | [8a484fe8b1] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 14119) | |
|
2025-03-22
| ||
| 22:55 | [e85679a380] 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: 14123) | |
|
2025-03-18
| ||
| 20:28 | [80496e856c] 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: 11900) | |
| 20:15 | [76da0509b0] 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: 12155) | |
|
2025-03-13
| ||
| 18:51 | [66d1ea2728] 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: 11729) | |
|
2024-11-05
| ||
| 18:25 | [7be82bd50c] 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: 11474) | |
|
2024-08-22
| ||
| 18:12 | [6002a5f37b] 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: 10907) | |
|
2024-04-26
| ||
| 13:30 | [f150d20629] 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: 10895) | |
|
2023-04-28
| ||
| 23:39 | [54f27eacd0] 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: 10094) | |
|
2023-02-27
| ||
| 14:48 | [668e5e3910] part of check-in [18ee689de3] Further to [46639f682975dac6], the parameters of a table valued function that is on the left side of a RIGHT JOIN do not need to be in the ON clause. Add new test cases and tags to associated test cases with the code. (check-in: [18ee689de3] user: drh branch: trunk, size: 10094) | |
|
2021-12-14
| ||
| 20:13 | [241425ce39] part of check-in [5c3d398d20] Enhance the virtual table query planner so that it is able to deal with ORDER BY terms that contain COLLATE clauses as long as the specified collation matches the virtual table. This is especially important for UNION ALL since a "COLLATE binary" is added to ORDER BY clauses if no COLLATE clause exists in the original SQL. (check-in: [5c3d398d20] user: drh branch: trunk, size: 10058) | |
| 18:11 | [2708073a40] part of check-in [a2e50712fc] Minor fix to the ORDER BY elimination logic in generate_series(). (check-in: [a2e50712fc] user: drh branch: trunk, size: 9685) | |
|
2021-07-16
| ||
| 17:04 | [d6821e7042] 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: 8980) | |
|
2021-04-22
| ||
| 18:02 | [acb5be5588] part of check-in [c7909e8e0d] Raise an error on an attempt to rename an eponymous virtual table. (check-in: [c7909e8e0d] user: drh branch: trunk, size: 8677) | |
|
2019-11-15
| ||
| 00:52 | [5ca6d00415] part of check-in [2c35d3f67b] Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: [2c35d3f67b] user: drh branch: trunk, size: 7397) | |
|
2018-12-03
| ||
| 01:47 | [20e98ffe55] part of check-in [58a51123d1] Fix a parser bug in the use of parentheses around table-valued functions. (check-in: [58a51123d1] user: drh branch: trunk, size: 7078) | |
|
2018-11-05
| ||
| 16:38 | [54300134f7] part of check-in [b8d35c4a7c] Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e]. (check-in: [b8d35c4a7c] user: drh branch: trunk, size: 6927) | |
|
2018-10-01
| ||
| 21:36 | [5ddfdcda81] part of check-in [7694b9bc30] Test case for PRAGMA table_xinfo. (check-in: [7694b9bc30] user: drh branch: pragma-table-vinfo, size: 7003) | |
|
2017-06-30
| ||
| 23:46 | [c47171c36b] part of check-in [a99fa94db7] Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. (check-in: [a99fa94db7] user: drh branch: bind-pointer, size: 6849) | |
|
2017-02-15
| ||
| 17:47 | [10f5a739ad] part of check-in [1d4759c17c] simple test cases for carray_asc. (check-in: [1d4759c17c] user: drh branch: carray_asc, size: 7349) | |
|
2017-02-03
| ||
| 15:16 | [699251cb99] part of check-in [83a099f139] Improved tests for the carray() table-valued function. (check-in: [83a099f139] user: drh branch: trunk, size: 6714) | |
|
2016-08-09
| ||
| 21:08 | [8b2ef53caa] part of check-in [f0942c362f] Prototype for the remember(V,PTR) extension function. (check-in: [f0942c362f] user: drh branch: rememberFunc, size: 6420) | |
|
2016-07-03
| ||
| 02:35 | [50a9fb379f] part of check-in [a204ba99db] Change the name of the intarray() extension to carray() and give it an optional third parameter that specifies the datatype as one of 'int32', 'int64', 'double', or 'char*'. 'int32' is the default. (check-in: [a204ba99db] user: drh branch: prototype-int-array, size: 6076) | |
|
2016-07-02
| ||
| 20:57 | [ebcfb548b8] part of check-in [7c3d441f2a] Fix an off-by-one comparison in the intarray() virtual table. Get the intarray() virtual table tests working using the legacy makefile. (check-in: [7c3d441f2a] user: drh branch: prototype-int-array, size: 6502) | |
| 20:51 | [96e56e22e5] part of check-in [507fdbfb54] Merge the alternative table-valued function RHS of IN operator implementation from trunk. (check-in: [507fdbfb54] user: drh branch: prototype-int-array, size: 6293) | |
| 12:08 | [bb77463991] part of check-in [ac6000f050] Add support for table-valued functions on the RHS of an IN operator. (check-in: [ac6000f050] user: drh branch: trunk, size: 4885) | |
|
2016-06-29
| ||
| 06:19 | [32e620a199] part of check-in [ba1b441b60] Add the ability to have a table-valued function on the RHS of an IN operator. (check-in: [ba1b441b60] user: drh branch: prototype-int-array, size: 5914) | |
| 05:08 | [bb0ef0fdf5] part of check-in [06e1fab752] Another test case for the intarray($PTR,$N) virtual table. (check-in: [06e1fab752] user: drh branch: prototype-int-array, size: 5571) | |
| 05:00 | [a1976cbc37] part of check-in [233b33382d] Add a prototype intarray($PTR,$N) table valued function. (check-in: [233b33382d] user: drh branch: prototype-int-array, size: 4973) | |
|
2016-04-08
| ||
| 21:35 | [e7b2dd45cb] part of check-in [00ac73a01c] Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (check-in: [00ac73a01c] user: drh branch: tabfunc-in-left-join, size: 6203) | |
|
2016-03-02
| ||
| 03:28 | [f977868fa8] 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: 4506) | |
|
2015-11-21
| ||
| 13:24 | [cc33684f94] part of check-in [ff5716b89f] Do not allow table-valued function syntax on ordinary tables and views as those objects are not table-valued functions. Fix for ticket [73eba7ba5c7c0fc]. Problem found by libFuzzer. (check-in: [ff5716b89f] user: drh branch: trunk, size: 3758) | |
|
2015-10-11
| ||
| 19:46 | [03c4ad422c] part of check-in [3d0bd95e97] Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. (check-in: [3d0bd95e97] user: drh branch: trunk, size: 3193) | |
|
2015-09-19
| ||
| 20:27 | [83e63be7b6] part of check-in [97cfe346e1] Do not allow table-valued function syntax to be used on a view. (check-in: [97cfe346e1] user: drh branch: trunk, size: 3040) | |
|
2015-09-08
| ||
| 20:26 | [fa9d8dfc75] part of check-in [06f90bb274] Eponymous virtual tables exist in the "main" schema only. Enforce this rule. (check-in: [06f90bb274] user: drh branch: trunk, size: 2622) | |
|
2015-08-21
| ||
| 17:14 | [a12eba3f48] 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: 2177) | |
|
2015-08-20
| ||
| 23:21 | [d556af2def] 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: 2068) | |
| 20:13 | [ae7f4e5b67] part of check-in [a7acc7878b] Correctly handle empty function argument lists on table-valued functions. (check-in: [a7acc7878b] user: drh branch: trunk, size: 2066) | |
|
2015-08-19
| ||
| 19:01 | [61d185dde7] 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: 1975) | |
| 18:19 | [d69034069c] 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: 1699) | |
| 17:11 | [ca013d7012] part of check-in [40e12cfe4c] A list of arguments following a table name translates into equality constraints against hidden columns in that table. (check-in: [40e12cfe4c] user: drh branch: table-valued-functions, size: 1585) | |
| 15:20 | [0c1fb6ee8e] part of check-in [b919376147] Minor refactor of the SrcList object so that it is able to hold the argument list to a table-valued-function in the FROM clause. (check-in: [b919376147] user: drh branch: table-valued-functions, size: 993) | |
| 13:54 | Added: [239e336a55] 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: 958) | |