View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001623 | Database Workbench v5 | Diagramming | public | 2018-06-29 15:36 | 2022-01-13 14:11 |
| Reporter | Stephen Lappin | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | won't fix | ||
| Product Version | 5.4.2 | ||||
| Summary | 0001623: Use semi-colon command terminator for trigger DDL | ||||
| Description | When generating (MySQL/MariaDB) DDL, a semi-colon is used for the command terminator for all statements except for triggers (DROP and CREATE). Instead, new-line and forward-slash are used. Many (most?) MySQL clients do not understand this terminator and the DDL fails with an error. Please change the terminator to a semicolon | ||||
| Tags | No tags attached. | ||||
|
|
Hello Stephen, Because Trigger code includes multiple commands, the ';' is also used to end commands and cannot be used as statement terminator. See the multi-line trigger here https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-06-29 15:36 | Stephen Lappin | New Issue | |
| 2022-01-13 11:27 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2022-01-13 11:27 | Martijn Tonies | Status | new => feedback |
| 2022-01-13 11:27 | Martijn Tonies | Note Added: 0000561 | |
| 2022-01-13 14:11 | Martijn Tonies | Status | feedback => closed |
| 2022-01-13 14:11 | Martijn Tonies | Resolution | open => won't fix |
