merge 3.0

fix: compact wrong data count

merge main

* docs: add jdbc 3.1.0 version description

* docs: fix jdbc description

* docs: add tmq over websocket demo

* docs: fix jdbc tmq demo path

* docs: docs demo in CI

* fix: add jdbc version

* docs: use subscription instead of tmq

* docs: fix format

* docs: adjust tmq doc format

* docs: fix format of tmq doc

---------
Co-authored-by: Shuduo Sang <sangshuduo@gmail.com>

fix(query): expand output buffer.

fix(query): fix syntax errors on centos.

* docs: add jdbc 3.1.0 version description

* docs: fix jdbc description

* docs: add tmq over websocket demo

* docs: fix jdbc tmq demo path

* docs: docs demo in CI

* fix: add jdbc version

* docs: use subscription instead of tmq

* docs: fix format

---------
Co-authored-by: Nhuolibo <huolibo@qq.com>

fix: alter column length too big issue

enh: drop tables syntax optimization

fix: create index error

fix: fix distributed table error

fix: opt trans debug info

fix:Ignore expression exception & add some log

fix: fix asan error

* docs: add jdbc 3.1.0 version description

* docs: fix jdbc description

* docs: add tmq over websocket demo

* docs: fix jdbc tmq demo path

* docs: docs demo in CI

* fix: add jdbc version

* docs: use subscription instead of tmq

---------
Co-authored-by: Shuduo Sang <sangshuduo@gmail.com>

* fix: TD-22674 coverity scan

* fix: compile error

---------
Co-authored-by: Nfacetosea <25808407@qq.com>

fix: bad sql grammar

fix: fix asan error

fix: report error when NULL ts is inserted

* fix: docker doc refine

* fix: refine dockerfile

enh: refactor syncBeginSnapshot and walBeginSnapshot for logRetention

fix: resolve coverity scan issues in sync and wal