SHOW CREATE TABLE returns incorrect statement

[FullDuplexFish]

Describe the problem

Please describe the issue you observed, and any steps we can take to reproduce it:

To Reproduce

CREATE TABLE t (c0 STRING COLLATE de DEFAULT '');                                           
root@127.0.0.1:26257/d0> show create table t;                                                                        
  table_name |                       create_statement
-------------+----------------------------------------------------------------
  t          | CREATE TABLE public.t (
             |     c0 STRING COLLATE de NULL DEFAULT '':::STRING COLLATE de,
             |     rowid INT8 NOT VISIBLE NOT NULL DEFAULT unique_rowid(),
             |     CONSTRAINT t_pkey PRIMARY KEY (rowid ASC)
             | ) WITH (schema_locked = true);
(1 row)
root@127.0.0.1:26257/d0> CREATE TABLE public.t (                                                                     
                      ->       c0 STRING COLLATE de NULL DEFAULT '':::STRING COLLATE de,                             
                      ->       rowid INT8 NOT VISIBLE NOT NULL DEFAULT unique_rowid(),                               
                      ->       CONSTRAINT t_pkey PRIMARY KEY (rowid ASC)                                             
                      ->   ) WITH (schema_locked = true);                                                            
ERROR: statement ignored: at or near ",": syntax error: multiple COLLATE declarations for column "c0"
SQLSTATE: 42601
DETAIL: source SQL:
CREATE TABLE public.t (
      c0 STRING COLLATE de NULL DEFAULT '':::STRING COLLATE de,
                                                              ^

Expected behavior
Creating second table successfully

Environment:

• CockroachDB version [CockroachDB CCL v26.3.0-alpha.00000000-dev-13cb3eb27674b4a981e5c526d04c2387e81efd0b (x86_64-pc-linux-gnu, built 2026/09/21 05:57:20, go1.26.2)]
• Server OS: [Ubuntu 24.04]
• Client app [cockroach sql]

Jira issue: CRDB-68652

[blathers-crl]

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

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I was unable to automatically find someone to ping.

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.}