Add data types to integration tests

[cyliu0]

We will cover the data types for different sources/sinks as much as possible in the integration tests. We'll cover all the zero, null, maximum, and minimum values in the test. For overflow values, we'll test it depending on the testing result and the test implementation

[cyliu0]

For zero value testing, we have two issues just fixed for array. #11351 #11352

And for the record, we don't plan to support the zero date time like '0000-00-00' for MySQL and dates Before Christ for PostgreSQL

[cyliu0]

Found the numeric type different from PostgreSQL https://github.com/risingwavelabs/risingwave-docs/issues/886 . The document should be fixed.

[cyliu0]

So far we've added the following source/sinks

• PG cdc source test(connector): add PG CDC data compatibility test #13176
• MySQL cdc source test(connector): add mysql cdc compatible test #13546
• redis sink test(connector): add redis-sink compatible test #13772
• kafka cdc sink test(connector): add kafka-cdc-sink compatible test #13607
• clickhouse sink test(connector): add clickhouse-sink compatible test #14026
• es sink test(connector): add es-sink compatible test #14522
• pg sink test(connector): add pg-sink compatible test #14615
• mysql sink test(connector): add mysql-sink compatible test #14688
• cassandra/scyllabd sink test(connector): add cassandra/scyllabd-sink compatible test #14709
• debezium-pg test(source): add debezium-pg compatible test #14862
• debezium-mysql test(source): add debezium-mysql compatible test #14891

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.