fastsql parse error when DDL contains 'ALGORITHM=inplace' - Githubissues

alibaba / canal

阿里巴巴 MySQL binlog 增量订阅&消费组件

Apache License 2.0

28.43k stars 7.6k forks source link

fastsql parse error when DDL contains 'ALGORITHM=inplace' #2617

Closed deanwong closed 4 years ago

deanwong commented 4 years ago

[ ✅ ] I have searched the issues of this repository and believe that this is not a duplicate.
[ ✅ ] I have checked the FAQ of this repository and believe that this is not a duplicate.

environment

canal version 1.1.4
mysql version RDS 5.7

Issue Description

Please see the attachment

Steps to reproduce

execute DDL with 'ALGORITHM=inplace'

Expected behaviour

parse correct

Actual behaviour

parse error

If there is an exception, please attach the exception trace:

the sql_text in table tsdb.meta_snapshot

CREATE TABLE `contact` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`version` bigint(20) NOT NULL,
`tenant_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_t_id` (`tenant_id`, `id`)
) ENGINE = InnoDB AUTO_INCREMENT = 33104879 CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci ALGORITHM = inplace;

We have no idea why there is a ALGORITHM = inplace appended after create DDL

canal_parse

agapple commented 4 years ago

对应myql版本是？感觉不是一个合法的ddl语法