CalvinKirs opened a new pull request, #32379:
URL: https://github.com/apache/doris/pull/32379
## Proposed changes
The Insert statement lacks a corresponding toSql implementation. Therefore,
we can only parse the corresponding execution statement from the original SQL.
However, the original parsing method relies on the keyword index of "do" to
determine the SQL execution position. When the JOB name is "do", this leads to
an error where the execution SQL statement is extracted incorrectly.
eg:
```
CREATE JOB do ON SCHEDULE every 2 minute comment ' do'
DO insert into address values ('2023-07-19', 2, 1001);
```
To avoid this issue, we must first determine the positions of jobname and
Comment before extracting the SQL position.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
