git: d988331d05e1 - main - databases/{,py-}duckdb: update 1.1.3 → 1.2.0

From: Yuri Victorovich <yuri_at_FreeBSD.org>
Date: Thu, 06 Feb 2025 15:06:05 UTC
The branch main has been updated by yuri:

URL: https://cgit.FreeBSD.org/ports/commit/?id=d988331d05e1cbefe0860019f136ea45205d1999

commit d988331d05e1cbefe0860019f136ea45205d1999
Author:     Yuri Victorovich <yuri@FreeBSD.org>
AuthorDate: 2025-02-06 15:01:20 +0000
Commit:     Yuri Victorovich <yuri@FreeBSD.org>
CommitDate: 2025-02-06 15:05:44 +0000

    databases/{,py-}duckdb: update 1.1.3 → 1.2.0
    
    Reported by:    portscout
---
 databases/duckdb/Makefile    |  26 +++++----
 databases/duckdb/distinfo    |  32 ++++++-----
 databases/duckdb/pkg-plist   | 123 +++++++++++++++++++++++++++----------------
 databases/py-duckdb/Makefile |   2 +-
 databases/py-duckdb/distinfo |   6 +--
 5 files changed, 119 insertions(+), 70 deletions(-)

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index a8f67fb1ad05..a38e01b1634b 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,6 +1,6 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
-DISTVERSION=	1.1.3
+DISTVERSION=	1.2.0
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
@@ -13,15 +13,21 @@ LICENSE_FILE=	${WRKSRC}/LICENSE
 
 USES=		cmake:testing compiler:c++11-lang ssl
 USE_GITHUB=	yes
-GH_TUPLE=	duckdb:duckdb_inet:51d7ad789f34eecb36a2071bac5aef0e12747d70:inet/extension/inet \
-		duckdb:duckdb_spatial:7ea79b614755d2bdee4be468691e4e17b39b8dbc:spatial/extension/spatial \
-		duckdb:sqlite_scanner:d5d62657702d33cb44a46cddc7ffc4b67bf7e961:sqlite/extension/sqlite_scanner \
-		duckdb:duckdb_sqlsmith:d6d62c1cba6b1369ba79db4bff3c67f24aaa95c2:sqlsmith/extension/sqlsmith \
-		duckdb:duckdb_vss:96374099476b3427c9ab43c1821e610b0465c864:vss/extension/vss
+GH_TUPLE=	\
+		duckdb:duckdb-excel:e243577956f36a898d5485189e5288839c2c4b73:excel/extension/excel \
+		duckdb:duckdb-fts:0477abaf2484aa7b9aabf8ace9dc0bde80a15554:fts/extension/fts \
+		duckdb:duckdb-httpfs:85ac4667bcb0d868199e156f8dd918b0278db7b9:httpfs/extension/httpfs \
+		duckdb:duckdb-inet:a8b361ab5d43f6390d7cb48c9a9f0638e9581cf9:inet/extension/inet \
+		duckdb:duckdb-spatial:79bf2b6f55db3bf7201f375662616663b4b0954a:spatial/extension/spatial \
+		duckdb:duckdb-sqlite:96e451c043afa40ee39b7581009ba0c72a523a12:sqlite/extension/sqlite_scanner \
+		duckdb:duckdb-sqlsmith:b13723fe701f1e38d2cd65b3b6eb587c6553a251:sqlsmith/extension/sqlsmith \
+		duckdb:duckdb-vss:580e8918eb89f478cf2d233ca908ffbd3ec752c5:vss/extension/vss
 # the list of out-of-tree extensions is here: .github/config/out_of_tree_extensions.cmake
 
-CXXFLAGS+=	-I${WRKSRC}/extension/inet/src/include \
-		-I${WRKSRC}/extension/sqlsmith/src/include # https://github.com/duckdb/duckdb/issues/13971
+CXXFLAGS+=	-I${WRKSRC}/extension/inet/src/include 
+CXXFLAGS+=	-I${WRKSRC}/extension/sqlsmith/src/include # https://github.com/duckdb/duckdb/issues/13971
+CXXFLAGS+=	-I${WRKSRC}/extension/fts/extension/fts/include # --""--
+CXXFLAGS+=	-I${WRKSRC}/extension/httpfs/extension/httpfs/include # --""--
 CMAKE_ON=	BUILD_SHARED_LIBS
 CMAKE_OFF=	BUILD_UNITTESTS
 CMAKE_ARGS=	-DOVERRIDE_GIT_DESCRIBE=v${DISTVERSION}-0-g0000000000
