CVS commit: pkgsrc/databases/duckdb

["Ryo ONODERA" <ryoon%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   ryoon
Date:           Tue May 20 16:03:33 UTC 2025

Modified Files:
        pkgsrc/databases/duckdb: Makefile PLIST distinfo

Log Message:
databases/duckdb: Update to 1.2.2

Changelog:
1.2.2:
This is a bug fix release for various issues discovered after we released 1.2.1. There are no new major features, just bug fixes. Database files created by DuckDB versions all the way back to v0.9.* 
can be read by this version.
What's Changed

    [Python] Fix deadlock in from_parquet with file_globs caused by not releasing the GIL by @Tishj in #16522
    [Python] Fix some stubs issues by @Tishj in #16523
    [Dev] Fix issues in the benchmark runner related to the serialized storage_version by @Tishj in #16533
    Set estimated cardinality to newly created logical operators by @jeewonhh in #16528
    custom_extension_repository to also be the default autoinstall_extension_repository by @carlopi in #16459
    [Python Dev] No longer trigger a DeprecationWarning when using a UDF by @Tishj in #16433
    Fixup problems connected to prep to 1.2.1 by @carlopi in #16578
    Give preference to quote=escape if we can't do better by @pdet in #16584
    Max ART key length by @taniabogatsch in #16588
    Issue #16617: Window Constant Finalize by @hawkfish in #16628
    [Fix] Index scan - Move the table scan state into the local state by @taniabogatsch in #16650
    [Fix] Perform eager constraint checking during physical batch insert by @taniabogatsch in #16651
    [Python] Don't push down OPTIONAL_FILTER into pyarrow for the arrow scan. by @Tishj in #16657
    move OrderPreservationRecursive to physical_plan_generator.hpp by @jeewonhh in #16656
    Add libs folder to bundled static libs by @taniabogatsch in #16655
    Avoid UMA by @krlmlr in #16641
    Avoid UMA by @krlmlr in #16643
    Avoid UMA by @krlmlr in #16642
    Several fixes for CSV fuzzer tests by @pdet in #16636
    FSST Fix: Correctly detect the situation where we have 3 bytes remaining by @Mytherin in #16688
    Fix #16627: handle DISTINCT FROM and NOT DISTINCT FROM in zone-map pushdown by @Mytherin in #16691
    Fix #16554: emit blobs as part of .dump by @Mytherin in #16693
    add avro by @samansmink in #16708
    Issue #16652: Implicit Ordered Aggregation by @hawkfish in #16718
    Issue #16649: SelectNth Remainders by @hawkfish in #16705
    [Dev] Fix EXPORT DATABASE missing semicolons in produced schema.sql by @Tishj in #16723
    Always throw the error that happens the earliest in the CSV Reader by @pdet in #16728
    Fix #16662 by @lnkuiper in #16732
    [Test] Add missing test for eager-constraint checking fix by @taniabogatsch in #16745
    Clamp reported memory in duckdb_memory by @Mytherin in #16753
    CLI -help: Fix default value for -nullvalue by @carlopi in #16755
    Apply RLE fix to v1.2 by @Mytherin in #16756
    [Arrow] Setting schema of the keys to not null for maps and properly write Null columns to arrow by @pdet in #16711
    Fix min/max values in numeric cast exception message by @abramk in #16777
    [ADBC] Add wrapper to connection new, set options at connection init, if any. by @pdet in #16748
    Remove delta from extensions built on a nightly basis (vs 1.2-histrionicus) by @carlopi in #16794
    PhysicalTopN: Buffer-allocated StringHeap by @lnkuiper in #16770
    [chore] Add v1.2.2 to storage versions, preparation for upcoming patch release by @carlopi in #16799
    Fix issue when line is empty by @pdet in #16823
    Add extra check in normalize for commit, rollback and abort by @pdet in #16802
    Fix #16783: Fix DistributivityRule by @flashmouse in #16804
    Internal #4492: Ignore Nulls Orrification by @hawkfish in #16837
    Fix #16836: rewrite main column data in case of an update that only modifies the validity by @Mytherin in #16851
    Initialize type by @pdet in #16848
    [CSV Reader] Add check on ever quoted for candidate selection by @pdet in #16868
    Clean up partial deletes when encountering a transaction conflict in a vector by @Mytherin in #16905
    Fix clang-tidy: add missing include by @Mytherin in #16920
    Backport "Adding gzip version of shell for linux/osx install script" by @carlopi in #16917
    Backport "Adding gzip version of shell for linux/osx install script"/2 by @carlopi in #16924
    Skip tests for Python 3.8, already end-of-life by @carlopi in #16923
    Bump to avro version that now support wasm by @carlopi in #16916
    Unwrap DUCKDB_EXTENSION__LINKED_LIBS via CMake by @carlopi in #16914
    Skip manylinux-extensions-x64 job by @carlopi in #16932
    [Fix] Disable recursion for invalidated database error by @taniabogatsch in #16907
    bump excel (on v1.2) by @Maxxen in #16915
    [Fix] Flush local storage before any deletes by @taniabogatsch in #16951
    [Python] Fix PyArrow filter pushdown for NaN by @Tishj in #16952
    Allow overriding the Printer::Print output destination by @bleskes in #16909
    bump out-of-tree extensions to v1.2.2 by @Tmonster in #16913
    Allow SQL prepared statements to be rebound by @NiclasHaderer in #16820
    Fix #16959: binding constraints should not modify the original constraints by @Mytherin in #16971
    Add back manylinux extensions [on v1.2-histrionicus] AND bump extensions by @carlopi in #16976
    Skip TPC-DS Q67 on DOUBLE by @Mytherin in #16987
    Re-enable iceberg by @carlopi in #16992
    Try enabling and bump delta by @Maxxen in #16990
    Backport @szarnyasg's 16999 by @carlopi in #17013

1.2.1:
This is a bug fix release for various issues discovered after we released 1.2.0. There are no new major features, just bug fixes. Database files created by DuckDB versions all the way back to v0.9.* 
can be read by this version.
What's Changed

    [Dev] MultiFileReader fix InternalError in CreateFilterMap by @Tishj in #16114
    [bug-fix] Avoid throwing in catch block for failed commits by @Vegetable26 in #15903
    Issue #16098: ValidEnd Parallel Vectorisation by @hawkfish in #16140
    Adding an extension option shouldn't delete a set value and promote unrecognized options by @bleskes in #15919
    Parquet writer: Re-implement GetRowSize for Strings by @Mytherin in #16178
    Fix #16157: correctly get the first row when reading hive partitions from a dictionary vector by @Mytherin in #16180
    Fix #16122: bind default values in a sub-binder to avoid modifying the catalog search path of the current binder by @Mytherin in #16181
    Fix #16134: when a catalog/schema/table has the same name, we prefer to suggest the table name by @Mytherin in #16189
    Ensure MergeCollectionTask has a writer by @ywelsch in #16207
    Backport #16115 by @NiclasHaderer in #16227
    Deleted copy constructor of pending query by @NiclasHaderer in #16242
    Correctly report errors caused by get_database in C extensions by @mlafeldt in #16253
    use random seeds for bernoulli sample when parallel is enabled by @Tmonster in #16223
    Parquet Reader: avoid caching the compressed buffer in the ColumnReader by @Mytherin in #16263
    Fix #16260: correctly handle parameters in getvariable by @Mytherin in #16264
    Avoid calling SetFilterAlwaysTrue multiple times in RowGroup::CheckZonemap by @Mytherin in #16269
    [Fix] Scanning from normal leaf to nested leaf by @taniabogatsch in #16270
    Fix #16231: refer to order by condition in ARRAY(SUBQUERY) by alias instead of by index by @Mytherin in #16272
    Fix #16257 by @lnkuiper in #16275
    AFL Tests for the CSV reader by @pdet in #16280
    Issue #16250: Window Range Performance by @hawkfish in #16276
    Fix #16278: late materialization should not trigger on very large limits, and it should never trigger on limits without offsets when preserve_insertion_order = false by @Mytherin in #16282
    Overflow strings allocations: avoid rounding up memory allocated per overflow string - when reading "small" overflow strings place them directly into the vector instead by @Mytherin in #16283
    Use ordered map to preserve expressions order by @Damon07 in #16111
    [Dev] register_filesystem stubs, use fsspec.AbstractFileSystem, not str by @Tishj in #16266
    [Python Dev] Fix crash with empty args for isin | Fix transformation for isnotin by @Tishj in #16271
    Fix issue related to hang when all candidates are eliminated in refinement by @pdet in #16288
    [Fix] Early-out on CREATE INDEX (IF NOT EXISTS) by @taniabogatsch in #16093
    [Python] Fix the reverse binary expressions in the Expression API by @Tishj in #16300
    Bugfixes by @lnkuiper in #16244
    [Fix] MinGW bundle static libs by @taniabogatsch in #16292
    Fix heap buffer oveflow sampling by @Tmonster in #16279
    Expose STRING_LITERAL in C API by @taniabogatsch in #16293
    Allow accessing profiler query tree under lock by @ywelsch in #16314
    bump extensions by @Maxxen in #16313
    Inline virtual list lambda bind functions by @Maxxen in #16327
    Update shell.cpp to fix #16333 by @teaguesterling in #16335
    Add the suggestion to verify the nullstring as part of the cast error message by @pdet in #16336
    Take NULLs into account for DELTA_BINARY_PACKED by @lnkuiper in #16317
    PhysicalTableScan: Adapt to allow async behaviour by @carlopi in #16310
    Allow querying attached catalog from detached catalog by @jeewonhh in #16289
    Reduce minimum expected memory usage in RadixPartitionedHashTable by @lnkuiper in #16332
    Backport ebb4dcc to v1.2-, adding missing include by @carlopi in #16369
    Excecption load on mismatched ABI: Use '%d' to print ABI type by @carlopi in #16367
    Aggregation: For dictionaries without an id - use the correct threshold to bail-out on using the dictionary by @Mytherin in #16364
    Bump excel to the same version distributed on core repository by @carlopi in #16375
    Accept valid dialects with escape set into the refinement phase by @pdet in #16387
    Push the correct casts for values of different types in (X, Y) IN (SELECT X, Y) by @Mytherin in #16392
    Add support for autoload and autoinstall for ui extension by @carlopi in #16393
    Add twine_upload option to Python.yml to trigger upload by @carlopi in #16410
    Only select options that generate more columns with null_padding, if they at least hold 50% of consistency by @pdet in #16404
    Use checkpoint bind in DuckTableEntry::Copy to avoid re-validating default values (and potentially causing issues during WAL replay) by @Mytherin in #16398
    Rename DUCKDB_API to DUCKDB_C_API for duckdb.h by @Mytherin in #16397
    Issue #16407: Try_Strptime Invalid TimeZone by @hawkfish in #16416
    Internal #4303: Windowed DISTINCT Leaks by @hawkfish in #16417
    Internal #4258: MODE Spooling Stability by @hawkfish in #16415
    Fix PyPi upload also for branches, when twine_upload is provided by @carlopi in #16421
    [Fix] Throw constraint violation for FK constraint checking by @taniabogat Add storage and serialization version for v1.2.1 by @Flogex in #16403
    Update flaky return_files.test by @jeewonhh in #16432
    Add python version to duckdb_api by @guenp in #15599
    Do not accept null values in lists for column parameters by @pdetigning using azure by @hannes in #16444
    CSV small code Improvements + initialising boolean variable. by @pdet in #16454
    [Python Dev] Make pandas not required in a couple places, check if it's installed in others by @Tishj in #16414
    fix passinger in #16480
    [Python Dev] pyproject.toml should not use oldest-supported-numpy anymore by @Tishj in #16486
    [tests] Multiple FORMAT in copy, only last one matters by @carlopi in #16493
    Bump postgres_scanner and fts extensions by @lnkuiper in #16492
    bump sqlsmith extension tag by @Tmonster in #16488
    [BugFix]: Swap join children, not left and right set by @Tmonster in #16487
    [tests] Add allow_unsigned_extensions require by @carlopi in #16499
    Provide callback when tasks are starting / stopping by @ywelsch in #16451
    CodeQuality: ubuntu-20 to ubuntu-22, lock black to version 24 and trick clang_format detection by @carlopi in #16513
    Move from ubuntu-20:04 to ubuntu-22:04, part I by @carlopi in #16510
    [chore] Build Linux releases also on PRs AND ubuntu-20 to 22 by @carlopi in #16506
    Move from ubuntu-20:04 to ubuntu-22:04, part II by @carlopi in #16514
    bump spatial and excel for v1.2 by @Maxxen in #16504
    CI Fixes after upgrade to ubuntu 22 by @Mytherin in #16516
    LinuxRelease.yml: Pass down override git describe by @carlopi in #16521
    bump spatial again by @Maxxen in #16518


To generate a diff of this commit:
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/duckdb/Makefile \
    pkgsrc/databases/duckdb/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/duckdb/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/duckdb/Makefile
diff -u pkgsrc/databases/duckdb/Makefile:1.8 pkgsrc/databases/duckdb/Makefile:1.9
--- pkgsrc/databases/duckdb/Makefile:1.8        Wed Feb 26 15:42:51 2025
+++ pkgsrc/databases/duckdb/Makefile    Tue May 20 16:03:33 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2025/02/26 15:42:51 ryoon Exp $
+# $NetBSD: Makefile,v 1.9 2025/05/20 16:03:33 ryoon Exp $
 
-DISTNAME=      duckdb-1.2.0
+DISTNAME=      duckdb-1.2.2
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=duckdb/}
 GITHUB_PROJECT=        duckdb
