ci:add cache in ci compling

fix: last cache read problem after schema change

fix: auto retention

* fix: windows release from tdengine/package/release.bat failed

* fix: TDengine spelling

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

fix: mem leak when fd excced limit

typo: pthread_cleanup_push/pop better exist in pair

fix:core dump if data block size is 0

fix:set timestamp precision

fix:asan error

fix(query): record the correct last accessed key in the stt file.

fix: change default config

ci:adjust test cases

test:add test case for TD-22532

fix: add missing db options in show create database result

fix: projection query with descending order result error