COPY FROM STDIN doesn't work with \x-escape bytea values

[arp242]

With the following file:

% cat a.sql
begin;
        create table tbl (b bytea);
        copy tbl from stdin;
\\xfefe
\.
        select b from tbl;
rollback;

PostgreSQL inserts it as bytea:

% psql -X 'postgres://pqgo@localhost/pqgo' <a.sql
BEGIN
CREATE TABLE
COPY 1
   b
--------
 \xfefe
(1 row)

ROLLBACK

But CockroachDB inserts it as a string:

% psql -X 'postgres://pqgo@localhost:26257/pqgo' <a.sql
BEGIN
CREATE TABLE
COPY 1
       b
----------------
 \x5c7866656665
(1 row)

ROLLBACK

\x5c7866656665 is \xfefe.

It looks like this was fixed a few years ago in #69640 (or something similar, anyway), so I think this ought to work?

This originally came up in the context of lib/pq#1304 – to reproduce it there you need to uncomment the pqtest.SkipCockroach and run:

% docker compose up -d cockroach
% PGPORT=26257 go test -run TestCopyInTypes

CockroachDB CCL v26.1.1 (x86_64-pc-linux-gnu, built 2026/03/04 12:08:22, go1.25.5)

Jira issue: CRDB-62373

Epic CRDB-62230

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @rafiss (commented on sql: COPY CSV doesn't support hex encoding for bytea #69640)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

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

[rafiss]

This could be related to #26128

[blathers-crl]

Hi @rafiss, please add a branch-* label to identify the earliest affected branch for this C-bug

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