View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001487Database Workbench v5Firebird Modulepublic2017-04-10 21:472021-09-20 13:08
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionwon't fix 
Platformx86OSWindowsOS Version7 x64
Product Version5.2.6 
Summary0001487: <<Error while parsing plan: TPlanParser.ParsePlanJoin: Unrecognized Text: "(">>
DescriptionWhen executing the query in the "Additional Information", you get the correct result (1 million rows), but when asking for the plan, you get this error:

Error while parsing plan: TPlanParser.ParsePlanJoin: Unrecognized Text: "("

Note: Firebird 2.5.2.26540 x86
Steps To Reproduce1. Execute the query
2. View the plan

Additional InformationQuery:

with recursive
  tripledigits(n) as (
    -- When you select more than 1024, this error occurs:
    -- Error while fetching data: Too many concurrent executions of the same request
    select 0 -- start
    from rdb$database
    union all
    select tripledigits.n + 1
    from tripledigits
    where tripledigits.n < 999 -- finish
  ),
  tripledigits000(n) as (
    select tripledigits.n * 1000
    from tripledigits
  ),
  -- prepared in 0.0075-0.126 seconds, processed in 3.663-4.575 seconds - rows fetched: 250
  sextupledigits(n) as (
    select tripledigits.n
          + tripledigits000.n
    from tripledigits
    cross join tripledigits000
    order by tripledigits.n
          + tripledigits000.n
  )
select sextupledigits.n
from sextupledigits
order by sextupledigits.n
TagsNo tags attached.

Activities

Jeroen Pluimers

2017-04-10 21:55

reporter   ~0000419

This is the PLAN for that query:

PLAN SORT (SORT (JOIN ((SEXTUPLEDIGITS TRIPLEDIGITS RDB$DATABASE NATURAL)
PLAN JOIN ()(SEXTUPLEDIGITS TRIPLEDIGITS000 TRIPLEDIGITS RDB$DATABASE NATURAL)
PLAN JOIN ())))

There are various similar queries (all involving multiple CTE of which one uses RDB$DATABASE) giving the same error. I can get you those as well.

Martijn Tonies

2021-09-20 13:08

administrator   ~0000557

Database Workbench 6 will support the extended explain plan of Firebird 3 and up, old plan syntax parsing is obsolete.

Issue History

Date Modified Username Field Change
2017-04-10 21:47 Jeroen Pluimers New Issue
2017-04-10 21:55 Jeroen Pluimers Note Added: 0000419
2021-09-20 13:08 Martijn Tonies Assigned To => Martijn Tonies
2021-09-20 13:08 Martijn Tonies Status new => closed
2021-09-20 13:08 Martijn Tonies Resolution open => won't fix
2021-09-20 13:08 Martijn Tonies Note Added: 0000557