git: d4d017cf6058 - main - databases/{,py-}duckdb: Update 0.4.0 -> 0.5.0

From: Yuri Victorovich <yuri_at_FreeBSD.org>
Date: Mon, 05 Sep 2022 22:30:12 UTC
The branch main has been updated by yuri:

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

commit d4d017cf60585a0902df88b8e33b30e6081b38cf
Author:     Yuri Victorovich <yuri@FreeBSD.org>
AuthorDate: 2022-09-05 22:28:49 +0000
Commit:     Yuri Victorovich <yuri@FreeBSD.org>
CommitDate: 2022-09-05 22:30:08 +0000

    databases/{,py-}duckdb: Update 0.4.0 -> 0.5.0
    
    Reported by:    portscout
---
 databases/duckdb/Makefile    |  4 ++--
 databases/duckdb/distinfo    |  6 ++---
 databases/duckdb/pkg-plist   | 57 ++++++++++++++++++++++++++++++++++++++------
 databases/py-duckdb/Makefile |  5 ++--
 databases/py-duckdb/distinfo |  6 ++---
 5 files changed, 60 insertions(+), 18 deletions(-)

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index 1ba4154f02ce..aa5c86cc3fb7 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,6 +1,6 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
-DISTVERSION=	0.4.0
+DISTVERSION=	0.5.0
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
@@ -20,7 +20,7 @@ CMAKE_TESTING_TARGET=	${ALL_TARGET} # hack: works as empty target
 BINARY_ALIAS=	git=false
 
 OPTIONS_GROUP=			EXTENSIONS
-OPTIONS_GROUP_EXTENSIONS=	ICU PARQUET TPCH TPCDS FTS JSON EXCEL SQLSMITH SUBSTRAIT
+OPTIONS_GROUP_EXTENSIONS=	EXCEL FTS HTTPFS ICU JSON PARQUET TPCH TPCDS SQLSMITH VISUALIZER
 
 EXTENSIONS_DESC=		Extensions:
 
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index 769d43757281..04f8059b4379 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1655782434
-SHA256 (duckdb-duckdb-v0.4.0_GH0.tar.gz) = 52dc309da50ea06d02d4d8364a8e1f9fb8da2f1c30fdd65eff119b81ee434bd4
-SIZE (duckdb-duckdb-v0.4.0_GH0.tar.gz) = 76269425
+TIMESTAMP = 1662408731
+SHA256 (duckdb-duckdb-v0.5.0_GH0.tar.gz) = 677655a7985fd8075a4b315c0b73bea51c419f1645e779560830ce9bfcc1b97c
+SIZE (duckdb-duckdb-v0.5.0_GH0.tar.gz) = 76401254
diff --git a/databases/duckdb/pkg-plist b/databases/duckdb/pkg-plist
index 5e52beacc4ad..d20a61908035 100644
--- a/databases/duckdb/pkg-plist
+++ b/databases/duckdb/pkg-plist
@@ -34,8 +34,12 @@ include/duckdb/catalog/standard_entry.hpp
 include/duckdb/common/algorithm.hpp
 include/duckdb/common/allocator.hpp
 include/duckdb/common/array.hpp
-include/duckdb/common/arrow.hpp
-include/duckdb/common/arrow_wrapper.hpp
+include/duckdb/common/arrow/arrow.hpp
+include/duckdb/common/arrow/arrow_appender.hpp
+include/duckdb/common/arrow/arrow_buffer.hpp
+include/duckdb/common/arrow/arrow_converter.hpp
+include/duckdb/common/arrow/arrow_wrapper.hpp
+include/duckdb/common/arrow/result_arrow_wrapper.hpp
 include/duckdb/common/assert.hpp
 include/duckdb/common/atomic.hpp
 include/duckdb/common/bitpacking.hpp
@@ -50,6 +54,7 @@ include/duckdb/common/crypto/md5.hpp
 include/duckdb/common/cycle_counter.hpp
 include/duckdb/common/deque.hpp
 include/duckdb/common/dl.hpp
