Mark
See #4308 We should support the `UNION BY NAME` operator to union together tables with re-ordered and potentially new columns. This operator is useful for unifying data from an evolving...
We want to add support for tagged union types to DuckDB. The tagged union would allow multiple types to co-exist within the same column, similar to the way a C-style...
The `test_all_types()` (see #2739) function needs to be integrated with all client connectors. This will ensure all client connectors support all types, and they continue to support all types. We...
We want to support PIVOT/UNPIVOT in DuckDB. The base syntax could be similar to [the syntax used in SQL server](https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15), e.g.: ```sql SELECT * FROM Product PIVOT ( AVG(StandardCost) FOR...
This is supported by both SQLite and PostgreSQL, so we probably should too https://www.sqlite.org/lang_UPSERT.html
In the CI we have several dependencies that we are not fixing to a specific version and just installing with pip, e.g.: ```shell pip install --prefer-binary "pandas>=1.2.4" "requests>=2.26" "pyarrow==8.0" "psutil>=5.9.0"...
There is a typo in the definition: ``` set(INGORE_WARNINGS OFF) build_loadable_extension(json ${JSON_EXTENSION_FILES} ${IGNORE_WARNINGS}) ``` This causes the flag to be empty, and because CMake is CMake it does not crash...
Constraints should be able to be dropped/created separately from the CREATE TABLE statement (i.e. as separate ALTER TABLE ADD CONSTRAINT statements). Constraints also need names for this.
### What happens? Copy pasting queries containing unicode symbols seems to crash the shell ### To Reproduce Copy paste the following query into the shell: ```sql select substring('🦆🦆🦆' from 3)...
This has to be done so they can be correctly cleaned up when required