@@ -66,6 +72,8 @@ post-extract: # remove the jemalloc extension directory just in case
 post-test: # run tests
 	@cd ${TEST_WRKSRC} && test/unittest
 
-# tests as of 1.1.3: All tests passed (53 skipped tests, 458453 assertions in 3305 test cases)
+# tests as of 1.2.0:
+# test cases:   3631 |   3630 passed | 1 failed | 48 skipped
+# assertions: 403428 | 403427 passed | 1 failed | 48 skipped
 
 .include <bsd.port.mk>
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index c6477ed8a452..d82b62a099db 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,13 +1,19 @@
-TIMESTAMP = 1731090579
-SHA256 (duckdb-duckdb-v1.1.3_GH0.tar.gz) = 2aea0af898ad753fee82b776fea1bf78ccbc9648986e7f7a87372df5e74cdb98
-SIZE (duckdb-duckdb-v1.1.3_GH0.tar.gz) = 90800198
-SHA256 (duckdb-duckdb_inet-51d7ad789f34eecb36a2071bac5aef0e12747d70_GH0.tar.gz) = eaf0629fc554413014f3b6d206675f014b0bf16f695f604fdff81a04a601b6e4
-SIZE (duckdb-duckdb_inet-51d7ad789f34eecb36a2071bac5aef0e12747d70_GH0.tar.gz) = 63868
-SHA256 (duckdb-duckdb_spatial-7ea79b614755d2bdee4be468691e4e17b39b8dbc_GH0.tar.gz) = 8bebfea2f7496eeaab7147ecf1180386cf6c5a18a4cf3d1550c95525ddca9626
-SIZE (duckdb-duckdb_spatial-7ea79b614755d2bdee4be468691e4e17b39b8dbc_GH0.tar.gz) = 125832398
-SHA256 (duckdb-sqlite_scanner-d5d62657702d33cb44a46cddc7ffc4b67bf7e961_GH0.tar.gz) = a645766cdbb5f69ade4f4b7057d40b6674c5b093416094ac335608c5b7ef82d2
-SIZE (duckdb-sqlite_scanner-d5d62657702d33cb44a46cddc7ffc4b67bf7e961_GH0.tar.gz) = 4651212
-SHA256 (duckdb-duckdb_sqlsmith-d6d62c1cba6b1369ba79db4bff3c67f24aaa95c2_GH0.tar.gz) = 7c794beb7b1d2a809d5cf77a9ba11e8e686d257c7186eeeeaee17069b750ba79
-SIZE (duckdb-duckdb_sqlsmith-d6d62c1cba6b1369ba79db4bff3c67f24aaa95c2_GH0.tar.gz) = 48164
-SHA256 (duckdb-duckdb_vss-96374099476b3427c9ab43c1821e610b0465c864_GH0.tar.gz) = f595cd9de6595d7662e35e558b22b1cae1597da357306875cf3538ce5ebdf340
-SIZE (duckdb-duckdb_vss-96374099476b3427c9ab43c1821e610b0465c864_GH0.tar.gz) = 155400
+TIMESTAMP = 1738826227
+SHA256 (duckdb-duckdb-v1.2.0_GH0.tar.gz) = f22c97e18c071fa8e43b5e150c03c6ab4bcc510cca6e6b50cbe13af8535fa701
+SIZE (duckdb-duckdb-v1.2.0_GH0.tar.gz) = 89762895
+SHA256 (duckdb-duckdb-excel-e243577956f36a898d5485189e5288839c2c4b73_GH0.tar.gz) = 7a98296090117129e21d8578f35c55d533fa1ccf1aa3a72eba9faf78958a2e56
+SIZE (duckdb-duckdb-excel-e243577956f36a898d5485189e5288839c2c4b73_GH0.tar.gz) = 204939
+SHA256 (duckdb-duckdb-fts-0477abaf2484aa7b9aabf8ace9dc0bde80a15554_GH0.tar.gz) = 523b6982819e8b31325dfb7351d45b60235ec321e644031c765c6a84fbaeafe5
+SIZE (duckdb-duckdb-fts-0477abaf2484aa7b9aabf8ace9dc0bde80a15554_GH0.tar.gz) = 14135
+SHA256 (duckdb-duckdb-httpfs-85ac4667bcb0d868199e156f8dd918b0278db7b9_GH0.tar.gz) = b586943fd602e7d87a2024a38cacecbcf7550073c304141b9335e1db6ff97bc3
+SIZE (duckdb-duckdb-httpfs-85ac4667bcb0d868199e156f8dd918b0278db7b9_GH0.tar.gz) = 44565
+SHA256 (duckdb-duckdb-inet-a8b361ab5d43f6390d7cb48c9a9f0638e9581cf9_GH0.tar.gz) = 9901824223c8e2c43915bfda6f67d963081399d672084195c98c8a02bf034f26
+SIZE (duckdb-duckdb-inet-a8b361ab5d43f6390d7cb48c9a9f0638e9581cf9_GH0.tar.gz) = 63902
+SHA256 (duckdb-duckdb-spatial-79bf2b6f55db3bf7201f375662616663b4b0954a_GH0.tar.gz) = c3217ef148d605770a78f6d311cc9d34accca56138eb7f825b724ed54521fb2a
+SIZE (duckdb-duckdb-spatial-79bf2b6f55db3bf7201f375662616663b4b0954a_GH0.tar.gz) = 68736562
+SHA256 (duckdb-duckdb-sqlite-96e451c043afa40ee39b7581009ba0c72a523a12_GH0.tar.gz) = 37967a355566b45ffb4ab03d7e772c86a4675811843c65bfbd204aecfa8f3e75
+SIZE (duckdb-duckdb-sqlite-96e451c043afa40ee39b7581009ba0c72a523a12_GH0.tar.gz) = 4663141
+SHA256 (duckdb-duckdb-sqlsmith-b13723fe701f1e38d2cd65b3b6eb587c6553a251_GH0.tar.gz) = b1dbd5920daa118b2a863aa2051ccde6f4805ff577b8a50a74b415960110490f
+SIZE (duckdb-duckdb-sqlsmith-b13723fe701f1e38d2cd65b3b6eb587c6553a251_GH0.tar.gz) = 48115
+SHA256 (duckdb-duckdb-vss-580e8918eb89f478cf2d233ca908ffbd3ec752c5_GH0.tar.gz) = f9a9ff45ec183d8ff28e62091d76b5db97f7d10f046989cf121d23060d31103e
+SIZE (duckdb-duckdb-vss-580e8918eb89f478cf2d233ca908ffbd3ec752c5_GH0.tar.gz) = 155341
diff --git a/databases/duckdb/pkg-plist b/databases/duckdb/pkg-plist
index 16f9724ca247..5c871e937938 100644
--- a/databases/duckdb/pkg-plist
+++ b/databases/duckdb/pkg-plist
@@ -72,6 +72,7 @@ include/duckdb/common/arrow/arrow_buffer.hpp
 include/duckdb/common/arrow/arrow_converter.hpp
 include/duckdb/common/arrow/arrow_merge_event.hpp
 include/duckdb/common/arrow/arrow_query_result.hpp
