View Issue Details

IDProjectCategoryView StatusLast Update
0002240Database Workbench v6Firebird Modulepublic2024-06-04 11:34
ReporterSvein Erling Tysvær Assigned To 
PrioritynormalSeveritycrashReproducibilityalways
Status newResolutionopen 
Product Version6.5.0 
Summary0002240: Long queries in the SQL Editor creates access violation upon prepare
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;
begin
  i = 1;
  lijn = 'select ''Hallo Martijn'' from rdb$database
union ';
  while ( i < 100 ) do
  begin
    suspend;
    i = i + 1;
  end
  lijn = 'select ''dat is genoeg'' from rdb$database';
  suspend;
end

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.

Activities

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

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