SML0127 commented on code in PR #3658:
URL: https://github.com/apache/flink-cdc/pull/3658#discussion_r1845347447
##########
flink-cdc-connect/flink-cdc-pipeline-connectors/flink-cdc-pipeline-connector-mysql/src/test/resources/ddl/column_type_test.sql:
##########
@@ -180,4 +180,22 @@ VALUES (DEFAULT,
23,
29,
31,
- 37);
\ No newline at end of file
+ 37);
+
+CREATE TABLE json_types
+(
+ id SERIAL,
+ json_c0 JSON,
+ json_c1 JSON,
+ json_c2 JSON,
+ int_c INTEGER,
+ PRIMARY KEY (id)
+) DEFAULT CHARSET=utf8;
+
+INSERT INTO json_types
+VALUES (DEFAULT,
+ '{"key1":"value1"}',
+ '{"key1":"value1","key2":"value2"}',
+
'[{"key1":"value1","key2":{"key2_1":"value2_1","key2_2":"value2_2"},"key3":["value3"],"key4":["value4_1","value4_2"]},{"key5":"value5"}]',
+ 1
+ );
Review Comment:
test table for various JSON format data
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
