When using one or more nested CASE WHEN ... END statements in a select clause, auto-completion no longer works.
FOR example:
SELECT
CASE WHEN special = 1 THEN specialorderno ELSE CASE WHEN orderno = '' THEN orderno1 ELSE orderno2 END END as OrderNumber
FROM ....
Removing the CASE statement (or marking it as comment) restores the auto-complete functionality.
Only tested with MS-SQL
This is an auto-completion limitation and will be looked into in a future release.
Issue #15800 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
This is an auto-completion limitation and will be looked into in a future release.