v0.8.79-nightly

What's Changed

Exciting New Features ✨

• feat(meta/schema_api): add API list_all_tables by @drmingdrmer in #8254
• feat(http handler): return error when download result of a running query by @youngsofun in #8268
• feat(query): optimize StringSearchLike vector_const by @TCeason in #8220
• feat(query): migrate datetime rounder functions to v2. by @RinChanNOWWW in #8281
• feat: optimize subquery by deleting redundancy join by @xudong963 in #8264

Thoughtful Bug Fix 🔧

• fix: Query version is incorrect by @Xuanwo in #8272
• fix(logic test): print error message for http handler. by @youngsofun in #8284
• fix(processor): support abort for left mark join by @zhang2014 in #8248
• fix: Query startup too slow for reqsign retry by @Xuanwo in #8289
• fix: failed to release the permits on time in the block pruner by @dantengsky in #8294
• fix(meta): import: AsKeySpace::clear() should not entire sled tree by @drmingdrmer in #8288

Code Refactor 🎉

• refactor(expression): fix scalar repeat by @sundy-li in #8275
• refactor(query): improve comparison number with string by @sundy-li in #8293

Build/Testing/CI Infra Changes 🔌

• ci: add ulimit nofile for sqllogic test by @everpcpc in #8283

Documentation 📔

• docs: purge tips by @soyeric128 in #8266
• docs: joins by @soyeric128 in #8265

Full Changelog: v0.8.78-nightly...v0.8.79-nightly