-
Bug
-
Resolution: Done
-
Major
-
1.8.1.Final
-
None
-
False
-
None
-
False
-
Critical
In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
Java connector 1.8.1.Final
Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `ssb_warp`.`test_view` (
`mview$pk` bigint DEFAULT NULL,
`LO_OrderKey` bigint NOT NULL,
`LO_LineNumber` tinyint NOT NULL,
`LO_CustKey` int NOT NULL,
`LO_PartKey` int NOT NULL,
`LO_SuppKey` int NOT NULL,
`LO_OrderDateKey` int NOT NULL,
`LO_OrderPriority` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`LO_ShipPriority` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`LO_Quantity` tinyint DEFAULT NULL,
`LO_ExtendedPrice` int DEFAULT NULL,
`LO_OrdTotalPrice` int DEFAULT NULL,
`LO_Discount` int DEFAULT NULL,
`LO_Revenue` int DEFAULT NULL,
`LO_SupplyCost` int DEFAULT NULL,
`LO_Tax` tinyint DEFAULT NULL,
`LO_CommitDateKey` int NOT NULL,
`LO_ShipMode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`mview$hash` bigint unsigned NOT NULL DEFAULT '0'
) START TRANSACTION ENGINE=InnoDB'
mismatched input 'ENGINE' expecting {<EOF>, '-'}
at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:327)
at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:967)
at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:73)
at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)
at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82)
at io.debezium.connector.mysql.MySqlDatabaseSchema.parseDdl(MySqlDatabaseSchema.java:223)
at io.debezium.connector.mysql.MySqlDatabaseSchema.parseStreamingDdl(MySqlDatabaseSchema.java:209)
at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleQueryEvent(MySqlStreamingChangeEventSource.java:576)
at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.lambda$execute$14(MySqlStreamingChangeEventSource.java:832)
at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleEvent(MySqlStreamingChangeEventSource.java:349)
... 6 more
Caused by: org.antlr.v4.runtime.InputMismatchException
at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)
at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:950)
... 14 more
Engine terminated
Reading from MySQL 8.0.30 - the issue happens after a CREATE TABLE .. AS SELECT statement with GTID_MODE=ON