Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
all
-
None
Description
Query parsing for option rewriteBatchedStatements must improve.
Goal is to identify the query that can be rewritten like INSERT into TABLE(a,b) VALUE (1,2).
-> INSERT FROM SELECT cannot be rewritten
-> INSERT ... ON UPDATE must work if no parameter in the UPDATE PART
-> multiple query must not be rewritten (INSERT INTO...; SELECT ...)
-> The "value" part must be well detected even with query with tab character
...
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
when using rewriteBatchedStatements, the query parsing must be improve to idenify the values.
MariaDbStatement:1147 int idx = sqlUpper.indexOf(" VALUE"); isn't parsing. and if not found even throw an exception. |
Query parsing for option rewriteBatchedStatements must improve.
Goal is to identify the query that can be rewritten like INSERT into TABLE(a,b) VALUE (1,2). -> INSERT FROM SELECT cannot be rewritten -> INSERT ... ON UPDATE must work if no parameter in the UPDATE PART -> multiple query must not be rewritten (INSERT INTO...; SELECT ...) -> The "value" part must be well detected even with query with tab character ... |
| Fix Version/s | 1.3.7 [ 21800 ] | |
| Fix Version/s | 1.4.0 [ 19606 ] |
| issue.field.resolutiondate | 2016-03-18 14:57:05.0 | 2016-03-18 14:57:05.381 |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 74451 ] | MariaDB v4 [ 134845 ] |