Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/tabfunc01.test
|
2019-11-15
| ||
| 00:52 | [5ca6d004] part of check-in [2c35d3f6] Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: [2c35d3f6] user: drh branch: trunk, size: 7397) | |
|
2018-12-03
| ||
| 01:47 | [20e98ffe] part of check-in [58a51123] Fix a parser bug in the use of parentheses around table-valued functions. (check-in: [58a51123] user: drh branch: trunk, size: 7078) | |
|
2018-11-05
| ||
| 16:38 | [54300134] part of check-in [b8d35c4a] 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: [b8d35c4a] user: drh branch: trunk, size: 6927) | |
|
2018-10-01
| ||
| 21:36 | [5ddfdcda] part of check-in [7694b9bc] Test case for PRAGMA table_xinfo. (check-in: [7694b9bc] user: drh branch: pragma-table-vinfo, size: 7003) | |
|
2017-06-30
| ||
| 23:46 | [c47171c3] part of check-in [a99fa94d] Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. (check-in: [a99fa94d] user: drh branch: bind-pointer, size: 6849) | |
|
2017-02-15
| ||
| 17:47 | [10f5a739] part of check-in [1d4759c1] simple test cases for carray_asc. (check-in: [1d4759c1] user: drh branch: carray_asc, size: 7349) | |
|
2017-02-03
| ||
| 15:16 | [699251cb] part of check-in [83a099f1] Improved tests for the carray() table-valued function. (check-in: [83a099f1] user: drh branch: trunk, size: 6714) | |
|
2016-08-09
| ||
| 21:08 | [8b2ef53c] part of check-in [f0942c36] Prototype for the remember(V,PTR) extension function. (check-in: [f0942c36] user: drh branch: rememberFunc, size: 6420) | |
|
2016-07-03
| ||
| 02:35 | [50a9fb37] part of check-in [a204ba99] 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: [a204ba99] user: drh branch: prototype-int-array, size: 6076) | |
|
2016-07-02
| ||
| 20:57 | [ebcfb548] part of check-in [7c3d441f] Fix an off-by-one comparison in the intarray() virtual table. Get the intarray() virtual table tests working using the legacy makefile. (check-in: [7c3d441f] user: drh branch: prototype-int-array, size: 6502) | |
| 20:51 | [96e56e22] part of check-in [507fdbfb] Merge the alternative table-valued function RHS of IN operator implementation from trunk. (check-in: [507fdbfb] user: drh branch: prototype-int-array, size: 6293) | |
| 12:08 | [bb774639] part of check-in [ac6000f0] Add support for table-valued functions on the RHS of an IN operator. (check-in: [ac6000f0] user: drh branch: trunk, size: 4885) | |
|
2016-06-29
| ||
| 06:19 | [32e620a1] part of check-in [ba1b441b] Add the ability to have a table-valued function on the RHS of an IN operator. (check-in: [ba1b441b] user: drh branch: prototype-int-array, size: 5914) | |
| 05:08 | [bb0ef0fd] part of check-in [06e1fab7] Another test case for the intarray($PTR,$N) virtual table. (check-in: [06e1fab7] user: drh branch: prototype-int-array, size: 5571) | |
| 05:00 | [a1976cbc] part of check-in [233b3338] Add a prototype intarray($PTR,$N) table valued function. (check-in: [233b3338] user: drh branch: prototype-int-array, size: 4973) | |
|
2016-04-08
| ||
| 21:35 | [e7b2dd45] part of check-in [00ac73a0] 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: [00ac73a0] user: drh branch: tabfunc-in-left-join, size: 6203) | |
|
2016-03-02
| ||
| 03:28 | [f977868f] 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: 4506) | |
|
2015-11-21
| ||
| 13:24 | [cc33684f] part of check-in [ff5716b8] 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: [ff5716b8] user: drh branch: trunk, size: 3758) | |
|
2015-10-11
| ||
| 19:46 | [03c4ad42] part of check-in [3d0bd95e] Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. (check-in: [3d0bd95e] user: drh branch: trunk, size: 3193) | |
|
2015-09-19
| ||
| 20:27 | [83e63be7] part of check-in [97cfe346] Do not allow table-valued function syntax to be used on a view. (check-in: [97cfe346] user: drh branch: trunk, size: 3040) | |
|
2015-09-08
| ||
| 20:26 | [fa9d8dfc] part of check-in [06f90bb2] Eponymous virtual tables exist in the "main" schema only. Enforce this rule. (check-in: [06f90bb2] user: drh branch: trunk, size: 2622) | |
|
2015-08-21
| ||
| 17:14 | [a12eba3f] 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: 2177) | |
|
2015-08-20
| ||
| 23:21 | [d556af2d] 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: 2068) | |
| 20:13 | [ae7f4e5b] part of check-in [a7acc787] Correctly handle empty function argument lists on table-valued functions. (check-in: [a7acc787] user: drh branch: trunk, size: 2066) | |
|
2015-08-19
| ||
| 19:01 | [61d185dd] 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: 1975) | |
| 18:19 | [d6903406] 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: 1699) | |
| 17:11 | [ca013d70] part of check-in [40e12cfe] A list of arguments following a table name translates into equality constraints against hidden columns in that table. (check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 1585) | |
| 15:20 | [0c1fb6ee] part of check-in [b9193761] 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: [b9193761] user: drh branch: table-valued-functions, size: 993) | |
| 13:54 | [239e336a] 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: 958) Added | |