cli: large query causes `cockroach sql` client to hang

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.13k stars 3.81k forks source link

Open mgartner opened 1 month ago

mgartner commented 1 month ago

Running cockroach sql -f file.sql when file.sql contains a multi-megabyte query causes the client to hang, seemingly indefinitely.

One work around for now is to use psql.

The SQL in https://gist.github.com/mgartner/c06b0ad259e50344c93430ff48282355 can be used to reproduce this, when using cockroach sql instead of psql.

Jira issue: CRDB-43219

blathers-crl[bot] commented 1 month ago

Hi @mgartner, please add branch-* labels to identify which branch(es) this C-bug affects.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}