View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001653 | Database Workbench v5 | Firebird Module | public | 2018-11-15 16:38 | 2021-09-20 13:06 |
Reporter | Doychin Bondzhev | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | won't fix | ||
Product Version | 5.4.6 | ||||
Summary | 0001653: Error while parsing plan: TPlanParser.ParsePlanItem: Unrecognized PLAN syntax | ||||
Description | Plan parser does not work properly with FB 3 plans The following plan is generated by FB 3.0.4 for a statement: PLAN SORT (JOB_TASKS INDEX (IDX_JOB_TASKS_004)) The statement in question is : SELECT ID, TASK_NAME, TIME_TO_EXECUTE, JOB_EXECUTOR, JOB_INFO, EXIT_STATUS, COMPLEATED, TIMEOUT, RETRIES, WAIT_TIMEOUT, MARKER, PRIORITY FROM JOB_TASKS WHERE PRIORITY = 1 AND RETRIES > 0 AND COMPLEATED IS NULL order by TIME_TO_EXECUTE + 0 If I remove the last part(+0) the plan changes to: PLAN (JOB_TASKS ORDER IDX_JOB_TASKS_003 INDEX (IDX_JOB_TASKS_004)) and that works with DBW but first plan produces error message: Error while parsing plan: TPlanParser.ParsePlanItem: Unrecognized PLAN syntax -- "NATURAL", "INDEX" or "ORDER" not found after alias: IDX_JOB_TASKS_004)) Same query with +0 produces this plan in FB 2.5: PLAN SORT ((JOB_TASKS INDEX (IDX_JOB_TASKS_004))) It is almost the same like one from FB3 with few additional () | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2018-11-15 16:38 | Doychin Bondzhev | New Issue | |
2021-09-20 13:06 | Martijn Tonies | Assigned To | => Martijn Tonies |
2021-09-20 13:06 | Martijn Tonies | Status | new => closed |
2021-09-20 13:06 | Martijn Tonies | Resolution | open => won't fix |