@@ -17,22 +17,9 @@ USE_TOOLS+=  gmake
 # for alloca(3)
 FORCE_CXX_STD+=        gnu++11
 
-CMAKE_CONFIGURE_ARGS+= -DBUILD_CORE_FUNCTIONS_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_ICU_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_PARQUET_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_TPCH_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_TPCDS_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_FTS_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_HTTPFS_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_VISUALIZER_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_JSON_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_JEMALLOC_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_EXCEL_EXTENSION=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_INET_EXTENSION=ON
+CMAKE_CONFIGURE_ARGS+= -DBUILD_EXTENSIONS='autocomplete;core_functions;icu;jemalloc;json;parquet;tpcds;tpch'
 CMAKE_CONFIGURE_ARGS+= -DBUILD_BENCHMARKS=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_SQLSMITH_EXTENSION=ON
 CMAKE_CONFIGURE_ARGS+= -DBUILD_TPCE=ON
-CMAKE_CONFIGURE_ARGS+= -DBUILD_AUTOCOMPLETE_EXTENSION=ON
 
 .include "../../devel/cmake/build.mk"
 .include "../../security/openssl/buildlink3.mk"
Index: pkgsrc/databases/duckdb/PLIST
diff -u pkgsrc/databases/duckdb/PLIST:1.8 pkgsrc/databases/duckdb/PLIST:1.9
--- pkgsrc/databases/duckdb/PLIST:1.8   Wed Feb 26 15:42:51 2025
+++ pkgsrc/databases/duckdb/PLIST       Tue May 20 16:03:33 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2025/02/26 15:42:51 ryoon Exp $
+@comment $NetBSD: PLIST,v 1.9 2025/05/20 16:03:33 ryoon Exp $
 bin/duckdb
 include/duckdb.h
 include/duckdb.hpp
