Implicit casting does not work for uuid[]

[martinjankoehler]

Describe the problem

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

• Create a Table with uuid[]
• Attempt to insert a row using an implicit casting literal for the uuid[] vector, the way it works on PostgreSQL
• I get a syntax error ERROR: value type string doesn't match type uuid[] of column "liste"

What did you do? Describe in your own words.

• Attempted to INSERT an uuid[] literal using https://www.cockroachlabs.com/docs/stable/array.html#implicit-casting

CREATE TABLE uuid_test (
    id bigint DEFAULT unique_rowid() PRIMARY KEY,
    liste uuid[]
);

-- BUG: this attempt fails (but works with PostgreSQL)
INSERT INTO "public"."uuid_test"("liste") VALUES('{a16d1e64-06d5-42d7-a899-dbad1b1f4150}') RETURNING "id", "liste";

-- NOTE: this attempt works
INSERT INTO "public"."uuid_test"("liste") VALUES(ARRAY['a16d1e64-06d5-42d7-a899-dbad1b1f4150']) RETURNING "id", "liste";

Environment:

• CockroachDB version [CCL v20.1.0]
• Server OS: [x86_64-unknown-linux-gnu, built 2020/05/05 00:07:18, go1.13.9]
• Client app [http://postico.app]

[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 have CC'd a few people who may be able to assist you:

• @rafiss (found keywords: postico)

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

[rafiss]

Thanks for the issue! This is a duplicate of #54672

We have fixed the issue for CockroachDB v20.2.x, but we will not be able to include this change in any v20.1 releases.