+include/duckdb/common/arrow/arrow_type_extension.hpp
 include/duckdb/common/arrow/arrow_util.hpp
 include/duckdb/common/arrow/arrow_wrapper.hpp
 include/duckdb/common/arrow/nanoarrow/nanoarrow.hpp
@@ -81,6 +82,7 @@ include/duckdb/common/arrow/result_arrow_wrapper.hpp
 include/duckdb/common/arrow/schema_metadata.hpp
 include/duckdb/common/assert.hpp
 include/duckdb/common/atomic.hpp
+include/duckdb/common/atomic_ptr.hpp
 include/duckdb/common/bind_helpers.hpp
 include/duckdb/common/bit_utils.hpp
 include/duckdb/common/bitpacking.hpp
@@ -91,6 +93,7 @@ include/duckdb/common/case_insensitive_map.hpp
 include/duckdb/common/cgroups.hpp
 include/duckdb/common/checksum.hpp
 include/duckdb/common/chrono.hpp
+include/duckdb/common/column_index.hpp
 include/duckdb/common/common.hpp
 include/duckdb/common/compressed_file_system.hpp
 include/duckdb/common/constants.hpp
@@ -106,6 +109,7 @@ include/duckdb/common/enums/aggregate_handling.hpp
 include/duckdb/common/enums/catalog_lookup_behavior.hpp
 include/duckdb/common/enums/catalog_type.hpp
 include/duckdb/common/enums/checkpoint_type.hpp
+include/duckdb/common/enums/collation_type.hpp
 include/duckdb/common/enums/compression_type.hpp
 include/duckdb/common/enums/copy_overwrite_mode.hpp
 include/duckdb/common/enums/cte_materialize.hpp
@@ -117,6 +121,7 @@ include/duckdb/common/enums/expression_type.hpp
 include/duckdb/common/enums/file_compression_type.hpp
 include/duckdb/common/enums/file_glob_options.hpp
 include/duckdb/common/enums/filter_propagate_result.hpp
+include/duckdb/common/enums/function_errors.hpp
 include/duckdb/common/enums/index_constraint_type.hpp
 include/duckdb/common/enums/join_type.hpp
 include/duckdb/common/enums/joinref_type.hpp
@@ -134,6 +139,7 @@ include/duckdb/common/enums/pending_execution_result.hpp
 include/duckdb/common/enums/physical_operator_type.hpp
 include/duckdb/common/enums/prepared_statement_mode.hpp
 include/duckdb/common/enums/profiler_format.hpp
+include/duckdb/common/enums/quantile_enum.hpp
 include/duckdb/common/enums/relation_type.hpp
 include/duckdb/common/enums/scan_options.hpp
 include/duckdb/common/enums/scan_vector_type.hpp
@@ -158,6 +164,7 @@ include/duckdb/common/exception/list.hpp
 include/duckdb/common/exception/parser_exception.hpp
 include/duckdb/common/exception/transaction_exception.hpp
 include/duckdb/common/exception_format_value.hpp
+include/duckdb/common/extension_type_info.hpp
 include/duckdb/common/extra_operator_info.hpp
 include/duckdb/common/extra_type_info.hpp
 include/duckdb/common/extra_type_info/enum_type_info.hpp
@@ -250,6 +257,7 @@ include/duckdb/common/sort/sort.hpp
 include/duckdb/common/sort/sorted_block.hpp
 include/duckdb/common/stack.hpp
 include/duckdb/common/stack_checker.hpp
+include/duckdb/common/stacktrace.hpp
 include/duckdb/common/string.hpp
 include/duckdb/common/string_map_set.hpp
 include/duckdb/common/string_util.hpp
@@ -341,46 +349,6 @@ include/duckdb/common/winapi.hpp
 include/duckdb/common/windows.hpp
 include/duckdb/common/windows_undefs.hpp
 include/duckdb/common/windows_util.hpp
