View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002240 | Database Workbench v6 | Firebird Module | public | 2024-06-04 11:20 | 2024-07-15 14:06 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 6.5.0 | ||||
| Fixed in Version | 6.5.2 | ||||
| Summary | 0002240: FB 2.5 and before: Access Violation on invalid plan after preparing query | ||||
| Description | If 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 Reproduce | Run 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 Information | The 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. | ||||
| Tags | No tags attached. | ||||
|
|
The error actually only happens when preparing the query, no error is reported when trying to run it |
|
|
Hello Set, I can confirm this on Firebird 2.5, but not on Firebird 3. What version are you using? |
|
|
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. |
| 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 |
