|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1 |
|
| #
52576b78 |
| 14-Dec-2021 |
drh <> |
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 i
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.
FossilOrigin-Name: 5c3d398d20b86a1558720e995eddf11403aec2d160590571fa9525fe8f6efff9
show more ...
|
| #
22f018c9 |
| 14-Dec-2021 |
drh <> |
Minor fix to the ORDER BY elimination logic in generate_series().
FossilOrigin-Name: a2e50712fca9dff1b8d19631f792270c82da3c8696a5d9890cf0d1e13e950d60
|
|
Revision tags: version-3.37.0 |
|
| #
e46ec734 |
| 16-Jul-2021 |
drh <> |
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 exte
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.
FossilOrigin-Name: 459d85a2898d6a53f43b4ad48d2f39edd1bbe37a4f97426a5d666c39c52576a4
show more ...
|
|
Revision tags: version-3.36.0 |
|
| #
3d8c92d0 |
| 22-Apr-2021 |
drh <> |
Raise an error on an attempt to rename an eponymous virtual table.
FossilOrigin-Name: c7909e8e0d0577c6109f13c0b14fb565239aae8af8963d659f363e124f3437fc
|
|
Revision tags: version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0 |
|
| #
8103a036 |
| 15-Nov-2019 |
drh <[email protected]> |
Fix table-valued functions so that they will work as the right table
in a LEFT JOIN. Ticket [2ae0c599b735d59e]
FossilOrigin-Name: 2c35d3f67b67a53ead08b1c395e7ca8e5bf65f94a5a962a0562994a3c66c95d9
|
|
Revision tags: version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0 |
|
| #
4a5cff73 |
| 03-Dec-2018 |
drh <[email protected]> |
Fix a parser bug in the use of parentheses around table-valued functions.
FossilOrigin-Name: 58a51123d1a6381cc67d3c64ba3468ec5a92c299ad6fd86de0b843d0ffafb846
|
|
Revision tags: version-3.26.0, version-3.25.3 |
|
| #
9196c814 |
| 05-Nov-2018 |
drh <[email protected]> |
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 [1fa74930ab
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].
FossilOrigin-Name: b8d35c4a7c99ce3753761e5b81269d52c3c910c603fa70b72549883ba68bc485
show more ...
|
| #
bfbf7d9d |
| 01-Oct-2018 |
drh <[email protected]> |
Test case for PRAGMA table_xinfo.
FossilOrigin-Name: 7694b9bc3003db6ba0b41c5029c8f7b84c07724e7a518e835e98b3c46e4ea227
|
|
Revision tags: version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0 |
|
| #
3561dd4a |
| 30-Jun-2017 |
drh <[email protected]> |
Update the carray() and remember() extension functions so that they user
the new sqlite3_value_pointer() interface.
FossilOrigin-Name: a99fa94db7185b8eaf3c9b184cb1479f8b3d5781f71f1717a4b3f2dd1d184fe4
|
|
Revision tags: version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0 |
|
| #
59a40db3 |
| 03-Feb-2017 |
drh <[email protected]> |
Improved tests for the carray() table-valued function.
FossilOrigin-Name: 83a099f139aba03edac19c890a0019e922032a25
|
|
Revision tags: version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1 |
|
| #
6bada272 |
| 09-Aug-2016 |
drh <[email protected]> |
Prototype for the remember(V,PTR) extension function.
FossilOrigin-Name: f0942c362f45ca1e986e142dbdd3ad957626dfb1
|
|
Revision tags: version-3.14.0 |
|
| #
2e3f87ae |
| 03-Jul-2016 |
drh <[email protected]> |
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.
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.
FossilOrigin-Name: a204ba99db34b356acb259189158a32d2df25da0
show more ...
|
| #
ba637157 |
| 02-Jul-2016 |
drh <[email protected]> |
Fix an off-by-one comparison in the intarray() virtual table. Get the
intarray() virtual table tests working using the legacy makefile.
FossilOrigin-Name: 7c3d441f2a9f642f3d91dcee854a4d16d298bc34
|
| #
5fbab882 |
| 02-Jul-2016 |
drh <[email protected]> |
Add support for table-valued functions on the RHS of an IN operator.
FossilOrigin-Name: ac6000f050ff4efcf8a87f0825077dbf4144f073
|
| #
2d053314 |
| 29-Jun-2016 |
drh <[email protected]> |
Add the ability to have a table-valued function on the RHS of an IN operator.
FossilOrigin-Name: ba1b441b6003808810667d749635fe6b2e8c6165
|
| #
64131c15 |
| 29-Jun-2016 |
drh <[email protected]> |
Another test case for the intarray($PTR,$N) virtual table.
FossilOrigin-Name: 06e1fab7527c6b4330a58f8d8873afaf2d67ae86
|
| #
4841624a |
| 29-Jun-2016 |
drh <[email protected]> |
Add a prototype intarray($PTR,$N) table valued function.
FossilOrigin-Name: 233b33382dc70de45f90b6dfdb5785f20b21489e
|
|
Revision tags: version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1 |
|
| #
dbc49161 |
| 02-Mar-2016 |
drh <[email protected]> |
Allow the left-hand side of IN operators on virtual tables to have the
aConstraintUsage[].omit flag clear.
FossilOrigin-Name: 1622623cbbfc4325c53d731aba78ca9c382ec612
|
|
Revision tags: version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0 |
|
| #
20292310 |
| 21-Nov-2015 |
drh <[email protected]> |
Do not allow table-valued function syntax on ordinary tables and views as those
objects are not table-valued functions.
Fix for ticket [73eba7ba5c7c0fc].
FossilOrigin-Name: ff5716b89f99d9c4568a39f1f
Do not allow table-valued function syntax on ordinary tables and views as those
objects are not table-valued functions.
Fix for ticket [73eba7ba5c7c0fc].
FossilOrigin-Name: ff5716b89f99d9c4568a39f1f52524528a631623
show more ...
|
|
Revision tags: version-3.9.2, version-3.9.1, version-3.9.0 |
|
| #
d12b6363 |
| 11-Oct-2015 |
drh <[email protected]> |
Improved substitution logic in the query flattener. Saves code space, and
(more importantly) works correctly with table-valued functions.
FossilOrigin-Name: 3d0bd95e977db50c314d33ec292f99e0539d7b4a
|
| #
6230212f |
| 19-Sep-2015 |
drh <[email protected]> |
Do not allow table-valued function syntax to be used on a view.
FossilOrigin-Name: 97cfe346e140e42a604375551f8168276bdbea11
|
| #
b4d472f6 |
| 08-Sep-2015 |
drh <[email protected]> |
Eponymous virtual tables exist in the "main" schema only. Enforce this rule.
FossilOrigin-Name: 06f90bb274c4bb0c30585024c8d365d43c4162f2
|
| #
1f2fc281 |
| 21-Aug-2015 |
drh <[email protected]> |
Fix a corner-case bug in table-valued functions. Update the generate_series()
virtual table to increase the performance estimate penalty for being
underspecified.
FossilOrigin-Name: 552bc9cb88bbe54
Fix a corner-case bug in table-valued functions. Update the generate_series()
virtual table to increase the performance estimate penalty for being
underspecified.
FossilOrigin-Name: 552bc9cb88bbe54b4cf5fdf66d1217e7a2047110
show more ...
|
| #
d8b1bfc6 |
| 20-Aug-2015 |
drh <[email protected]> |
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.
FossilOrigin
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.
FossilOrigin-Name: 774e6a14b124bbae4da0e188b62aee9ffb8c3745
show more ...
|
| #
d10dbad5 |
| 20-Aug-2015 |
drh <[email protected]> |
Correctly handle empty function argument lists on table-valued functions.
FossilOrigin-Name: a7acc7878b8bb8e27a0da67b2dbb7bd51df4859b
|