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 | |