/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/tabfunc01.test

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