SQL Nav 6.0 - crashes

Yesterday I tried new version of SQL Nav, but I had to uninstall it due repeatable crashes.

I was able to reproduce one 100% just by running the following query:


The following piece returns more than 1 row, so the query fails normally in SQL Nav 5.5, but SQL Nav 6.0 crashes with stack overflow or something similar.

SELECT NVL (amount, 0)
FROM invoicehead ih
WHERE ih.contractiid = d.contractiid
AND TRUNC (ih.billdate, ‘MM’) = d.ms

Application exception occurred:
App: C:\Program Files\Quest Software\SQL Navigator for Oracle\sqlnavigator.exe (pid=3712)
When: 9/18/2008 @ 16:05:18.257
Exception number: c00000fd (stack overflow)

Message was edited by: ashmelev

Hm… I reinstalled SQL Nav again just to test one more time and this time it did not crash.

Hi Alexey,

Thank you for your note.

I could not reproduce this issue yet…We will keep an eye on this and will keep you posted if we could manage to reproduce it here.

Thanks and regards,