codefori / codefori/vscode-db2i
Invalid SQL statement selection and invalid syntax errors when `THEN` is used
Open
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
```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.