codefori / codefori/vscode-db2i

Invalid SQL statement selection and invalid syntax errors when `THEN` is used

Open
#453 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
TypeScript
Stars
76
Forks
54
Avg merge
17m
Merged PRs (30d)
1

Description

Attempting to run the following statement fails as the selection range becomes invalid
Image

```sql
CREATE MASK mask_ccnum
ON customers
FOR COLUMN cc_number
RETURN
CASE
WHEN cc_number IS NULL THEN NULL
ELSE
'XXXX-XXXX-XXXX-' || SUBSTR(cc_number, CHAR_LENGTH(cc_number) - 3, 4)
END
ENABLE;
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.