-include/duckdb/core_functions/aggregate/algebraic/corr.hpp
-include/duckdb/core_functions/aggregate/algebraic/covar.hpp
-include/duckdb/core_functions/aggregate/algebraic/stddev.hpp
-include/duckdb/core_functions/aggregate/algebraic_functions.hpp
-include/duckdb/core_functions/aggregate/distributive_functions.hpp
-include/duckdb/core_functions/aggregate/histogram_helpers.hpp
-include/duckdb/core_functions/aggregate/holistic_functions.hpp
-include/duckdb/core_functions/aggregate/minmax_n_helpers.hpp
-include/duckdb/core_functions/aggregate/nested_functions.hpp
-include/duckdb/core_functions/aggregate/quantile_enum.hpp
-include/duckdb/core_functions/aggregate/quantile_helpers.hpp
-include/duckdb/core_functions/aggregate/quantile_sort_tree.hpp
-include/duckdb/core_functions/aggregate/quantile_state.hpp
-include/duckdb/core_functions/aggregate/regression/regr_count.hpp
-include/duckdb/core_functions/aggregate/regression/regr_slope.hpp
-include/duckdb/core_functions/aggregate/regression_functions.hpp
-include/duckdb/core_functions/aggregate/sort_key_helpers.hpp
-include/duckdb/core_functions/aggregate/sum_helpers.hpp
-include/duckdb/core_functions/array_kernels.hpp
-include/duckdb/core_functions/core_functions.hpp
-include/duckdb/core_functions/create_sort_key.hpp
-include/duckdb/core_functions/function_list.hpp
-include/duckdb/core_functions/lambda_functions.hpp
-include/duckdb/core_functions/scalar/array_functions.hpp
-include/duckdb/core_functions/scalar/bit_functions.hpp
-include/duckdb/core_functions/scalar/blob_functions.hpp
-include/duckdb/core_functions/scalar/date_functions.hpp
-include/duckdb/core_functions/scalar/debug_functions.hpp
-include/duckdb/core_functions/scalar/enum_functions.hpp
-include/duckdb/core_functions/scalar/generic_functions.hpp
-include/duckdb/core_functions/scalar/list_functions.hpp
-include/duckdb/core_functions/scalar/map_functions.hpp
-include/duckdb/core_functions/scalar/math_functions.hpp
-include/duckdb/core_functions/scalar/operators_functions.hpp
-include/duckdb/core_functions/scalar/random_functions.hpp
-include/duckdb/core_functions/scalar/secret_functions.hpp
-include/duckdb/core_functions/scalar/string_functions.hpp
-include/duckdb/core_functions/scalar/struct_functions.hpp
-include/duckdb/core_functions/scalar/union_functions.hpp
-include/duckdb/core_functions/to_interval.hpp
 include/duckdb/execution/adaptive_filter.hpp
 include/duckdb/execution/aggregate_hashtable.hpp
 include/duckdb/execution/base_aggregate_hashtable.hpp
@@ -415,6 +383,7 @@ include/duckdb/execution/operator/aggregate/aggregate_object.hpp
 include/duckdb/execution/operator/aggregate/distinct_aggregate_data.hpp
 include/duckdb/execution/operator/aggregate/grouped_aggregate_data.hpp
 include/duckdb/execution/operator/aggregate/physical_hash_aggregate.hpp
+include/duckdb/execution/operator/aggregate/physical_partitioned_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_perfecthash_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_streaming_window.hpp
 include/duckdb/execution/operator/aggregate/physical_ungrouped_aggregate.hpp
@@ -434,6 +403,8 @@ include/duckdb/execution/operator/csv_scanner/csv_schema.hpp
 include/duckdb/execution/operator/csv_scanner/csv_state.hpp
 include/duckdb/execution/operator/csv_scanner/csv_state_machine.hpp
 include/duckdb/execution/operator/csv_scanner/csv_state_machine_cache.hpp
+include/duckdb/execution/operator/csv_scanner/csv_validator.hpp
+include/duckdb/execution/operator/csv_scanner/encode/csv_encoder.hpp
 include/duckdb/execution/operator/csv_scanner/global_csv_state.hpp
 include/duckdb/execution/operator/csv_scanner/header_value.hpp
 include/duckdb/execution/operator/csv_scanner/quote_rules.hpp
@@ -521,16 +492,19 @@ include/duckdb/execution/operator/schema/physical_drop.hpp
 include/duckdb/execution/operator/set/physical_cte.hpp
 include/duckdb/execution/operator/set/physical_recursive_cte.hpp
 include/duckdb/execution/operator/set/physical_union.hpp
+include/duckdb/execution/partition_info.hpp
 include/duckdb/execution/perfect_aggregate_hashtable.hpp
 include/duckdb/execution/physical_operator.hpp
 include/duckdb/execution/physical_operator_states.hpp
 include/duckdb/execution/physical_plan_generator.hpp
+include/duckdb/execution/progress_data.hpp
 include/duckdb/execution/radix_partitioned_hashtable.hpp
 include/duckdb/execution/reservoir_sample.hpp
 include/duckdb/execution/task_error_manager.hpp
-include/duckdb/execution/window_executor.hpp
-include/duckdb/execution/window_segment_tree.hpp
+include/duckdb/function/aggregate/distributive_function_utils.hpp
 include/duckdb/function/aggregate/distributive_functions.hpp
+include/duckdb/function/aggregate/minmax_n_helpers.hpp
+include/duckdb/function/aggregate/sort_key_helpers.hpp
 include/duckdb/function/aggregate_function.hpp
 include/duckdb/function/aggregate_state.hpp
 include/duckdb/function/built_in_functions.hpp
