Reporting Issua : Execute Line does not work properly when Cases in SELECT
| User, date | Message |
|---|---|
|
Written by mikgigs
4 years ago Category: General 20 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
4 years ago 20 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
4 years ago 20 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. |