-
Notifications
You must be signed in to change notification settings - Fork 4.1k
"unknown oid type: 114" when sending JSON data in wire format #88355
Copy link
Copy link
Closed
Labels
A-tools-hasuraC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)X-blathers-triagedblathers was able to find an ownerblathers was able to find an owner
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-tools-hasuraC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)X-blathers-triagedblathers was able to find an ownerblathers was able to find an owner