DuckDB CLI 1.4.0 డౌన్‌లోడ్

This release of DuckDB is named "Andium" after Anas Andium, a species of duck that lives in the Andes mountains in South America.
Please also refer to the announcement blog post: https://duckdb.org/2025/09/16/announcing-duckdb-140.html
What's Changed
- Python package devexp improvements by @evertlammerts in #17483
- change exception type to not be an internal exception by @samansmink in #17551
- Remove redundant code path in the ConflictManager by @taniabogatsch in #17562
- Add support for ToSqlString for union types by @wmTJc9IK0Q in #17513
- Update function descriptions and examples by @c-herrewijn in #17132
- Move query profiler's EndQuery after commit/rollback by @taniabogatsch in #17595
- fix extension troubleshooting link by @simon0191 in #17616
- C API tidying by @taniabogatsch in #17623
- bump DuckDB_jll to v1.3.0 by @c-herrewijn in #17677
- Add rowsort in generate_series test #43 by @jeewonhh in #17675
- [C API] Expose duckdb_scalar_function_bind_get_extra_info by @taniabogatsch in #17666
- Enable profiling output for all operator types by @taniabogatsch in #17665
- Output hashes in unittest and fix order by @niykko in #17664
- New Sorting Implementation by @lnkuiper in #17584
- Merge v1.3-ossivalis into main by @Mytherin in #17690
- Issue #17040: FILL Window Function by @hawkfish in #17686
- ClientBufferManager wrapper to access the client context in the buffer manager by @taniabogatsch in #17699
- Revert "set default for MAIN_BRANCH_VERSIONING to false" by @carlopi in #17708
- Sorting followup by @lnkuiper in #17717
- Correctly setting the delim offset by @Damon07 in #17716
- fix linux extension ci by @samansmink in #17720
- Aggregation performance by @lnkuiper in #17718
- Fix windows-2025 build errors by @adsharma in #17726
- [SQLLogicTester] Introduce reset label <query label> in the tester by @Tishj in #17729
- Adding additional authenticated data for encryption by @ccfelius in #17508
- csv_scanner: correct code comment by @Djfe in #17735
- Deprecate windows-2019 runners by @hannes in #17745
- re-add httpfs apply_patches by @samansmink in #17755
- Rename decorator from test_nulls to null_test_parameters by @Mytherin in #17760
- [CAPI] Expose ErrorData by @taniabogatsch in #17722
- Expose file_size_bytes and footer_size in parquet_file_metadata by @gijshendriksen in #17750
- Pass ExtensionLoader when loading extensions, change extension entry function by @Maxxen in #17772
- Support glibc 2.28 environments by @James-Gilbert- in #17776
- Mark Upper/LowerComparisonType as const by @JelteF in #17773
- [Indexes] Buffer-managed indexes part 1: segment handles by @taniabogatsch in #17758
- [Julia] api docs improvements by @tqml in #15645
- Ensure we use the same layout in RadixPartitionedHashTable and GroupedAggregateHashTable by @lnkuiper in #17790
- [Profiling] Propagate the ClientContext into file handle writes by @taniabogatsch in #17754
- Fix propagatesNullValues for case expr by @suibianwanwank in #17796
- Add qualified parameter to Python GetTableNames API by @evertlammerts in #17797
- Merge v1.3 into main by @Mytherin in #17806
- Pushdown pivot filter by @flashmouse in #17801
- Replace string for const data ptr in encryption api by @ccfelius in #17825
- Merge130 by @carlopi in #17833
- fix: escape using_columns on JoinRef::ToString by @akoshchiy in #17839
- Fix ICE with Windows ARM64 by @staticlibs in #17844
- Merge v1.3 into main by @Mytherin in #17851
- Add duckdb_type column to parquet_schema by @Mytherin in #17852
- Internal #4991: Remove Epoch_MS(MS) by @hawkfish in #17816
- #17853 Enable flexible page sizes and update Android NDK to r27 in workflow. by @aprock in #17854
- [Indexes] Buffer-managed indexes part 2: segment handle for base nodes by @taniabogatsch in #17828
- Function Serialization: adapt to removal of overloads by explicitly casting if argument types have changed by @Mytherin in #17864
- julia: add missing methods from C-API by @tqml in #17733
- Issue #17153: Window Order Columns by @hawkfish in #17835
- Issue #17040: FILL Secondary Sorts by @hawkfish in #17821
- Add STRUCT to MAP cast function by @evertlammerts in #17799
- Issue #17849: Test FILL Duplicates by @hawkfish in #17869
- Add GenAI policy by @szarnyasg in #17882
- Update function descriptions and examples for list, array, lambda functions by @c-herrewijn in #17886
- Issue #17861: FILL Argument Types by @hawkfish in #17888
- Reword GenAI policy by @szarnyasg in #17895
- Use an arena linked list for the physical operator children by @taniabogatsch in #17748
- Make CTE Materialization the Default Instead of Inlining by @kryonix in #17459
- Merge v1.3 into main by @Mytherin in #17897
- Leverage VectorType in ColumnDataCollection by @lnkuiper in #17881
- Fix empty BP block when writing parquet by @platypii in #17929
- fix use after free in adbc on invalid stmt by @ruslandoga in #17927
- Do not dispatch JDBC/ODBC jobs in release CI runs by @staticlibs in #17937
- Block based encryption by @ccfelius in #17275
- Unittester failures summary by @hmeriann in #16833
- Add v1.3-ossivalis to Cross version workflow by @hmeriann in #17906
- [CI Nightly Fix] Skip logging test if not standard block size by @taniabogatsch in #17957
- Visual Studio 17 (2022) fixes by @edouarda in #17948
- [Nested] Add struct_position and struct_contains functions by @maiadegraaf in #17819
- Enable building spatial and encodings extensions by @staticlibs in #17960
- [Nested] Optimize structs in LIST_VALUE by @maiadegraaf in #17169
- Unit Tester Configuration by @Mytherin in #17972
- [nested] Allow fixed-size arrays to be unnested by @maiadegraaf in #17968
- Merge v1.3-ossivalis into main by @Mytherin in #17973
- [CI] Skip some workflows when updating out of tree extensions SHA by @hmeriann in #17949
- Issue #5144: AsOf Join Threshold by @hawkfish in #17979
- [Fix] Reset profiling info before preparing a query by @taniabogatsch in #17940
- Flag to disable database invalidation by @taniabogatsch in #17938
- Issue #5123: make_timestamp_ms by @hawkfish in #17908
- Rework extension loading to go through thread-safe ExtensionManager by @Mytherin in #17994
- Implement consumption and production of Arrow Binary View by @pdet in #17975
- Add support to produce Polars Lazy Dataframes by @pdet in #17947
- c-api to copy vector with selection by @abramk in #17870
- Fix #18007: correctly execute expressions with pivot operator by @Mytherin in #18020
- [Chore] Minor conflict manager refactoring by @taniabogatsch in #18015
- Remove Linux (32 Bit) job by @hmeriann in #18012
- [Explain] Add the YAML format for EXPLAIN statements by @qsliu2017 in #17572
- Unittest: Add skip_compiled option that can be used to skip built-in C++ tests by @Mytherin in #18034
- Add ppc64le spin-wait instruction by @mgiessing in #17837
- Merge ossivalis into main by @taniabogatsch in #18036
- Remove match-case statements from polars_io.py by @evertlammerts in #18052
- Avoid adding commands read from a file to the shell history by @Mytherin in #18057
- Adding WAL encryption by @ccfelius in #17955
- Encryption: adding -key for the command line by @ccfelius in #17950
- fix star expr exclude error by @jayhan94 in #18063
- Add support for class-based expression iteration by @Mytherin in #18070
- Use timestamp_t instead of time_t for file last modified time by @lnkuiper in #18037
- Unittester: add on_new_connection + on_load + skip_tests options by @carlopi in #18042
- Fix some scaling issues by @lnkuiper in #17985
- Issue #18071: Temporal inf -inf by @hawkfish in #18083
- Switch to Optional for type hints in polars lazy dataframe function by @evertlammerts in #18078
- Unittest: Configure skip error messages by @carlopi in #18087
- Avoid running DraftPR.yml until timeout if token is missing by @carlopi in #18090
- Add start/end offset percentage options to Python test runner by @Flogex in #18091
- [CSV Reader] Prohibit options delim and sep in same read_csv call by @ackxolotl in #18096
- Fix correlated subquery unnest fail by @flashmouse in #18092
- [CI] don't run jobs on draft PRs by @hmeriann in #18016
- TPC-DS: Use BIGINT fields by @szarnyasg in #18098
- Don't throw InternalException in Sort::Sink by @lnkuiper in #18105
- ci: build duckdb against the latest emscripten by @cpcloud in #18110
- [chore] Merge v1.3-ossivalis on main by @carlopi in #18109
- Update description of 'arrow_lossless_conversion' by @szarnyasg in #18046
- Internal #3273: Window Task Generation by @hawkfish in #18113
- set ::error:: annotations for test runners by @hmeriann in #18072
- Improve sort key comparison performance by @lnkuiper in #18131
- Add support for MERGE INTO by @Mytherin in #18135
- Detect when updates have no effect, and skip performing the actual updates if we encounter these nop updates by @Mytherin in #18144
- Add support for AdbcConnectionGetObjects(table_type) by @kou in #18066
- Issue #17683: TIME_NS Compilation by @hawkfish in #18053
- Implement replace_type function by @lnkuiper in #18077
- Bump spatial again: include re-linking for handling global objects in Wasm by @carlopi in #18170
- Resolve some small build issues by @madscientist in #18162
- fix typo by @felixhummel in #18165
- Avoid realloc in CSV writer by @lnkuiper in #18174
- fix bug with allowed_paths by @samansmink in #18176
- Reduce lock contention for the instance cache by @NiclasHaderer in #18079
- Check if GetLastSegment is not nullptr in ColumnData::RevertAppend by @lnkuiper in #18171
- [Profiling] Move the client context into more write functions by @taniabogatsch in #17875
- Bump Julia to v1.3.2 by @hmeriann in #18185
- Merge v1.3-ossivalis into main by @carlopi in #18188
- Parquet reader logging by @lnkuiper in #18172
- Add VS2019 compat flag to Python wheel build by @staticlibs in #18198
- [Parquet][Dev] Update the vendored parquet.thrift to 3ce0760 by @Tishj in #18195
- Two-rowID-leaf support in the conflict manager and general refactoring by @taniabogatsch in #18194
- More internal-linkage by @Maxxen in #18177