Skip to content

Cannot access field of JSON object inside tuple #81630

@sxlijin

Description

@sxlijin

Company or project name

BoundaryML

Describe what's wrong

I'm having issues trying to access a field of a JSON element in a tuple, and I think it's a bug in the clickhouse sql interpreter treating a JsonValue.key_path as a tupleElement(key_path, JsonValue) instead of a json path access.

Does it reproduce on the most recent release?

Yes

How to reproduce

Repro: https://fiddle.clickhouse.com/981a69dd-f13e-4b95-b41b-b7d604958348

Expected behavior

No response

Error message and/or stacktrace

No response

Additional context

Is this an actual bug? If so, is there a possible workaround?

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions