10.6.1.3 Editor returning inconsistent results for SQL
query
Yes, when there is highlighted code, the editor will only execute the
highlighted code when F9 is pressed
Very interesting. I was able to duplicate the issue with the following:
select sysdate
from dual
where 1 = :first_val;
It appears to be linked in to the parameter values. Even placing a “2 = 2”
on the final line with the semi-colon still produces the error. Replace the
parameter with actual an actual value and it works just fine.
Looks like a parsing issue.
I’m on version 10.6.1.3
Roger S.
Roger, Thanks for the verification and the test case too. It was Friday
afternoon when I wrote that and I didn’t have time to work out a simple test
case.
TOAD developers, Is this something you feel I should submit as a bug, or is this
a known issue, or is this thread alone enough?
John
Yes I understand that. My issue is something else. I’m highlighting my code.
It appears to be executing it and returning an incorrect result some of the
time. I can get different results depending on whether I stop the highlighting
exactly at the semicolon or if I drag up from the (blank) line following the
semicolon or I drag down from the top past the semicolon into the next (blank)
line. How I highlight makes a difference in the number of rows returned. I would
think the blank line below the highlighted code wouldn’t make a difference.
That was my point.
Ok, I remember this one. It’s already fixed in Toad 11 beta.
Michael
That’s good to know. Thanks!
John