What happens?

When getting the type of an ENUM from a table, it will return the name of the enum (UDT) and not 'ENUM'. Which is problematic when integrating with SQLAlchemy.

To Reproduce

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');

CREATE TABLE T (mood_2 mood)

DESCRIBE T
----
[('mood_2', 'mood', 'YES', None, None, None)]

expected:
[('mood_2', 'ENUM', 'YES', None, None, None)]

OS:

mac os

DuckDB Version:

5.0.1

DuckDB Client:

Python

Full Name:

Pedro

Affiliation:

DuckDB

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree