adryan
Member
Hi,
I am using version 7.1.5.1396 and encounter the following situation in SQL Window, when "AutoSelect statement" is checked:
With these two select statements:
select 1 from dual where 1=1;--a
select 1 from dual where 1=0;
The first one returns 1, as it should, but the second one returns also 1, instead of NULL. If the comment is removed, everything is ok.
It seems that somehow the comment is extended over the next line, but only the next line, since if I add a third statement, this third statement returns the correct result.
The issue doesn't reproduce if the comment is put on its own separate line.
The problem is that the "AutoSelect statement" option is too convenient to drop it, but the above described behavior can lead to false assumptions.
Thanks,
Adryan
I am using version 7.1.5.1396 and encounter the following situation in SQL Window, when "AutoSelect statement" is checked:
With these two select statements:
select 1 from dual where 1=1;--a
select 1 from dual where 1=0;
The first one returns 1, as it should, but the second one returns also 1, instead of NULL. If the comment is removed, everything is ok.
It seems that somehow the comment is extended over the next line, but only the next line, since if I add a third statement, this third statement returns the correct result.
The issue doesn't reproduce if the comment is put on its own separate line.
The problem is that the "AutoSelect statement" option is too convenient to drop it, but the above described behavior can lead to false assumptions.
Thanks,
Adryan