@@ -542,23 +516,40 @@ include/duckdb/function/cast_rules.hpp
 include/duckdb/function/compression/compression.hpp
 include/duckdb/function/compression_function.hpp
 include/duckdb/function/copy_function.hpp
+include/duckdb/function/create_sort_key.hpp
+include/duckdb/function/encoding_function.hpp
 include/duckdb/function/function.hpp
 include/duckdb/function/function_binder.hpp
+include/duckdb/function/function_list.hpp
 include/duckdb/function/function_serialization.hpp
 include/duckdb/function/function_set.hpp
+include/duckdb/function/lambda_functions.hpp
 include/duckdb/function/macro_function.hpp
+include/duckdb/function/partition_stats.hpp
 include/duckdb/function/pragma/pragma_functions.hpp
 include/duckdb/function/pragma_function.hpp
+include/duckdb/function/register_function_list_helper.hpp
 include/duckdb/function/replacement_scan.hpp
 include/duckdb/function/scalar/compressed_materialization_functions.hpp
+include/duckdb/function/scalar/compressed_materialization_utils.hpp
+include/duckdb/function/scalar/date_functions.hpp
+include/duckdb/function/scalar/generic_common.hpp
 include/duckdb/function/scalar/generic_functions.hpp
 include/duckdb/function/scalar/list/contains_or_position.hpp
+include/duckdb/function/scalar/list_functions.hpp
+include/duckdb/function/scalar/map_functions.hpp
 include/duckdb/function/scalar/nested_functions.hpp
+include/duckdb/function/scalar/operator_functions.hpp
 include/duckdb/function/scalar/operators.hpp
 include/duckdb/function/scalar/regexp.hpp
 include/duckdb/function/scalar/sequence_functions.hpp
+include/duckdb/function/scalar/sequence_utils.hpp
 include/duckdb/function/scalar/strftime_format.hpp
+include/duckdb/function/scalar/string_common.hpp
 include/duckdb/function/scalar/string_functions.hpp
+include/duckdb/function/scalar/struct_functions.hpp
+include/duckdb/function/scalar/struct_utils.hpp
+include/duckdb/function/scalar/system_functions.hpp
 include/duckdb/function/scalar_function.hpp
 include/duckdb/function/scalar_macro_function.hpp
 include/duckdb/function/table/arrow.hpp
@@ -575,8 +566,31 @@ include/duckdb/function/table/system_functions.hpp
 include/duckdb/function/table/table_scan.hpp
 include/duckdb/function/table_function.hpp
 include/duckdb/function/table_macro_function.hpp
+include/duckdb/function/to_interval.hpp
 include/duckdb/function/udf_function.hpp
+include/duckdb/function/window/window_aggregate_function.hpp
+include/duckdb/function/window/window_aggregate_states.hpp
+include/duckdb/function/window/window_aggregator.hpp
+include/duckdb/function/window/window_boundaries_state.hpp
+include/duckdb/function/window/window_collection.hpp
+include/duckdb/function/window/window_constant_aggregator.hpp
+include/duckdb/function/window/window_custom_aggregator.hpp
+include/duckdb/function/window/window_distinct_aggregator.hpp
+include/duckdb/function/window/window_executor.hpp
+include/duckdb/function/window/window_index_tree.hpp
+include/duckdb/function/window/window_merge_sort_tree.hpp
+include/duckdb/function/window/window_naive_aggregator.hpp
+include/duckdb/function/window/window_rank_function.hpp
+include/duckdb/function/window/window_rownumber_function.hpp
+include/duckdb/function/window/window_segment_tree.hpp
+include/duckdb/function/window/window_shared_expressions.hpp
+include/duckdb/function/window/window_token_tree.hpp
+include/duckdb/function/window/window_value_function.hpp
 include/duckdb/logging/http_logger.hpp
+include/duckdb/logging/log_manager.hpp
+include/duckdb/logging/log_storage.hpp
+include/duckdb/logging/logger.hpp
+include/duckdb/logging/logging.hpp
 include/duckdb/main/appender.hpp
 include/duckdb/main/attached_database.hpp
 include/duckdb/main/buffered_data/batched_buffered_data.hpp
