/ History for test/tabfunc01.test
Login

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