Skip to content

"unknown oid type: 114" when sending JSON data in wire format #88355

@danieljharvey

Description

@danieljharvey

Describe the problem

CockroachDB does not support JSON, and instead uses it as an alias for JSONB. This works in queries, however, when sending JSON via prepared arguments in the PG wire format (ie, using oid 114), it raisees the error unknown oid type: 114 as JSON is not recognised.

If we send the same data as oid 3802 (ie, JSONB) then everything works as expected.

Expected behavior

Ideally, JSON input with oid 114 would be accepted in the wire format and treated as JSONB internally.

Additional context

This is needed for implementing CockroachDB support in Hasura GraphQL Engine.

Jira issue: CRDB-19785
Epic CRDB-11916

Metadata

Metadata

Assignees

Labels

A-tools-hasuraC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)X-blathers-triagedblathers was able to find an owner

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions