× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ssperling reported 2020-06-29T11:40:22Z  · tomconrad last modified 2020-06-29T15:21:48Z

auto-complete stops working with nested case


usability
Priority Low
Complexity Unknown
Component Q Analyzer - Auto-Completion
Version Future

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

Issue #15800

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017