test: add more integration test for kafka wal #14459

Job	Run time
Build GreptimeDB binaries (ubuntu-20.04)	4m 18s
Check (windows-latest)	5m 10s
Rustfmt	29s
Check (ubuntu-20.04)	1m 40s
Toml Check	37s
Spell Check with Typos	29s
Clippy	2m 23s
coverage	8m 20s
Sqlness Test with Kafka Wal (ubuntu-20.04)	2m 29s
Fuzz Test (fuzz_create_table)	4m 38s
Sqlness Test (ubuntu-20.04)	1m 46s
Compatibility Test	27s
Fuzz Test (fuzz_alter_table)	4m 35s
	37m 21s

Provide feedback