@@ -51,6 +51,7 @@ include/duckdb/catalog/standard_entry.hp
 include/duckdb/common/adbc/adbc-init.hpp
 include/duckdb/common/adbc/adbc.hpp
 include/duckdb/common/adbc/single_batch_array_stream.hpp
+include/duckdb/common/adbc/wrappers.hpp
 include/duckdb/common/algorithm.hpp
 include/duckdb/common/allocator.hpp
 include/duckdb/common/array.hpp
@@ -63,6 +64,7 @@ include/duckdb/common/arrow/appender/lis
 include/duckdb/common/arrow/appender/list_data.hpp
 include/duckdb/common/arrow/appender/list_view_data.hpp
 include/duckdb/common/arrow/appender/map_data.hpp
+include/duckdb/common/arrow/appender/null_data.hpp
 include/duckdb/common/arrow/appender/scalar_data.hpp
 include/duckdb/common/arrow/appender/struct_data.hpp
 include/duckdb/common/arrow/appender/union_data.hpp
@@ -754,6 +756,7 @@ include/duckdb/parallel/pipeline_prepare
 include/duckdb/parallel/task.hpp
 include/duckdb/parallel/task_counter.hpp
 include/duckdb/parallel/task_executor.hpp
+include/duckdb/parallel/task_notifier.hpp
 include/duckdb/parallel/task_scheduler.hpp
 include/duckdb/parallel/thread_context.hpp
 include/duckdb/parser/base_expression.hpp
