# Technical Advisory 93314

Publication date: January 4, 2023

## Description

In CockroachDB v22.2.0 and v22.2.1, if a user-defined function (UDF) is created using any implicit record type which contains a column of user-defined `ENUM` type as the function’s parameter type or return type, the CockroachDB instance will crash and refuse to start. For example:

    CREATE TYPE e AS ENUM ('a', 'b');
    CREATE TABLE t (a INT, b e);
    CREATE OR REPLACE FUNCTION f () RETURNS t AS
    $$
      SELECT a, b
      FROM t
      ORDER BY a
      LIMIT 1;
    $$ LANGUAGE SQL; -- CockroachDB cluster crashes when this query is run

## Statement

This is resolved in CockroachDB by PR #94106 which fixes infinite recursion during the type hydration for catalog descriptors.

The fix has been applied to maintenance releases of CockroachDB v22.2.2 and later.

This public issue is tracked by #93314.

## Mitigation

Users of CockroachDB v22.2.0 and v22.2.1 should avoid creating a user-defined function (UDF) using any implicit record type that contains a field of user-defined `ENUM` type as the function’s parameter type or return type.

Users of CockroachDB v22.2.0 and v22.2.1 are encouraged to upgrade to version v22.2.2 or later.

## Impact

CockroachDB instances crash and refuse to start unless upgraded to v22.2.2 or a later version.

Please reach out to the support team if more information or assistance is needed.