v1.2.892-nightly

What's Changed

Exciting New Features ✨

• feat: recursive cte support sudoku by @KKould in #19599
• feat: add fast paths for substr and string column concat by @KKould in #19628
• feat: add binary fuse32 bloom index option by @SkyFan2002 in #19621
• feat: add http_json_result_mode and refactor HTTP result string encoding by @youngsofun in #19639
• feat: speed up equi ASOF joins by @KKould in #19654
• feat(sql): add AUTO datetime format detection by @TCeason in #19659

Thoughtful Bug Fix 🔧

• fix(query): fix variant cast to number by @b41sh in #19623
• fix(sql): avoid uint ndv overflow in scan stats by @sundy-li in #19632
• fix: skip on_finish in CommitMultiTableInsert on error to preserve stream by @zhang2014 in #19637
• fix(docs): correct broken tests/ut link in SQL README by @dqhl76 in #19645
• fix(query): use jiff to_zoned for naive datetime timezone resolution by @TCeason in #19647
• fix(ast): parse X'...' as binary literal by @sundy-li in #19636
• fix(ci): fix broken links checker by @dqhl76 in #19649
• fix(query): handle repeated % in LIKE folding by @sundy-li in #19590
• fix: handle empty IEJoin outer fill by @sundy-li in #19604
• fix(storage): inflated block size estimation caused by shared string buffers by @zhyass in #19657
• fix(query): guard metadata consistency for flashback, time travel, and DDL column operations by @zhyass in #19653
• fix(query): SET_VAR hint write into the shared query_settings by @TCeason in #19663
• fix(query): support IF NOT EXISTS for ALTER TABLE ADD COLUMN by @sundy-li in #19615

Build/Testing/CI Infra Changes 🔌

• ci: add macOS PR check by @forsaken628 in #19662

Others 📒

• chore: bump dtparse to 7a9e40f by @TCeason in #19640

Full Changelog: v1.2.891-nightly...v1.2.892-nightly