@@ -666,6 +680,7 @@ include/duckdb/optimizer/compressed_materialization.hpp
 include/duckdb/optimizer/cse_optimizer.hpp
 include/duckdb/optimizer/cte_filter_pusher.hpp
 include/duckdb/optimizer/deliminator.hpp
+include/duckdb/optimizer/empty_result_pullup.hpp
 include/duckdb/optimizer/expression_heuristics.hpp
 include/duckdb/optimizer/expression_rewriter.hpp
 include/duckdb/optimizer/filter_combiner.hpp
@@ -683,6 +698,7 @@ include/duckdb/optimizer/join_order/query_graph.hpp
 include/duckdb/optimizer/join_order/query_graph_manager.hpp
 include/duckdb/optimizer/join_order/relation_manager.hpp
 include/duckdb/optimizer/join_order/relation_statistics_helper.hpp
+include/duckdb/optimizer/late_materialization.hpp
 include/duckdb/optimizer/limit_pushdown.hpp
 include/duckdb/optimizer/matcher/expression_matcher.hpp
 include/duckdb/optimizer/matcher/expression_type_matcher.hpp
@@ -703,6 +719,7 @@ include/duckdb/optimizer/rule/comparison_simplification.hpp
 include/duckdb/optimizer/rule/conjunction_simplification.hpp
 include/duckdb/optimizer/rule/constant_folding.hpp
 include/duckdb/optimizer/rule/date_part_simplification.hpp
+include/duckdb/optimizer/rule/distinct_aggregate_optimizer.hpp
 include/duckdb/optimizer/rule/distributivity.hpp
 include/duckdb/optimizer/rule/empty_needle_removal.hpp
 include/duckdb/optimizer/rule/enum_comparison.hpp
@@ -715,7 +732,9 @@ include/duckdb/optimizer/rule/move_constants.hpp
 include/duckdb/optimizer/rule/ordered_aggregate_optimizer.hpp
 include/duckdb/optimizer/rule/regex_optimizations.hpp
 include/duckdb/optimizer/rule/timestamp_comparison.hpp
+include/duckdb/optimizer/sampling_pushdown.hpp
 include/duckdb/optimizer/statistics_propagator.hpp
+include/duckdb/optimizer/sum_rewriter.hpp
 include/duckdb/optimizer/topn_optimizer.hpp
 include/duckdb/optimizer/unnest_rewriter.hpp
 include/duckdb/parallel/base_pipeline_event.hpp
@@ -867,6 +886,7 @@ include/duckdb/parser/tokens.hpp
 include/duckdb/parser/transformer.hpp
 include/duckdb/planner/bind_context.hpp
 include/duckdb/planner/binder.hpp
+include/duckdb/planner/binding_alias.hpp
 include/duckdb/planner/bound_constraint.hpp
 include/duckdb/planner/bound_parameter_map.hpp
 include/duckdb/planner/bound_query_node.hpp
@@ -929,7 +949,10 @@ include/duckdb/planner/expression_iterator.hpp
 include/duckdb/planner/extension_callback.hpp
 include/duckdb/planner/filter/conjunction_filter.hpp
 include/duckdb/planner/filter/constant_filter.hpp
+include/duckdb/planner/filter/dynamic_filter.hpp
+include/duckdb/planner/filter/in_filter.hpp
 include/duckdb/planner/filter/null_filter.hpp
+include/duckdb/planner/filter/optional_filter.hpp
 include/duckdb/planner/filter/struct_filter.hpp
 include/duckdb/planner/joinside.hpp
 include/duckdb/planner/logical_operator.hpp
@@ -1056,6 +1079,11 @@ include/duckdb/storage/compression/chimp/chimp_analyze.hpp
 include/duckdb/storage/compression/chimp/chimp_compress.hpp
 include/duckdb/storage/compression/chimp/chimp_fetch.hpp
 include/duckdb/storage/compression/chimp/chimp_scan.hpp
+include/duckdb/storage/compression/dictionary/analyze.hpp
+include/duckdb/storage/compression/dictionary/common.hpp
+include/duckdb/storage/compression/dictionary/compression.hpp
+include/duckdb/storage/compression/dictionary/decompression.hpp
+include/duckdb/storage/compression/empty_validity.hpp
 include/duckdb/storage/compression/patas/algorithm/patas.hpp
 include/duckdb/storage/compression/patas/patas.hpp
 include/duckdb/storage/compression/patas/patas_analyze.hpp
