View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001203 | Database Workbench v5 | Firebird Module | public | 2015-04-07 14:54 | 2018-02-15 14:49 |
| Reporter | Michał Ziemski | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| OS | WIndows | OS Version | 7 | ||
| Product Version | 5.0.10 | ||||
| Summary | 0001203: Plan analysis fails on specific plans | ||||
| Description | Plan analysis fails for some plans. If the system fail to recognize the plan it should gracefully print the recieved plan rather than interrupting work with error messages. | ||||
| Additional Information | Example plan: PLAN JOIN (T T WM XX_MS INDEX (MIESTROSOBYOID), T T WM XX_M INDEX (MIEID)) PLAN JOIN (T T WM XX_O INDEX (OSOBYID), T T WM XX_PKW INDEX (PLANKONTWMPLANKONTKID)) PLAN SORT (JOIN (SORT (JOIN (JOIN (JOIN (T T WM WM NATURAL, T T L INDEX (TICKETSYS, TICKETSYS)), SORT (JOIN (T T T TL INDEX (TICKETLABELSI), T T T T INDEX (TICKETID)))), T T TL INDEX (TICKETLABELSTICKETTID))) PLAN (T T L NATURAL), L INDEX (TICKETLABELID))) | ||||
| Tags | No tags attached. | ||||
| related to | 0001211 | closed | Martijn Tonies | IB/Fb; Failure to analyze plan shouldn't interrupt work |
| related to | 0001240 | closed | Martijn Tonies | TPlanParser.ParsePlanItem: Unrecognized PLAN syntax -- "NATURAL", "INDEX" or "ORDER" not found after alias: RDB$PRIMARY38))))) |
|
|
The plan is displayed in the bottom part of the window, but this could be streamlined due to the error messages, I agree. |
|
|
0001487 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-04-07 14:54 | Michał Ziemski | New Issue | |
| 2015-04-08 10:11 | Martijn Tonies | Note Added: 0000374 | |
| 2015-04-08 10:11 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-04-08 10:11 | Martijn Tonies | Status | new => acknowledged |
| 2015-04-13 14:19 | Martijn Tonies | Status | acknowledged => assigned |
| 2015-04-14 15:09 | Martijn Tonies | Summary | Plan analysis fails => Plan analysis fails on specific plans |
| 2015-04-14 15:10 | Martijn Tonies | Relationship added | related to 0001211 |
| 2015-06-09 16:54 | Martijn Tonies | Relationship added | related to 0001240 |
| 2018-02-15 14:49 | Martijn Tonies | Note Added: 0000454 | |
| 2018-02-15 14:49 | Martijn Tonies | Status | assigned => closed |
| 2018-02-15 14:49 | Martijn Tonies | Resolution | open => duplicate |