+include/duckdb/common/enum_class_hash.hpp
 include/duckdb/common/enums/aggregate_handling.hpp
 include/duckdb/common/enums/catalog_type.hpp
 include/duckdb/common/enums/compression_type.hpp
@@ -88,6 +93,7 @@ include/duckdb/common/file_system.hpp
 include/duckdb/common/fstream.hpp
 include/duckdb/common/gzip_file_system.hpp
 include/duckdb/common/helper.hpp
+include/duckdb/common/hive_partitioning.hpp
 include/duckdb/common/likely.hpp
 include/duckdb/common/limits.hpp
 include/duckdb/common/local_file_system.hpp
@@ -109,14 +115,15 @@ include/duckdb/common/operator/string_cast.hpp
 include/duckdb/common/operator/subtract.hpp
 include/duckdb/common/pair.hpp
 include/duckdb/common/pipe_file_system.hpp
+include/duckdb/common/preserved_error.hpp
 include/duckdb/common/printer.hpp
 include/duckdb/common/profiler.hpp
 include/duckdb/common/progress_bar.hpp
 include/duckdb/common/queue.hpp
 include/duckdb/common/radix.hpp
+include/duckdb/common/radix_partitioning.hpp
 include/duckdb/common/random_engine.hpp
 include/duckdb/common/re2_regex.hpp
-include/duckdb/common/result_arrow_wrapper.hpp
 include/duckdb/common/row_operations/row_operations.hpp
 include/duckdb/common/serializer.hpp
 include/duckdb/common/serializer/buffered_deserializer.hpp
@@ -130,16 +137,22 @@ include/duckdb/common/sort/sort.hpp
 include/duckdb/common/sort/sorted_block.hpp
 include/duckdb/common/stack.hpp
 include/duckdb/common/string.hpp
+include/duckdb/common/string_map_set.hpp
 include/duckdb/common/string_util.hpp
 include/duckdb/common/thread.hpp
 include/duckdb/common/to_string.hpp
 include/duckdb/common/tree_renderer.hpp
 include/duckdb/common/types.hpp
 include/duckdb/common/types/arrow_aux_data.hpp
-include/duckdb/common/types/batched_chunk_collection.hpp
+include/duckdb/common/types/batched_data_collection.hpp
 include/duckdb/common/types/blob.hpp
 include/duckdb/common/types/cast_helpers.hpp
 include/duckdb/common/types/chunk_collection.hpp
+include/duckdb/common/types/column_data_allocator.hpp
+include/duckdb/common/types/column_data_collection.hpp
+include/duckdb/common/types/column_data_collection_iterators.hpp
+include/duckdb/common/types/column_data_collection_segment.hpp
+include/duckdb/common/types/column_data_scan_states.hpp
 include/duckdb/common/types/data_chunk.hpp
 include/duckdb/common/types/date.hpp
 include/duckdb/common/types/decimal.hpp
@@ -149,6 +162,7 @@ include/duckdb/common/types/hyperloglog.hpp
 include/duckdb/common/types/interval.hpp
 include/duckdb/common/types/null_value.hpp
 include/duckdb/common/types/row_data_collection.hpp
+include/duckdb/common/types/row_data_collection_scanner.hpp
 include/duckdb/common/types/row_layout.hpp
 include/duckdb/common/types/sel_cache.hpp
 include/duckdb/common/types/selection_vector.hpp
@@ -192,18 +206,24 @@ include/duckdb/execution/expression_executor.hpp
 include/duckdb/execution/expression_executor_state.hpp
 include/duckdb/execution/index/art/art.hpp
 include/duckdb/execution/index/art/art_key.hpp
+include/duckdb/execution/index/art/iterator.hpp
 include/duckdb/execution/index/art/leaf.hpp
 include/duckdb/execution/index/art/node.hpp
 include/duckdb/execution/index/art/node16.hpp
 include/duckdb/execution/index/art/node256.hpp
 include/duckdb/execution/index/art/node4.hpp
 include/duckdb/execution/index/art/node48.hpp
