v1.2.843-nightly

What's Changed

Thoughtful Bug Fix 🔧

• fix(query): count_distinct needs to handle nullable correctly by @forsaken628 in #18973

Build/Testing/CI Infra Changes 🔌

• ci: fix dependency for test cloud control server by @everpcpc in #18978

Others 📒

• chore(query): improve python udf script by @sundy-li in #18960
• chore(query): delete replace masking/row access policy by @TCeason in #18972
• chore(query): Optimize Optimizer Performance by Reducing Redundant Computations by @b41sh in #18979

Full Changelog: v1.2.842-nightly...v1.2.843-nightly

v1.2.842-nightly

Full Changelog: v1.2.841-nightly...v1.2.842-nightly

v1.2.841-nightly

What's Changed

Exciting New Features ✨

• feat: http handler return geometry_output_format with data. by @youngsofun in #18963
• feat(query): add table statistics admin api by @zhang2014 in #18967
• feat: upgrade nom to version 8.0.0 and accelerate expr_element using the first token. by @KKould in #18935

Thoughtful Bug Fix 🔧

• fix(query): or_filter get incorrectly result by @zhyass in #18965
• fix(query): Fix copy into Variant field panic with infinite number by @b41sh in #18962

Code Refactor 🎉

• refactor: stream spill triggering for partial aggregation by @dqhl76 in #18943
• chore: optimize ExprBloomFilter to use references instead of clones by @dantengsky in #18157

Others 📒

• chore(query): adjust the default Bloom filter enable setting by @zhang2014 in #18966

Full Changelog: v1.2.840-nightly...v1.2.841-nightly

v1.2.840-nightly

What's Changed

Exciting New Features ✨

• feat: new fuse table option enable_parquet_dictionary by @dantengsky in #17675

Thoughtful Bug Fix 🔧

• fix: timestamp_tz display by @KKould in #18958

Others 📒

• chore: flaky test by @zhyass in #18959

Full Changelog: v1.2.839-nightly...v1.2.840-nightly

v1.2.839-nightly

What's Changed

Thoughtful Bug Fix 🔧

• fix: return timezone when set in query level. by @youngsofun in #18952
• fix(query): Skip sequence lookups when re-binding stored defaults by @TCeason in #18946
• fix(query): build mysql tls config by @everpcpc in #18953
• fix(query): defer MySQL session creation until the handshake completes by @everpcpc in #18956

Code Refactor 🎉

• refactor(query): prevent masking/row access policy name conflicts by @TCeason in #18937
• refactor(query): optimize visibility checker for large-scale deployments improved 10x by @TCeason in #18954

Others 📒

• chore(query): improve resolve large array by @sundy-li in #18949

Full Changelog: v1.2.838-nightly...v1.2.839-nightly

v1.2.838-nightly

What's Changed

Exciting New Features ✨

• feat(query): support policy_reference table function by @TCeason in #18944
• feat: improve runtime filter [Part 1] by @SkyFan2002 in #18893

Thoughtful Bug Fix 🔧

• fix(query): fix query function parsing nested conditions by @b41sh in #18940
• fix(query): handle complex types in procedure argument parsing by @TCeason in #18929
• fix: error in multi statement transaction retry by @SkyFan2002 in #18934
• fix: flaky test progress not updated in real time in cluster mode by @youngsofun in #18945

Code Refactor 🎉

• refactor(binder): move the rewrite of ASOF JOIN to the logical plan and remove scalar_expr from DerivedColumn by @forsaken628 in #18938
• refactor(query): optimized UnaryState design and simplified string_agg implementation by @forsaken628 in #18941
• refactor(query): rename exchange hash to node to node hash by @zhang2014 in #18948

Others 📒

• chore(query): ignore assert const in memo logical test by @zhang2014 in #18950

Full Changelog: v1.2.837-nightly...v1.2.838-nightly

v1.2.837-nightly

Full Changelog: v1.2.836-nightly...v1.2.837-nightly

v1.2.836-nightly

What's Changed

Exciting New Features ✨

• feat(query): Support bitmap_to_array function by @b41sh in #18927
• feat(query): prevent dropping in-use security policies by @TCeason in #18918
• feat(mysql): add JDBC healthcheck regex to support SELECT 1 FROM DUAL by @yufan022 in #18933
• feat: return timezone in HTTP handler. by @youngsofun in #18936

Thoughtful Bug Fix 🔧

• fix: FilterExecutor needs to handle projections when enable_selector_executor is turned off. by @forsaken628 in #18921
• fix(query): fix Inverted/Vector index panic with Native Storage Format by @b41sh in #18932
• fix(query): optimize the cost estimation of some query plans by @zhang2014 in #18926
• fix: alter column with specify approx distinct by @zhyass in #18928

Code Refactor 🎉

• refactor: refine experimental final aggregate spill by @dqhl76 in #18907
• refactor(query): AccessType downcasts now return Result so mismatches surface useful diagnostics by @forsaken628 in #18923
• refactor(query): merge pipeline core, sources and sinks crate by @zhang2014 in #18939

Others 📒

• chore: remove fixeme on TimestampTz by @KKould in #18924
• chore: fixed time zone on shanghai to fix flasky 02_0079_function_interval.test by @KKould in #18930
• chore: DataType::TimestampTz display: "TimestampTz" -> "Timestamp_Tz" by @KKould in #18931

Full Changelog: v1.2.835-nightly...v1.2.836-nightly

v1.2.835-nightly

What's Changed

Exciting New Features ✨

• feat: add has_data in system.streams by @zhyass in #18920
• feat(query): BackpressureSpiller has been changed to a fully synchronous call by @forsaken628 in #18899
• feat(query): add more info to /v1/verify by @everpcpc in #18882

Thoughtful Bug Fix 🔧

• fix: decimal overflow check is inadequate by @forsaken628 in #18919

Others 📒

• chore: bump databend-common-ast to 0.2.3 by @KKould in #18915
• chore: refine UDF transport error messaging by @BohuTANG in #18910
• chore(query): Compatible with the MySQL BI Ecosystem by @TCeason in #18909
• chore: update meta-service feature requirements for meta-client by @drmingdrmer in #18911
• chore: Enable Advanced Indexing Features for Community Edition by @b41sh in #18917

Full Changelog: v1.2.834-nightly...v1.2.835-nightly

v1.2.834-nightly

What's Changed

Exciting New Features ✨

• feat(query): masking policy USING clause with multi-column support by @TCeason in #18884
• feat(query): the HTTP protocol supports returning a body in arrow IPC format by @forsaken628 in #18890
• feat: support DataType TimestampTz by @KKould in #18892
• feat: support ANSI CURRENT_DATE/CURRENT_TIME keywords by @BohuTANG in #18902

Thoughtful Bug Fix 🔧

• fix(query): prevent modification of columns with security policies by @TCeason in #18896
• fix: hilbert recluster get parser error by @zhyass in #18904
• fix: trim duplicated metrics suffix by @everpcpc in #18908

Code Refactor 🎉

• refactor: include databend-metabench in release packages by @drmingdrmer in #18912

Build/Testing/CI Infra Changes 🔌

• ci: fix flaky test. by @youngsofun in #18898

Others 📒

• chore(query): declare var in procedure support optional default expr by @sundy-li in #18897
• chore: improve error msg by @camilesing in #18885

Full Changelog: v1.2.833-nightly...v1.2.834-nightly