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

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

mikgigs posted 5 years ago in General
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.
mikgigs posted 5 years ago
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.
mikgigs posted 5 years ago
My mistake, It doesn't work with multiline SELECT at all;

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