why does sqlcl replace "CAST" when pasting a

Asked Jul 20 '22 at 20:05

Active Jul 20 '22 at 20:34

Viewed 51 times

SQLcl: Release 21.4

Oracle Database 19c Enterprise Edition Version 19.15.0.0.0

When pasting a query into SQLcl I noticed a strange behaviour, when my query that executed fine in DBeaver had a syntax error in SQLcl. The problem is caused by auto replace of <tab>.

My query had a part like this:

“select case
<tab> when…”

when pasted into SQLcl it magically becomes:

“select case
cast when…”

Even stranger, when you enter “select case” in SQLcl and hit <tab> it will replace your case with CAST.

Is it a bug or is it a feature?

edited Jul 20 '22 at 20:34

Alex Poole

183,384
11
179
318

asked Jul 20 '22 at 20:05

Ralph Urban

Sounds like it's auto-completing? – Alex Poole Jul 20 '22 at 20:39
I can't reproduce this in 22.2... – thatjeffsmith Jul 20 '22 at 20:44
quite likely that it is auto-completing, but then it is likely a bug, since CASE is valid at this place. I will try to reproduce this with 22.2. – Ralph Urban Jul 21 '22 at 08:36

why does sqlcl replace "CAST" when pasting a

0 Answers0