Details
-
Feature Request
-
Resolution: Done
-
Blocker
-
0.2.1
-
None
Description
While running connector debezium failed with following error
(io.debezium.connector.mysql.MySqlSchema:292) io.debezium.text.ParsingException: Expecting ')' at line 69, column 21 but found 'NOT': `key` varchar(64) ===>> NOT NULL DEFAULT '', at io.debezium.text.TokenStream.consume(TokenStream.java:693) at io.debezium.connector.mysql.MySqlDdlParser.parseCreateDefinitionList(MySqlDdlParser.java:398) at io.debezium.connector.mysql.MySqlDdlParser.parseCreateTable(MySqlDdlParser.java:224) at io.debezium.connector.mysql.MySqlDdlParser.parseCreate(MySqlDdlParser.java:149) at io.debezium.connector.mysql.MySqlDdlParser.parseNextStatement(MySqlDdlParser.java:130) at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:275) at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:256) at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:290) at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:270) at java.lang.Thread.run(Thread.java:745)
(original)
Here is the table structure:
`CREATE TABLE `XXXXX` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `YYYY` bigint(20) unsigned NOT NULL, `key` varchar(64) NOT NULL DEFAULT '', `value` text, `FFFFF` tinyint(4) DEFAULT '0', `DDDD` bigint(20) DEFAULT '0', `TTTT` binary(16) DEFAULT NULL, `BBB` text, PRIMARY KEY (`id`), KEY `TYTUT` (`risk_info_id`), KEY `BGFH` (`key`), KEY `HGJG` (`risk_info_id`,`create_time`), KEY `EEEEE` (`is_encrypted`), KEY `GGGGG` (`risk_info_id`,`context_uuid`), KEY `HGHGHG` (`context_uuid`), CONSTRAINT `GHGHGHGHG` FOREIGN KEY (`risk_info_id`) REFERENCES `HGHGHG` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10851 DEFAULT CHARSET=utf8;`
(original)