Technical Advisory 93314

Publication date: January 4, 2023

Description

In CockroachDB and , 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 a fix that addresses infinite recursion during the type hydration for catalog descriptors. The fix has been applied to maintenance releases of CockroachDB and later.

Mitigation

Users of CockroachDB and 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.

​Description

​Statement

​Mitigation

​Impact

Description

Statement

Mitigation

Impact