Skip to content

JSON type: can't create a type hint for a field named 'skip' #92731

@bouk

Description

@bouk

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

Metadata

Metadata

Assignees

Labels

bugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions