AV in Editor when formatting (14.0.0.482)

Toad for Oracle - Beta
1

Since beta 14.0.0.482, I'm getting the error as shown below when formatting an Editor window with a couple of slightly complex statements in it.

2020-07-23 14_07_37-Toad.exe

I've tried with just "select * from dual;", but that doesn't trigger the error.

These statements (object names are anonimized) do trigger the error, but not always, sometimes I only get the error after pressing Ctrl-Shift-F 2 or 3 times.

DELETE table5
WHERE  table3_id IN (SELECT id
                     FROM   table3
                     WHERE  table1_id IN (SELECT id
                                          FROM   table1
                                          WHERE  column1 = 'N'));

DELETE table4
WHERE  table3_id IN (SELECT id
                     FROM   table3
                     WHERE  table1_id IN (SELECT id
                                          FROM   table1
                                          WHERE  column1 = 'N'));

DELETE table3
WHERE  table1_id IN (SELECT id
                     FROM   table1
                     WHERE  column1 = 'N');

DELETE table2
WHERE  table1_id IN (SELECT id
                     FROM   table1
                     WHERE  column1 = 'N');

DELETE table1
WHERE  column1 = 'N';

The error also occurs if I delete the FmtPlus.opt file and let Toad create a new one.

2

i got the same if run big script using F5 then i paste new script or make F7

3

This should be fixed in the next beta. Build 482 introduced a bug with highlighting of matching parenthesis and I believe that bug is also responsible for the error you see here. We will build and release a new beta today. Please give it a shot later or tomorrow and let us know if the problem is resolved.

2 Likes
4

I had been able to duplicate this with a number of "SELECT COUNT(*) FROM DUAL;" statements. Just tried it with .487 and no AV.

Thanks Michael!

1 Like
5

Yes, it's fixed in .487. Thanks!

1 Like