alibaba / alibaba/DataX

mysqlwriter 中postSQL,当postSQL 很长的时候,只会执行一部分postSQL语句

Open
#295 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

example

```
"postSql": [
"RENAME TABLE sometable_bk TO sometable_new;RENAME TABLE sometable TO sometable_bk;RENAME TABLE sometable_new TO sometable_bk;RENAME TABLE sometable_abcd TO sometable_abcd_bk;"
],
```
执行的时候,会截取一部分,之后报语法错误

```
java.sql.SQLSyntaxErrorException: 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 'RENAME TABLE
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at the mysqlwriter handling of the postSql entry and reproduce the issue with the long sequence of RENAME TABLE statements shown in the report. Trace why only part of the SQL reaches MySQL; done means the complete postSql value executes without the reported syntax error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.