Implicit type casting between enum and string

[Defman]

Describe the problem

Implicit casting between enum types and primitives/strings.

To Reproduce

CREATE TYPE FOO AS ENUM ('1', '2');
SELECT ARRAY['1'] = ARRAY['1'::FOO]::FOO[];
SELECT '1' = ANY(ARRAY['1'::FOO]::FOO[]);

Expected behavior
That the string '1' is implicitly casted to the enum type.

Jira issue: CRDB-16895

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

[rimadeodhar]

Implicit type casting is not fully supported within CockroachDB at the moment and is being tracked in this parent issue #75101. In the meantime, the workaround is to explicitly cast a type.

I'm closing this issue as a duplicate.