1.1.0
DuckDB 1.1.0 "Eatoni"
This release of DuckDB is named "Eatoni" after Eaton's pintail (Anas Eatoni) from the southern Indian Ocean.
Please also refer to the announcement blog post: https://duckdb.org/2024/09/09/announcing-duckdb-110
What's Changed
- Add feature changes back in by @Mytherin in https://github.com/duckdb/duckdb/pull/11146
- Make
MultiFileReaderfilename configurable by @lnkuiper in https://github.com/duckdb/duckdb/pull/11178 - [Dev] Fix compilation issues on
featureby @Tishj in https://github.com/duckdb/duckdb/pull/11082 - add query() and query_table() functions by @chrisiou in https://github.com/duckdb/duckdb/pull/10586
- [Block Size] Move the block allocation size into the block manager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11176
- LIMIT pushdown below PROJECT by @jeewonhh in https://github.com/duckdb/duckdb/pull/11112
- BUGFIX: IN () filter with one argument should translate to = filter. by @Tmonster in https://github.com/duckdb/duckdb/pull/11473
- Regression Script should calculate micro benchmark differences with the correct base branch by @Tmonster in https://github.com/duckdb/duckdb/pull/11762
- Pushdown filters on window partitions by @Tmonster in https://github.com/duckdb/duckdb/pull/10932
- Arrow ListView Type by @Tishj in https://github.com/duckdb/duckdb/pull/10766
- Add scalar function support to the C API by @Mytherin in https://github.com/duckdb/duckdb/pull/11786
- Add TopN optimization in physical plan mapping by @kryonix in https://github.com/duckdb/duckdb/pull/11290
- Join-dependent filter derivation by @lnkuiper in https://github.com/duckdb/duckdb/pull/11272
- Implement
ROW_GROUPS_PER_FILEfor Parquet by @lnkuiper in https://github.com/duckdb/duckdb/pull/11249 - Prefer Final projected columns on probe side if cardinalities are similar by @Tmonster in https://github.com/duckdb/duckdb/pull/11109
- Propagate unused columns to distinct on by @Tmonster in https://github.com/duckdb/duckdb/pull/11006
- Separate eviction queues by
FileBufferTypeby @lnkuiper in https://github.com/duckdb/duckdb/pull/11417 - Disable false positive for vector size nightly in test by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11953
- Rework jemalloc extension by @lnkuiper in https://github.com/duckdb/duckdb/pull/11891
- Tweak jemalloc config by @lnkuiper in https://github.com/duckdb/duckdb/pull/12034
- Httpfs test to nightly by @carlopi in https://github.com/duckdb/duckdb/pull/12196
- Removed three reinterpret casts and some rewriting by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12200
- Begin Profiling Rework to move towards Modularity by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11101
- [CLI] Add highlighting + limited auto-complete for shell dot commands by @Mytherin in https://github.com/duckdb/duckdb/pull/12201
- Skip test to fix block size nightly and add more explicit error checking by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12211
- Remove BLOCK_ALLOC_SIZE from the column segment files by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11474
- [Julia] - Added optional
schemainput argument toDuckDB.Appenderconstructor by @curtd in https://github.com/duckdb/duckdb/pull/12174 - Fix Mark Index in the Bound Join Ref by @pdet in https://github.com/duckdb/duckdb/pull/12263
- Fix for CI Regression Failure by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12273
- 🦆 by @samansmink in https://github.com/duckdb/duckdb/pull/12303
- Disable
JEMALLOC_RETAINby @lnkuiper in https://github.com/duckdb/duckdb/pull/12185 - Enforce compression extensions for CSV Files by @pdet in https://github.com/duckdb/duckdb/pull/11903
- Make spuriously failing test more robust by @lnkuiper in https://github.com/duckdb/duckdb/pull/12306
- Add new extensions to issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/12313
- [Fix] Block size nightly run by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12283
- Spell Check | Nothing Major | Corrected base_scanner.cpp by @nj7 in https://github.com/duckdb/duckdb/pull/12282
- add duckdb_bind_timestamp_tz function to C API by @karlseguin in https://github.com/duckdb/duckdb/pull/12151
- [Python] Add some date/datetime functions to pyspark api by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12075
- Fixes to Windows workflow and ubuntu_18 action by @carlopi in https://github.com/duckdb/duckdb/pull/12308
- [Extension Dev] Forward declare re2 in
hive_partitioning.hppby @Tishj in https://github.com/duckdb/duckdb/pull/12302 - add expected errors to test/sql/copy/per_thread_output.test by @hmeriann in https://github.com/duckdb/duckdb/pull/12280
- Issue #12287: ICU Strptime Lists by @hawkfish in https://github.com/duckdb/duckdb/pull/12295
- Issue #12171: Streaming Window FILTER by @hawkfish in https://github.com/duckdb/duckdb/pull/12250
- [Python] Update the Connection wrapper generation, now generates c++ code by @Tishj in https://github.com/duckdb/duckdb/pull/12216
- Use iterator buffer position when storing buffer handles by @pdet in https://github.com/duckdb/duckdb/pull/12315
- Bump Julia client to v0.10.3 by @Mytherin in https://github.com/duckdb/duckdb/pull/12323
- Fix #12286 - in the MetadataManager, prefer to allocate new blocks if the next free block id is smaller than the currently used metadata block by @Mytherin in https://github.com/duckdb/duckdb/pull/12318
- [Fix] Only read file size if file handle still exists by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12319
- Add support for APPEND argument to hive partitioned write by @Mytherin in https://github.com/duckdb/duckdb/pull/12262
- Remove all reinterpret casts from the transformer by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12320
- Additional check for overlapping CTE names by @lnkuiper in https://github.com/duckdb/duckdb/pull/12305
- [Dev]
STANDARD_VECTOR_SIZEandBLOCK_ALLOC_SIZEcan now be set through the Makefile by @Tishj in https://github.com/duckdb/duckdb/pull/12164 - [Upsert] Fix issue with lambdas in
DO UPDATE SETexpressions by @Tishj in https://github.com/duckdb/duckdb/pull/11866 - [Python] Fix scoping issue for
pandas_analyze_samplesetting by @Tishj in https://github.com/duckdb/duckdb/pull/11706 - Support REGEX matches expected error message by @hmeriann in https://github.com/duckdb/duckdb/pull/12327
- Allow run_fuzzer to reduce multi statements. by @Tmonster in https://github.com/duckdb/duckdb/pull/12278
- Fix #12328 - when flattening STRUCT vectors with NULL values, we need to flatten the children recursively as well by @Mytherin in https://github.com/duckdb/duckdb/pull/12332
- Make
dbgengenerate data in parallel by @Mytherin in https://github.com/duckdb/duckdb/pull/12337 - dbgen: skip parallel generation if DUCKDB_NO_THREADS is set by @Mytherin in https://github.com/duckdb/duckdb/pull/12341
- Add prefix prefix_front_back. to get prefix_front_ and prefix_back_ by @liujiayi771 in https://github.com/duckdb/duckdb/pull/12344
- Issue #12171: Streaming Windowed DISTINCT by @hawkfish in https://github.com/duckdb/duckdb/pull/12311
- Update README by @szarnyasg in https://github.com/duckdb/duckdb/pull/12357
- [CSV Reader] [Skip Option] Tests and fixes by @pdet in https://github.com/duckdb/duckdb/pull/12213
- Adjust BM25 score in FTS extension to prevent negative scores by @lnkuiper in https://github.com/duckdb/duckdb/pull/12356
- Fix typos by @szarnyasg in https://github.com/duckdb/duckdb/pull/12360
- Fix #12293 - accept NULL values in generate_series with timestamp by @Mytherin in https://github.com/duckdb/duckdb/pull/12367
- Fix #12335: avoid calling fsync when writing Parquet files, instead just close the file by @Mytherin in https://github.com/duckdb/duckdb/pull/12371
- Fix parameters passed down to other workflows in OnTag.yml by @carlopi in https://github.com/duckdb/duckdb/pull/12369
- [Python] Fixes for the SQLLogicTest runner implementation by @Tishj in https://github.com/duckdb/duckdb/pull/12372
- Bump julia to v1.0.0 by @Mytherin in https://github.com/duckdb/duckdb/pull/12379
- Fix #11921 - varchar -> timestamp casts are not invertible by @Mytherin in https://github.com/duckdb/duckdb/pull/12376
- Upgrade utf8proc - and move our custom extensions out of utf8proc itself by @Mytherin in https://github.com/duckdb/duckdb/pull/12373
- change max_queries number back to 2000 by @Tmonster in https://github.com/duckdb/duckdb/pull/12375
- Remove sqlsmith extension by @Tmonster in https://github.com/duckdb/duckdb/pull/12300
- Reorder semi and anti joins. by @Tmonster in https://github.com/duckdb/duckdb/pull/11815
- Issue #12351: implicit cast to
TIMESTAMP_MS,TIMESTAMP_S,TIMESTAMP_NSfromDATEvalues by @akoshchiy in https://github.com/duckdb/duckdb/pull/12352 - Issue #10023: Approx_Count_Distinct Memory Usage by @hawkfish in https://github.com/duckdb/duckdb/pull/12355
- Fix a small typo in dev instructions for swift setup by @gjmwoods in https://github.com/duckdb/duckdb/pull/12383
- Release lock before returning
BufferHandleinStandardBufferManager::Pinby @lnkuiper in https://github.com/duckdb/duckdb/pull/12391 - Remote attach autoload by @carlopi in https://github.com/duckdb/duckdb/pull/12393
- Add JSON type to Parquet reader/writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/12222
- Add
RETURN_FILESparameter toCOPY TOby @lnkuiper in https://github.com/duckdb/duckdb/pull/12220 - Updated JoinHashTable to use linear probing to resolve hash collisions by @gropaul in https://github.com/duckdb/duckdb/pull/11472
- [Benchmark Runner] Add
--disable-timeoutflag by @Tishj in https://github.com/duckdb/duckdb/pull/12387 - Don't replace unicode spaces within
$$quotes in query strings by @lnkuiper in https://github.com/duckdb/duckdb/pull/12405 - [Python] Fix fatal exception caused by empty Pandas Categorical objects. by @Tishj in https://github.com/duckdb/duckdb/pull/12370
- Release CSV Blocks when acquiring new blocks if single threaded by @pdet in https://github.com/duckdb/duckdb/pull/12409
- Add support for prefetching multiple adjacent blocks in a single batched read when attaching to remote databases by @Mytherin in https://github.com/duckdb/duckdb/pull/12413
- MatchRegex() fixed to do not return false positive result by @hmeriann in https://github.com/duckdb/duckdb/pull/12396
- Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/12392
- [C-API] Catch exception in
duckdb_execute_preparedby @Tishj in https://github.com/duckdb/duckdb/pull/12414 - Combining LIST_CONCAT and CONCAT binding by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12317
- [Appender] Add
AppendDefaultby @Tishj in https://github.com/duckdb/duckdb/pull/11905 - [Python Dev] Push CTE internally for every (python) replacement scan that occurred. by @Tishj in https://github.com/duckdb/duckdb/pull/12161
- Improve compiler compatibility by @krlmlr in https://github.com/duckdb/duckdb/pull/12401
- Write zero-length list offsets for NULL values when serializing vectors by @Mytherin in https://github.com/duckdb/duckdb/pull/12423
- Get column statistics if Logical Get has a statistics function by @jeewonhh in https://github.com/duckdb/duckdb/pull/12424
- jemalloc: Identify GNU source code properly by @lnkuiper in https://github.com/duckdb/duckdb/pull/12420
- Avoid parallelizing LIMIT clauses when the query plan is simple by @Mytherin in https://github.com/duckdb/duckdb/pull/12433
- Prefetch metadata blocks for remote files by @Mytherin in https://github.com/duckdb/duckdb/pull/12437
- [Jupyter] Remove width limit on the BoxRenderer config by @Tishj in https://github.com/duckdb/duckdb/pull/12443
- Revert duckdb/duckdb#10865 by @carlopi in https://github.com/duckdb/duckdb/pull/12426
- inline delta by @samansmink in https://github.com/duckdb/duckdb/pull/12435
- Account for tagged dollar-quoted strings when stripping unicode spaces by @lnkuiper in https://github.com/duckdb/duckdb/pull/12421
- Work-around for broken github windows runner by @Mytherin in https://github.com/duckdb/duckdb/pull/12447
- Prevents clearing of the types of the LogicalExecute operator by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/12436
- Add support for BEGIN TRANSACTION READ ONLY by @Mytherin in https://github.com/duckdb/duckdb/pull/12202
- Make
rangeandgenerate_seriestable in-out functions, and fix several issues with table in-out functions by @Mytherin in https://github.com/duckdb/duckdb/pull/12431 - Issue #12412: AsOf Filter Push by @hawkfish in https://github.com/duckdb/duckdb/pull/12448
- [Fix] Block Size Nightly by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12427
- [ART] Remove Flatten and template key generation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12428
- [Python] Clean up internals of
execute/executemanyby @Tishj in https://github.com/duckdb/duckdb/pull/12434 - By default attach remote databases as READ_ONLY by @carlopi in https://github.com/duckdb/duckdb/pull/12461
- Fix #11837: use internal physical type for FIRST/LAST/ANY_VALUE instead of logical type by @Mytherin in https://github.com/duckdb/duckdb/pull/12462
- Issue #12464: Windowed Order By All by @hawkfish in https://github.com/duckdb/duckdb/pull/12470
- Specialize
list_valuefor primitive types for significantly improved performance by @Mytherin in https://github.com/duckdb/duckdb/pull/12468 - [Dev] Remove dead code from
PhysicalBatchCopyToFileby @Tishj in https://github.com/duckdb/duckdb/pull/12459 - Disable Windows extensions CI until Github actions runners are fixed by @Mytherin in https://github.com/duckdb/duckdb/pull/12479
- [Fix] access_mode now lives in AttachOptions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12482
- Internal #2186: Nanosecond Functionality by @hawkfish in https://github.com/duckdb/duckdb/pull/12440
- [C-API] Fix leak in
duckdb_create_configby @Tishj in https://github.com/duckdb/duckdb/pull/12465 - [Python] No longer scan the entire frame lineage in a replacement scan, added option to disable (python) replacements entirely by @Tishj in https://github.com/duckdb/duckdb/pull/12425
- throw binder error for comment on system catalog by @samansmink in https://github.com/duckdb/duckdb/pull/12486
- Parquet reader performance by @lnkuiper in https://github.com/duckdb/duckdb/pull/12478
- Operators the Optimizer can skip by @Tmonster in https://github.com/duckdb/duckdb/pull/12489
- Fixes clang conversion warnings by @TinyTinni in https://github.com/duckdb/duckdb/pull/12467
- Avoid creating internal schemas as non-internal when reading old database files by @Mytherin in https://github.com/duckdb/duckdb/pull/12456
- Allow parquet encryption/decryption keys to be passed in as base64 encoded strings by @elefeint in https://github.com/duckdb/duckdb/pull/12445
- [Block Size] Introducing CompressionInfo by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12481
- add the number of filtered files to explain by @samansmink in https://github.com/duckdb/duckdb/pull/12488
- Implement Map Type Detection for JSON Reader by @ZiyaZa in https://github.com/duckdb/duckdb/pull/11285
- [Dev] Remove busy-spin from
ClientContext::ExecuteTaskInternalby @Tishj in https://github.com/duckdb/duckdb/pull/12483 - Pluggable collations by @Mytherin in https://github.com/duckdb/duckdb/pull/12492
- [Dev] Don't fail
make generate-filesif the python code generation fails by @Tishj in https://github.com/duckdb/duckdb/pull/12500 - Optimize
EXTRACT(year/month/day FROM date/timestamp)by @Mytherin in https://github.com/duckdb/duckdb/pull/12499 - [Fix] Remove BLOCK_ALLOC_SIZE in the single file block manager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12502
- Revert Windows CI fixes by @carlopi in https://github.com/duckdb/duckdb/pull/12510
- Fix duckdb/duckdb#12467 changes to covariance calculation by @carlopi in https://github.com/duckdb/duckdb/pull/12515
- [Python] Fix reading strided
datetimeandtimedeltacolumns by @Tishj in https://github.com/duckdb/duckdb/pull/12519 - Add method for decoding sort keys, and use this in min/max for arbitrary types by @Mytherin in https://github.com/duckdb/duckdb/pull/12520
- Reduce allocations & use predication in ColumnSegment::FilterSelection by @Mytherin in https://github.com/duckdb/duckdb/pull/12521
- Skip only built-in optimizers by @Mytherin in https://github.com/duckdb/duckdb/pull/12522
- Improve min/max performance for strings and fallback types by @Mytherin in https://github.com/duckdb/duckdb/pull/12524
- Move arg_min/arg_max to use sort keys by @Mytherin in https://github.com/duckdb/duckdb/pull/12525
- Move FIRST/LAST/ANY_VALUE to use sort keys by @Mytherin in https://github.com/duckdb/duckdb/pull/12526
- CMake: use GNUInstallDirs as defaults for INSTALL_{BIN,LIB,INCLUDE}_DIR by @paparodeo in https://github.com/duckdb/duckdb/pull/12509
- More formatting and fix to stddev by @carlopi in https://github.com/duckdb/duckdb/pull/12516
- Linux Extensions CI: Attempt at fix missing dependencies by @carlopi in https://github.com/duckdb/duckdb/pull/12429
- Fix checkouts by @carlopi in https://github.com/duckdb/duckdb/pull/12366
- Etag if none match for extension install by @carlopi in https://github.com/duckdb/duckdb/pull/12333
- [Block Size] FixedSizeAllocator, MetadataManager, PartialBlockManager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12514
- [Python] Skip the PandasAnalyzer if dtype is
'string'by @Tishj in https://github.com/duckdb/duckdb/pull/12511 - [StreamQueryResult] Batched variant of the StreamQueryResult collector by @Tishj in https://github.com/duckdb/duckdb/pull/11494
- Move many tests to slow by @Mytherin in https://github.com/duckdb/duckdb/pull/12534
- Add support for
arg_min(ANY, ANY)by @Mytherin in https://github.com/duckdb/duckdb/pull/12532 - Avoid overriding types in PrepareTypeForCast when not required by @Mytherin in https://github.com/duckdb/duckdb/pull/12539
- Support all types in
histogramfunction by @Mytherin in https://github.com/duckdb/duckdb/pull/12538 - [Python] Remove busy-spin during execution by @Tishj in https://github.com/duckdb/duckdb/pull/12512
- [Block Size] String space constant by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12537
- Use string_t instead of std::string in histogram by @Mytherin in https://github.com/duckdb/duckdb/pull/12545
- Add support for binned histograms by @Mytherin in https://github.com/duckdb/duckdb/pull/12548
- [Upsert] Fix RETURNING for
DO NOTHINGby @Tishj in https://github.com/duckdb/duckdb/pull/12554 - Build Android Binaries by @hannes in https://github.com/duckdb/duckdb/pull/12550
- [CI] Remove pyarrow version lock by @Tishj in https://github.com/duckdb/duckdb/pull/12566
- [Dev] Change tests: np.NaN -> np.nan by @Tishj in https://github.com/duckdb/duckdb/pull/12565
- Internal #2017: DECIMAL Downcast Rounding by @hawkfish in https://github.com/duckdb/duckdb/pull/12036
- Issue #12204: Summarize Temporal Quantiles by @hawkfish in https://github.com/duckdb/duckdb/pull/12297
- Internal #2186: Nanosecond StrTimeFormat by @hawkfish in https://github.com/duckdb/duckdb/pull/12551
- Add support for
equi_width_binsfunction to compute histogram boundaries by @Mytherin in https://github.com/duckdb/duckdb/pull/12574 - add support for casting 'yes'/'no' strings to boolean values by @chrisiou in https://github.com/duckdb/duckdb/pull/12501
- Julia: Add chunked results with Tables.partitions() by @frankier in https://github.com/duckdb/duckdb/pull/12395
- [PySpark] - Allow spark session range by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12346
- [PySpark] Implement subset drop duplicates by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12348
- ICU noaccent collation by @tiagokepe in https://github.com/duckdb/duckdb/pull/12170
- Implement Brotli compression for Parquet reading & writing by @hannes in https://github.com/duckdb/duckdb/pull/12103
- [FriendlySQL] Unpacked COLUMNS() Expression by @Tishj in https://github.com/duckdb/duckdb/pull/11872
- [PySpark] Implement UDFRegistration.register method on PySpark api by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12179
- [Python] Don't use
np.nan, deprecated alias starting with NumPy 2.0 by @Tishj in https://github.com/duckdb/duckdb/pull/12583 - Add
bind_expressioncallback to scalar function, and use it to turntypeofinto aBoundConstantExpressionby @Mytherin in https://github.com/duckdb/duckdb/pull/12580 - Add
can_cast_implicitlyscalar function by @Mytherin in https://github.com/duckdb/duckdb/pull/12581 - Add support for
histogramandhistogram_valuestable macro, and add support for default table macros (similar to how we support default macros) by @Mytherin in https://github.com/duckdb/duckdb/pull/12590 - build: swap libclang for cxxheaderparser by @Mause in https://github.com/duckdb/duckdb/pull/12567
- [C-API] Add
table_descriptionstruct to query various information about the table. by @Tishj in https://github.com/duckdb/duckdb/pull/12460 - Change new micro benchmark script to only look for
.benchmarkfiles by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12598 - Add HTTP error code to extension install failures by @carlopi in https://github.com/duckdb/duckdb/pull/12608
- Separate WAL write from commit, and allow writing to the WAL without holding the transaction lock by @Mytherin in https://github.com/duckdb/duckdb/pull/12261
- Add
OwningStringMap- and reworkhistogramandmodefunctions to use this by @Mytherin in https://github.com/duckdb/duckdb/pull/12601 - Feature #1272: Window Executor State by @hawkfish in https://github.com/duckdb/duckdb/pull/12573
- Add support for any type to
modeaggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/12619 - WAL - when dropping a table, also delete any transaction local storage associated with that table by @Mytherin in https://github.com/duckdb/duckdb/pull/12603
- [Python] Allow Generators to be passed where List is expected by @Tishj in https://github.com/duckdb/duckdb/pull/12602
- VectorOperations::Copy - fast path when copying an aligned flat validity mask into a flat vector by @Mytherin in https://github.com/duckdb/duckdb/pull/12618
- Move android CI to only run during nightly CI triggers by @Mytherin in https://github.com/duckdb/duckdb/pull/12622
- Add initial support for GeoParquet + Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/12503
- Issue #12600: Streaming Positive LAG by @hawkfish in https://github.com/duckdb/duckdb/pull/12609
- Feature #1272: Window Group Preparation by @hawkfish in https://github.com/duckdb/duckdb/pull/12628
- Minor window improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/12617
- Merge feature into main by @Mytherin in https://github.com/duckdb/duckdb/pull/12633
- Refactor
quantileaggregate - clean up code & supportquantile_disc/medianfor all types by @Mytherin in https://github.com/duckdb/duckdb/pull/12630 - Feature 1272: Window Payload Preallocation by @hawkfish in https://github.com/duckdb/duckdb/pull/12629
- [ART] Configurable index scan threshold by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12635
- Subtract start offset for when fetching array child segment by @Maxxen in https://github.com/duckdb/duckdb/pull/12639
- Remove custom logic to detect main vs feature by @carlopi in https://github.com/duckdb/duckdb/pull/12643
- Do not quote fields with space in the CSV output mode by @szarnyasg in https://github.com/duckdb/duckdb/pull/12644
- Use lowercase in 'html' output mode by @szarnyasg in https://github.com/duckdb/duckdb/pull/12612
- Internal #2361: Window ROWS Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/12652
- Quantile: Fix variable used only in D_ASSERT by @carlopi in https://github.com/duckdb/duckdb/pull/12642
- Skip pytorch test, it fails spuriously in CI by @carlopi in https://github.com/duckdb/duckdb/pull/12645
- Add
histogram_exactfunction that adds values to bins only if they match exactly, and addothercolumn that contains values that do not fit in any bin by @Mytherin in https://github.com/duckdb/duckdb/pull/12650 - Add operator hook for sink progress by @Maxxen in https://github.com/duckdb/duckdb/pull/12637
- Regression workflow on newly introduced benchmarks: remove for now by @carlopi in https://github.com/duckdb/duckdb/pull/12659
- Fix #12646 - allow SQL value functions in HAVING by @Mytherin in https://github.com/duckdb/duckdb/pull/12654
- Add != operators on string_t and interval_t by @carlopi in https://github.com/duckdb/duckdb/pull/12658
- fix: improve C scalar functions API by @rustyconover in https://github.com/duckdb/duckdb/pull/12663
- Add
approx_top_kaggregate based on the (Filtered) Space-Saving algorithm, and use it in histogram by @Mytherin in https://github.com/duckdb/duckdb/pull/12653 - Fix std::sort requirements, from greater_equal to greater by @carlopi in https://github.com/duckdb/duckdb/pull/12669
- fix(parquet): two-complement zeroes check on FIXED_BYTE_ARRAY encoded DECIMAL (#12621) by @fedefrancescon in
These notes run past the length kept in the archive. The rest is on the publisher’s page.