View Issue Details

IDProjectCategoryView StatusLast Update
0000806Database Workbench v4SQL & Parameter Insightpublic2014-03-19 11:54
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version4.4.3 
Fixed in Version4.4.5 
Summary0000806: Possible out of memory when invoking sql insight
DescriptionOut of memory error when I try to invoke sql insight. Possibly parser error.
Steps To Reproduce1. Restore database from backup.
2. Connect to it and open single sql window
3. Paste this select statement:

select *
from PAYMENT
join (select CANDIDATEID from PAYMENT
where PAYEDSUM > 0
group by CANDIDATEID
having count(*) > 1) mc(id) on mc.id = PAYMENT.CANDIDATEID
order by PAYMENT.CANDIDATEID, PAYMENT.CLOSEDDATE

4. Now insert a line between from payment and join
5. write join and invoke sql insight

Expected: get a list of tables and procedures
Actual: DBW stuck in infinite loop and crashes after some time with Out of memory error
TagsNo tags attached.
DBMS & Version

Activities

Doychin Bondzhev

2014-02-12 13:34

reporter  

KSKVMI.zip (21,629 bytes)

Issue History

Date Modified Username Field Change
2014-02-12 13:34 Doychin Bondzhev New Issue
2014-02-12 13:34 Doychin Bondzhev File Added: KSKVMI.zip
2014-02-14 12:14 Martijn Tonies Status new => acknowledged
2014-02-19 11:13 Martijn Tonies Assigned To => Martijn Tonies
2014-02-19 11:13 Martijn Tonies Status acknowledged => assigned
2014-02-19 13:05 Martijn Tonies Status assigned => resolved
2014-02-19 13:05 Martijn Tonies Fixed in Version => 4.4.5
2014-02-19 13:05 Martijn Tonies Resolution open => fixed
2014-02-19 15:32 Martijn Tonies Category Firebird Module => SQL & Parameter Insight
2014-02-25 09:35 Martijn Tonies Summary Out of memory when invoking sql insight => Possible out of memory when invoking sql insight
2014-03-19 11:54 Martijn Tonies Status resolved => closed