cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.12k stars 3.81k forks source link

sql: support prepared statements with unknown types #41558

Open asubiotto opened 5 years ago

asubiotto commented 5 years ago

The lib/pq test suite is failing with the following: Postgres:

asubiotto=# prepare q as values ($1,$2,$3);
PREPARE

Cockroach:

root@:26257/defaultdb> prepare q as values($1,$2,$3);
pq: could not determine data type of placeholder $1

Jira issue: CRDB-5435

rafiss commented 3 years ago

This probably is best addressed with an overhaul of our type system to match Postgres more closely