View Issue Details

IDProjectCategoryView StatusLast Update
0001653Database Workbench v5Firebird Modulepublic2021-09-20 13:06
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionwon't fix 
Product Version5.4.6 
Summary0001653: Error while parsing plan: TPlanParser.ParsePlanItem: Unrecognized PLAN syntax
DescriptionPlan 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 ()
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

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