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