+include/duckdb/execution/index/art/prefix.hpp
+include/duckdb/execution/index/art/swizzleable_pointer.hpp
 include/duckdb/execution/join_hashtable.hpp
 include/duckdb/execution/nested_loop_join.hpp
+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_perfecthash_aggregate.hpp
-include/duckdb/execution/operator/aggregate/physical_simple_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_streaming_window.hpp
+include/duckdb/execution/operator/aggregate/physical_ungrouped_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_window.hpp
 include/duckdb/execution/operator/filter/physical_filter.hpp
 include/duckdb/execution/operator/helper/physical_batch_collector.hpp
@@ -222,6 +242,7 @@ include/duckdb/execution/operator/helper/physical_streaming_limit.hpp
 include/duckdb/execution/operator/helper/physical_streaming_sample.hpp
 include/duckdb/execution/operator/helper/physical_transaction.hpp
 include/duckdb/execution/operator/helper/physical_vacuum.hpp
+include/duckdb/execution/operator/join/outer_join_marker.hpp
 include/duckdb/execution/operator/join/perfect_hash_join_executor.hpp
 include/duckdb/execution/operator/join/physical_blockwise_nl_join.hpp
 include/duckdb/execution/operator/join/physical_comparison_join.hpp
@@ -246,7 +267,7 @@ include/duckdb/execution/operator/persistent/physical_update.hpp
 include/duckdb/execution/operator/projection/physical_projection.hpp
 include/duckdb/execution/operator/projection/physical_tableinout_function.hpp
 include/duckdb/execution/operator/projection/physical_unnest.hpp
-include/duckdb/execution/operator/scan/physical_chunk_scan.hpp
+include/duckdb/execution/operator/scan/physical_column_data_scan.hpp
 include/duckdb/execution/operator/scan/physical_dummy_scan.hpp
 include/duckdb/execution/operator/scan/physical_empty_result.hpp
 include/duckdb/execution/operator/scan/physical_expression_scan.hpp
@@ -287,6 +308,7 @@ include/duckdb/function/compression/compression.hpp
 include/duckdb/function/compression_function.hpp
 include/duckdb/function/copy_function.hpp
 include/duckdb/function/function.hpp
+include/duckdb/function/function_serialization.hpp
 include/duckdb/function/function_set.hpp
 include/duckdb/function/macro_function.hpp
 include/duckdb/function/pragma/pragma_functions.hpp
@@ -364,16 +386,19 @@ include/duckdb/main/relation/write_csv_relation.hpp
 include/duckdb/main/settings.hpp
 include/duckdb/main/stream_query_result.hpp
 include/duckdb/main/table_description.hpp
+include/duckdb/optimizer/cardinality_estimator.hpp
 include/duckdb/optimizer/column_lifetime_optimizer.hpp
 include/duckdb/optimizer/common_aggregate_optimizer.hpp
 include/duckdb/optimizer/cse_optimizer.hpp
 include/duckdb/optimizer/deliminator.hpp
+include/duckdb/optimizer/estimated_properties.hpp
 include/duckdb/optimizer/expression_heuristics.hpp
 include/duckdb/optimizer/expression_rewriter.hpp
 include/duckdb/optimizer/filter_combiner.hpp
 include/duckdb/optimizer/filter_pullup.hpp
 include/duckdb/optimizer/filter_pushdown.hpp
 include/duckdb/optimizer/in_clause_rewriter.hpp
+include/duckdb/optimizer/join_node.hpp
 include/duckdb/optimizer/join_order/join_relation.hpp
 include/duckdb/optimizer/join_order/query_graph.hpp
 include/duckdb/optimizer/join_order_optimizer.hpp
@@ -385,6 +410,7 @@ include/duckdb/optimizer/matcher/set_matcher.hpp
 include/duckdb/optimizer/matcher/type_matcher.hpp
 include/duckdb/optimizer/matcher/type_matcher_id.hpp
 include/duckdb/optimizer/optimizer.hpp
+include/duckdb/optimizer/optimizer_extension.hpp
 include/duckdb/optimizer/regex_range_filter.hpp
 include/duckdb/optimizer/remove_unused_columns.hpp
 include/duckdb/optimizer/rule.hpp
