Toad World® Forums

SQL Stmt with comment at end

When you run this statement (pressing F9), it runs fine, returning one row:

SELECT dummy
FROM DUAL
– test me

But, if there is a Where clause, and the comment on the last line, press F9 and nothing returns in the grid:

SELECT dummy
FROM DUAL
WHERE 1=1
– test me

Even though in the Output window, is shows that the script ran (there is no error):

15:32:37 Start Script Execution …
15:32:37 **** SCRIPT STARTED: 15-Apr-2014 15:32:37 ****
15:32:37 **** SCRIPT ENDED 15-Apr-2014 15:32:37 ****
15:32:37 End Script Execution

Thanks.

-Charlie

Hi Charlie,

Thanks for your reporting. It’s a bug exists in beta1, but we fixed it already in beta 2 which will be released to community soon.

Thanks,

Shirly