@@ -1190,6 +1193,7 @@ lib/cmake/DuckDB/DuckDBConfig.cmake
 lib/cmake/DuckDB/DuckDBConfigVersion.cmake
 lib/cmake/DuckDB/DuckDBExports-release.cmake
 lib/cmake/DuckDB/DuckDBExports.cmake
+lib/libautocomplete_extension.a
 lib/libcore_functions_extension.a
 lib/libduckdb.so
 lib/libduckdb_fastpforlib.a
@@ -1205,9 +1209,8 @@ lib/libduckdb_static.a
 lib/libduckdb_utf8proc.a
 lib/libduckdb_yyjson.a
 lib/libduckdb_zstd.a
-lib/libjemalloc_extension.a
+lib/libicu_extension.a
+lib/libjson_extension.a
 lib/libparquet_extension.a
-@pkgdir include/duckdb/storage/serialization
-@pkgdir include/duckdb/main/capi/header_generation/functions
-@pkgdir include/duckdb/main/capi/header_generation/apis/v1/v1.2
-@pkgdir include/duckdb/main/capi/header_generation/apis/v1/unstable
+lib/libtpcds_extension.a
+lib/libtpch_extension.a

Index: pkgsrc/databases/duckdb/distinfo
diff -u pkgsrc/databases/duckdb/distinfo:1.6 pkgsrc/databases/duckdb/distinfo:1.7
--- pkgsrc/databases/duckdb/distinfo:1.6        Wed Feb 26 15:42:51 2025
+++ pkgsrc/databases/duckdb/distinfo    Tue May 20 16:03:33 2025
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.6 2025/02/26 15:42:51 ryoon Exp $
+$NetBSD: distinfo,v 1.7 2025/05/20 16:03:33 ryoon Exp $
 
-BLAKE2s (duckdb-1.2.0.tar.gz) = a8655824089f3d6d0b64424c37d4df92805143546303f3e7b51c7f550639cd6d
-SHA512 (duckdb-1.2.0.tar.gz) = f5bca7a3b6f763b4b1a1f39e53c6f818925584fb44886e291ac3546fe50de545e80d16b4120f0126020e44b601a1b9193f4faad7a3dc8799cda843b1965038f2
-Size (duckdb-1.2.0.tar.gz) = 89762895 bytes
+BLAKE2s (duckdb-1.2.2.tar.gz) = b6977dde537dbcb6c9f880ba22f21ed851e2cd36cb78cb05826de3b0e52e81f9
+SHA512 (duckdb-1.2.2.tar.gz) = d9b4cdc798212ddeb518d9c1d8a6640423ac05f9e8ce99855f96c63778a6757079da37fed17ad8ec131b3f28a9f89c3580d2bbacad03d7607d9d9150347f4903
+Size (duckdb-1.2.2.tar.gz) = 90355674 bytes
 SHA1 (patch-src_include_duckdb_common_platform.hpp) = 08c4f744494f360609140c6102065e91353551ea