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

[expired user #4382]'s profile image [expired user #4382] posted 15 years ago in General Permalink
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.
[expired user #4382]'s profile image [expired user #4382] posted 15 years ago Permalink
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.
[expired user #4382]'s profile image [expired user #4382] posted 15 years ago Permalink
My mistake, It doesn't work with multiline SELECT at all;

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