F5 feature or bug?

Toad 16.3.230.2084

For this test, the editor window has been loaded with the following commands:

set head off;set feed off
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;
select 1 from dual;

Try placing the cursor on different lines and run F5. When the script has completed, the cursor is not at the last line.

Try F5 with a highlighted block of lines. Cursor lands at the line above the last line executed.

Now the scenario that brought this to my attention. I had generated over 2000 drop directory statements. As a precaution, I ran the first one with F9 just to confirm that the syntax was correct. Then I highlighted the remaining lines and hit F5. When done the cursor was at the next to last line and that line was highlighted. Then I ask myself, WTF, did the last line run or not? LOL

Regards,
Doug

1 Like

This is a defect, but only for the position of the caret following execution. For some reason it is jumping up a line in all cases. Toad is executing the statement that was selected though. I just confirmed using Spool SQL. I will log the post-execution caret position defect.

Thanks Michael for confirming my suspicions.