track: test coverage improvement

[ZeaLoVe]

Summary

As we start using logic test to replace the former stateless test， ref Start migration of stateless use cases to logic test In order to improve test coverage， we need to add to our own use case set while learning from other good projects.

Such as: CockroachDB logic test YDB logic test DuckDB Doris

Feel free to add in the comments！

tasks

• [x] YDB #6681
• [x] CRDB #7154
• [x] DuckDB #7394
• [ ] Doris

[flaneur2020]

we can try convert this issue into a tracking issue?

for the long term tasks, they're likely able to splitted out some sub issues.

each sub issue can be referenced from the tracking issue like https://github.com/datafuselabs/databend/issues/6547, and sub issue can be auto-closed when the related pull request get merged, so the progress can be easier to get tracked.

[Xuanwo]

SQL Logic Test speed is not as expect: https://github.com/datafuselabs/databend/pull/6681#issuecomment-1189810930

We need to figure what happened, and try to improve them

Added as tasks https://github.com/datafuselabs/databend/issues/6697

[ZeaLoVe]

SQL Logic Test speed is not as expect: #6681 (comment)

We need to figure what happened, and try to improve them

Added as tasks #6697

move to https://github.com/datafuselabs/databend/issues/6699