search

wgzhao / Addax

Addax is a versatile open-source ETL tool that can seamlessly transfer data between various RDBMS and NoSQL databases, making it an ideal solution for data migration.
https://wgzhao.github.io/Addax/
Apache License 2.0
1.2k stars 304 forks source link

[Bug]: Mysql Reader 如果列名中包含关键字名，比如year、year_month之类的报语法检查错误 #1124

Closed svea-vip closed 2 months ago

svea-vip commented 2 months ago

What happened?

Mysql Reader 如果列名中包含关键字名，比如year、year_month之类的报语法检查错误

Version

4.1.7 (Default)

OS Type

Linux (Default)

Java JDK Version

Oracle JDK 1.8.0

Relevant log output

com.wgzhao.addax.common.exception.AddaxException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dec,update_time,id,year,jygs,update_man FROM bi.tb_r_xvyb_target' at line 1
        at com.wgzhao.addax.common.exception.AddaxException.asAddaxException(AddaxException.java:50)
        at com.wgzhao.addax.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:45)
        at com.wgzhao.addax.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:245)
        at com.wgzhao.addax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:126)
        at com.wgzhao.addax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:82)
        at java.lang.Thread.run(Thread.java:745)
wgzhao commented 2 months ago

请看文档说明 https://wgzhao.github.io/Addax/latest/reader/rdbmsreader/#column

svea-vip commented 2 months ago

是新版本的改动，之前4.0.12的版本，我看所有列的拼装都加了``

wgzhao commented 2 months ago

用新版本吧

liuyitian0 commented 2 months ago

咱们有交流群吗?

wgzhao commented 2 months ago

咱们有交流群吗?

没有 没有 QQ 群 没有微信群 没有钉钉群

如果是提交 Bug ， Issue 就足够用了 如果是讨论，discussions 也够用