@@ -1063,6 +1091,8 @@ include/duckdb/storage/compression/patas/patas_compress.hpp
 include/duckdb/storage/compression/patas/patas_fetch.hpp
 include/duckdb/storage/compression/patas/patas_scan.hpp
 include/duckdb/storage/compression/patas/shared.hpp
+include/duckdb/storage/compression/roaring/appender.hpp
+include/duckdb/storage/compression/roaring/roaring.hpp
 include/duckdb/storage/data_pointer.hpp
 include/duckdb/storage/data_table.hpp
 include/duckdb/storage/database_size.hpp
@@ -1091,9 +1121,11 @@ include/duckdb/storage/statistics/segment_statistics.hpp
 include/duckdb/storage/statistics/string_stats.hpp
 include/duckdb/storage/statistics/struct_stats.hpp
 include/duckdb/storage/storage_extension.hpp
+include/duckdb/storage/storage_index.hpp
 include/duckdb/storage/storage_info.hpp
 include/duckdb/storage/storage_lock.hpp
 include/duckdb/storage/storage_manager.hpp
+include/duckdb/storage/storage_options.hpp
 include/duckdb/storage/string_uncompressed.hpp
 include/duckdb/storage/table/append_state.hpp
 include/duckdb/storage/table/array_column_data.hpp
@@ -1141,6 +1173,7 @@ include/duckdb/transaction/transaction_context.hpp
 include/duckdb/transaction/transaction_data.hpp
 include/duckdb/transaction/transaction_manager.hpp
 include/duckdb/transaction/undo_buffer.hpp
+include/duckdb/transaction/undo_buffer_allocator.hpp
 include/duckdb/transaction/update_info.hpp
 include/duckdb/transaction/wal_write_state.hpp
 include/duckdb/verification/copied_statement_verifier.hpp
@@ -1156,6 +1189,7 @@ lib/cmake/DuckDB/DuckDBConfig.cmake
 lib/cmake/DuckDB/DuckDBConfigVersion.cmake
 lib/cmake/DuckDB/DuckDBExports-%%CMAKE_BUILD_TYPE%%.cmake
 lib/cmake/DuckDB/DuckDBExports.cmake
+lib/libcore_functions_extension.a
 lib/libduckdb.so
 lib/libduckdb_fastpforlib.a
 lib/libduckdb_fmt.a
@@ -1169,7 +1203,8 @@ lib/libduckdb_skiplistlib.a
 lib/libduckdb_static.a
 lib/libduckdb_utf8proc.a
 lib/libduckdb_yyjson.a
-@dir include/duckdb/main/capi/header_generation/apis/v0/dev
-@dir include/duckdb/main/capi/header_generation/apis/v0/v0.0
+lib/libduckdb_zstd.a
+@dir include/duckdb/main/capi/header_generation/apis/v1/unstable
+@dir include/duckdb/main/capi/header_generation/apis/v1/v1.2
 @dir include/duckdb/main/capi/header_generation/functions
 @dir include/duckdb/storage/serialization
diff --git a/databases/py-duckdb/Makefile b/databases/py-duckdb/Makefile
index 4d1443edfe78..cb451982a32e 100644
--- a/databases/py-duckdb/Makefile
+++ b/databases/py-duckdb/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	duckdb
-DISTVERSION=	1.1.3
+DISTVERSION=	1.2.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
diff --git a/databases/py-duckdb/distinfo b/databases/py-duckdb/distinfo
index a8382f7a0bb0..4819513d7cb4 100644
--- a/databases/py-duckdb/distinfo
+++ b/databases/py-duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1731092208
-SHA256 (duckdb-1.1.3.tar.gz) = 68c3a46ab08836fe041d15dcbf838f74a990d551db47cb24ab1c4576fc19351c
-SIZE (duckdb-1.1.3.tar.gz) = 12240672
+TIMESTAMP = 1738833736
+SHA256 (duckdb-1.2.0.tar.gz) = a5ce81828e6d1c3f06836d3bda38eef8355765f08ad5ce239abd6f56934dd1f8
+SIZE (duckdb-1.2.0.tar.gz) = 11586759