View Issue Details

IDProjectCategoryView StatusLast Update
0002240Database Workbench v6Firebird Modulepublic2024-07-15 14:06
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
Status closedResolutionfixed 
Product Version6.5.0 
Fixed in Version6.5.2 
Summary0002240: FB 2.5 and before: Access Violation on invalid plan after preparing query
DescriptionIf I try to prepare a query with many lines in the SQL Editor Window I get "Access violation in module dbw6o_fb.bpl"
Steps To ReproduceRun

execute block returns (lijn varchar( 50 ) ) as
declare variable i integer;
  i = 1;
  lijn = 'select ''Hallo Martijn'' from rdb$database
union ';
  while ( i < 100 ) do
    i = i + 1;
  lijn = 'select ''dat is genoeg'' from rdb$database';

export the result as comma separated file to clipboard without including header and with [none] as Text Delimiter, paste into another SQL Editor Window and try to prepare.
Additional InformationThe reason I discovered this was because I tried to do a tiny modification to a stored procedure and got a strange warning about the stored procedure containing an error (you may want to check the stored procedure editor as well, I chose to exit without saving). Changing to execute block worked on DBW 5.7.6, but not 6.5.0. Trying to make a reproducible case for you revealed it was the length of the query.
TagsNo tags attached.


Svein Erling Tysvær

2024-06-04 11:34

reporter   ~0000608

The error actually only happens when preparing the query, no error is reported when trying to run it

Martijn Tonies

2024-06-26 10:08

administrator   ~0000610

Hello Set,

I can confirm this on Firebird 2.5, but not on Firebird 3. What version are you using?

Martijn Tonies

2024-06-26 10:45

administrator   ~0000611

This had to do with a plan that was too large, the access violation was caused by a display error afterwards. I've increased the parser capacity and fixed the display error.

Issue History

Date Modified Username Field Change
2024-06-04 11:20 Svein Erling Tysvær New Issue
2024-06-04 11:34 Svein Erling Tysvær Note Added: 0000608
2024-06-26 10:08 Martijn Tonies Assigned To => Martijn Tonies
2024-06-26 10:08 Martijn Tonies Status new => feedback
2024-06-26 10:08 Martijn Tonies Note Added: 0000610
2024-06-26 10:25 Martijn Tonies Summary Long queries in the SQL Editor creates access violation upon prepare => FB 2.5 and before: Access Violation on invalid plan after preparing query
2024-06-26 10:45 Martijn Tonies Note Added: 0000611
2024-06-26 10:45 Martijn Tonies Status feedback => resolved
2024-06-26 10:45 Martijn Tonies Resolution open => fixed
2024-06-26 10:45 Martijn Tonies Fixed in Version => 6.5.2
2024-07-15 14:06 Martijn Tonies Status resolved => closed