v1.2.644-nightly

What's Changed

Exciting New Features ✨

• feat(query): window partition by spill to disk by @forsaken628 in #16441
• feat(query): Simplified version Pattern S/L/D/G for number to_char by @forsaken628 in #16569
• feat(query): add json array lambda functions by @sundy-li in #16573
• feat(query): support describe user statement by @b41sh in #16579
• feat: copy option 'pattern' support variable. by @youngsofun in #16525
• feat(query): support json array functions by @b41sh in #16571

Thoughtful Bug Fix 🔧

• fix: direct io syscall not available on mac by @forsaken628 in #16574
• fix: window in scalar subquery returns wrong results by @xudong963 in #16567
• fix: avoid eliminating the left child of union in RuleEliminateUnion by @xudong963 in #16584
• fix(query): fix inverted index panic caused by null value by @b41sh in #16576
• fix(query): fix cannot obtain stack trace when segmentation fault by @zhang2014 in #16566
• fix: merge into panic by @zhyass in #16581
• fix(query): list_dictionaries should not ignore db_id by @TCeason in #16587
• fix(iceberg): Make sure iceberg table has been loaded by @Xuanwo in #16593
• fix: Disable prewhere for iceberg table for now by @Xuanwo in #16597

Code Refactor 🎉

• refactor: Automatically chunk large key sets in KVPbApi methods by @drmingdrmer in #16561
• refactor: simplify get_tables_history() by @drmingdrmer in #16572
• refactor(iceberg): Use iceberg file IO instead of our own operator by @Xuanwo in #16577
• refactor: add SchemaApi::get_table_in_db by @drmingdrmer in #16582
• refactor: SchemaApi::get_table_meta_history() by @drmingdrmer in #16586
• refactor: fix error message. by @youngsofun in #16578
• refactor(storage): inverted index use merge io to read data by @b41sh in #16589

Others 📒

• chore(query): SHOW/DESC is not DDL by @TCeason in #16583
• chore: check lock revision before watch delete by @zhyass in #16590
• chore(ci): flaky test by @zhyass in #16596

Full Changelog: v1.2.643-nightly...v1.2.644-nightly