@@ -477,6 +503,7 @@ include/duckdb/parser/parsed_data/vacuum_info.hpp
 include/duckdb/parser/parsed_expression.hpp
 include/duckdb/parser/parsed_expression_iterator.hpp
 include/duckdb/parser/parser.hpp
+include/duckdb/parser/parser_extension.hpp
 include/duckdb/parser/qualified_name.hpp
 include/duckdb/parser/qualified_name_set.hpp
 include/duckdb/parser/query_error_context.hpp
@@ -496,9 +523,11 @@ include/duckdb/parser/statement/drop_statement.hpp
 include/duckdb/parser/statement/execute_statement.hpp
 include/duckdb/parser/statement/explain_statement.hpp
 include/duckdb/parser/statement/export_statement.hpp
+include/duckdb/parser/statement/extension_statement.hpp
 include/duckdb/parser/statement/insert_statement.hpp
 include/duckdb/parser/statement/list.hpp
 include/duckdb/parser/statement/load_statement.hpp
+include/duckdb/parser/statement/logical_plan_statement.hpp
 include/duckdb/parser/statement/pragma_statement.hpp
 include/duckdb/parser/statement/prepare_statement.hpp
 include/duckdb/parser/statement/relation_statement.hpp
@@ -522,6 +551,7 @@ include/duckdb/parser/transformer.hpp
 include/duckdb/planner/bind_context.hpp
 include/duckdb/planner/binder.hpp
 include/duckdb/planner/bound_constraint.hpp
+include/duckdb/planner/bound_parameter_map.hpp
 include/duckdb/planner/bound_query_node.hpp
 include/duckdb/planner/bound_result_modifier.hpp
 include/duckdb/planner/bound_statement.hpp
@@ -545,7 +575,9 @@ include/duckdb/planner/expression/bound_conjunction_expression.hpp
 include/duckdb/planner/expression/bound_constant_expression.hpp
 include/duckdb/planner/expression/bound_default_expression.hpp
 include/duckdb/planner/expression/bound_function_expression.hpp
+include/duckdb/planner/expression/bound_lambda_expression.hpp
 include/duckdb/planner/expression/bound_operator_expression.hpp
+include/duckdb/planner/expression/bound_parameter_data.hpp
 include/duckdb/planner/expression/bound_parameter_expression.hpp
 include/duckdb/planner/expression/bound_reference_expression.hpp
 include/duckdb/planner/expression/bound_subquery_expression.hpp
@@ -580,7 +612,7 @@ include/duckdb/planner/logical_tokens.hpp
 include/duckdb/planner/operator/list.hpp
 include/duckdb/planner/operator/logical_aggregate.hpp
 include/duckdb/planner/operator/logical_any_join.hpp
-include/duckdb/planner/operator/logical_chunk_get.hpp
+include/duckdb/planner/operator/logical_column_data_get.hpp
 include/duckdb/planner/operator/logical_comparison_join.hpp
 include/duckdb/planner/operator/logical_copy_to_file.hpp
 include/duckdb/planner/operator/logical_create.hpp
@@ -620,6 +652,7 @@ include/duckdb/planner/operator/logical_update.hpp
 include/duckdb/planner/operator/logical_window.hpp
 include/duckdb/planner/parsed_data/bound_create_function_info.hpp
 include/duckdb/planner/parsed_data/bound_create_table_info.hpp
+include/duckdb/planner/plan_serialization.hpp
 include/duckdb/planner/planner.hpp
 include/duckdb/planner/pragma_handler.hpp
 include/duckdb/planner/query_node/bound_recursive_cte_node.hpp
@@ -639,6 +672,7 @@ include/duckdb/planner/tableref/bound_joinref.hpp
 include/duckdb/planner/tableref/bound_subqueryref.hpp
 include/duckdb/planner/tableref/bound_table_function.hpp
 include/duckdb/planner/tableref/list.hpp
