-
Notifications
You must be signed in to change notification settings - Fork 8.3k
JSON type: can't create a type hint for a field named 'skip' #92731
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release
Description
Company or project name
Monumental
Describe what's wrong
I'm trying to create a JSON type as follows:
JSON(a Nullable(String), `skip` Nullable(Bool))
But that's not possible, because 'skip' gets interpreted as the SKIP keyword and this becomes a syntax error. I can't figure out a way to create a type hint for a JSON field named 'skip'
Does it reproduce on the most recent release?
Yes
How to reproduce
clickhouse-local --query "CREATE TABLE a (b JSON(`skip` Nullable(Bool)))"
Expected behavior
I can define a type hint for a column named 'skip'
Error message and/or stacktrace
Code: 62. DB::Exception: Syntax error (data type): failed at position 19 ((): (Bool)). Expected one of: token sequence, Dot, token. (SYNTAX_ERROR)
Additional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release