alibaba / alibaba/DataX

迁移的表名有MySQL关键字,导致报错。

Open
#1,208 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

迁移的表中有个叫keys的
从pg迁移到mysql,报如下错误:
select * from keys where 1=2 具体错误信息为:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'keys where 1=2' at line 1

Contributor guide

No contributing guide indexed for this repository

Research direction

The report concerns migration SQL for a table named `keys` when moving from PostgreSQL to MySQL. Start by reproducing the shown `select * from keys where 1=2` failure and trace the migration path that emits it; done means the migrated table can be queried successfully on MySQL.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql, postgresql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.