Hi,
i dound an issue with the execute line option:
It works usually with texts like that:
SELECT ... something
from
something
where something
doesn't matter the position of the curser on these lines, it works well..
When SELECT clause has CASE clause like that :
SELECT something,(CASE something WHEN something THEN something END) from somewhere;
It works with multiline selection and execution....
I suppose that execute line parser thinks that CASE belongs to a procedure or functoin and does not suppose that this could be
a part of select..
Thanks.
Reporting Issua : Execute Line does not work properly when Cases in SELECT
Hi,
i found an issue with the execute line option:
It works usually with texts like that:
SELECT ... something
from
something
where something
doesn't matter the position of the curser on these lines, it works well..
When SELECT has CASE clause like that :
SELECT something,(CASE something WHEN something THEN something END) from somewhere;
But It works with multiline selection and execution....
I suppose that execute line parser thinks that CASE belongs to a procedure or functoin and does not suppose that this could be
a part of select..
Thanks.
i found an issue with the execute line option:
It works usually with texts like that:
SELECT ... something
from
something
where something
doesn't matter the position of the curser on these lines, it works well..
When SELECT has CASE clause like that :
SELECT something,(CASE something WHEN something THEN something END) from somewhere;
But It works with multiline selection and execution....
I suppose that execute line parser thinks that CASE belongs to a procedure or functoin and does not suppose that this could be
a part of select..
Thanks.
Please login to leave a reply, or register at first.