distal-attribute
distal-attribute
distal-attribute
distal-attribute

Reporting Issua : Execute Line does not work properly when Cases in SELECT

User, date Message
Written by mikgigs
5 years ago
Category: General
21 posts since Mon, 12 Oct 09
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.
Written by mikgigs
5 years ago
21 posts since Mon, 12 Oct 09
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.
Written by mikgigs
5 years ago
21 posts since Mon, 12 Oct 09
My mistake, It doesn't work with multiline SELECT at all;
 

Please login to leave a reply, or register at first.