+include/duckdb/storage/arena_allocator.hpp
 include/duckdb/storage/block.hpp
 include/duckdb/storage/block_manager.hpp
 include/duckdb/storage/buffer/block_handle.hpp
@@ -689,6 +723,7 @@ include/duckdb/storage/table/standard_column_data.hpp
 include/duckdb/storage/table/struct_column_data.hpp
 include/duckdb/storage/table/update_segment.hpp
 include/duckdb/storage/table/validity_column_data.hpp
+include/duckdb/storage/table_index.hpp
 include/duckdb/storage/table_statistics.hpp
 include/duckdb/storage/write_ahead_log.hpp
 include/duckdb/transaction/append_info.hpp
@@ -702,6 +737,13 @@ include/duckdb/transaction/transaction_context.hpp
 include/duckdb/transaction/transaction_manager.hpp
 include/duckdb/transaction/undo_buffer.hpp
 include/duckdb/transaction/update_info.hpp
+include/duckdb/verification/copied_statement_verifier.hpp
+include/duckdb/verification/deserialized_statement_verifier.hpp
+include/duckdb/verification/external_statement_verifier.hpp
+include/duckdb/verification/parsed_statement_verifier.hpp
+include/duckdb/verification/prepared_statement_verifier.hpp
+include/duckdb/verification/statement_verifier.hpp
+include/duckdb/verification/unoptimized_statement_verifier.hpp
 lib/cmake/DuckDB/DuckDBConfig.cmake
 lib/cmake/DuckDB/DuckDBConfigVersion.cmake
 lib/cmake/DuckDB/DuckDBExports-%%CMAKE_BUILD_TYPE%%.cmake
@@ -710,6 +752,7 @@ lib/libduckdb.so
 lib/libduckdb_fastpforlib.a
 lib/libduckdb_fmt.a
 lib/libduckdb_hyperloglog.a
+lib/libduckdb_mbedtls.a
 lib/libduckdb_miniz.a
 lib/libduckdb_pg_query.a
 lib/libduckdb_re2.a
diff --git a/databases/py-duckdb/Makefile b/databases/py-duckdb/Makefile
index 7e75de19d8de..1c049c1f9849 100644
--- a/databases/py-duckdb/Makefile
+++ b/databases/py-duckdb/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	duckdb
-DISTVERSION=	0.4.0
+DISTVERSION=	0.5.0
 CATEGORIES=	databases python
 MASTER_SITES=	CHEESESHOP
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
@@ -18,11 +18,10 @@ TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}mypy>0:devel/py-mypy@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}google-cloud-storage>0:www/py-google-cloud-storage@${PY_FLAVOR}
 
 USES=		python
-USE_PYTHON=	distutils autoplist pytest # tests fail, see https://github.com/duckdb/duckdb/issues/3924
+USE_PYTHON=	distutils autoplist pytest
 
 TEST_WRKSRC=	${WRKDIR} # tests fail when run from the build directory due to a name collision with duckdb directory
 TEST_ENV=	${MAKE_ENV} PYTHONPATH=${STAGEDIR}${PYTHONPREFIX_SITELIBDIR}
-# 2 tests are known to fail, see https://github.com/duckdb/duckdb/issues/3930
 
 post-install:
 	@${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/duckdb.cpython-${PYTHON_SUFFIX}.so
diff --git a/databases/py-duckdb/distinfo b/databases/py-duckdb/distinfo
index 91ccee16d340..f3b39046d8ea 100644
--- a/databases/py-duckdb/distinfo
+++ b/databases/py-duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1655792541
-SHA256 (duckdb-0.4.0.tar.gz) = 569e5d618de871e21dd676925349a7a5e701b87ebda3433e0c1d57627a465c1c
-SIZE (duckdb-0.4.0.tar.gz) = 13177437
+TIMESTAMP = 1662411627
+SHA256 (duckdb-0.5.0.tar.gz) = 01794615e0a78af8a4e0011fc2c594009f05c1b2f2f050b8a0d310d191f28f4c
+SIZE (duckdb-0.5.0.tar.gz) = 13503197