CREATE TYPE IF NOT EXISTS

[DiptenduIDEAS]

What happens?

connection.execute("CREATE TYPE IF NOT EXISTS M_or_D AS ENUM ('MEASURE', 'DIMENSION')")

leads to following error

duckdb.duckdb.ParserException: Parser Error: syntax error at or near "NOT"

To Reproduce

CREATE TYPE M_or_D AS ENUM ('MEASURE', 'DIMENSION');

OS:

Windows

DuckDB Version:

duckdb==0.10.1

DuckDB Client:

Python

Full Name:

Diptendu Dutta

Affiliation:

IDEAS TIH

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have

[soerenwolfers]

Is this a feature request or did you expect this already works (if the latter, is there any documentation that implies it works?)

[DiptenduIDEAS]

On checking the documentation ( https://duckdb.org/docs/sql/statements/create_type.html) I see that this is not supported. So may this be please considered as a feature request.

…

On Sun, 28 Apr 2024 at 14:04, Soeren Wolfers ***@***.***> wrote: Is this a feature request or did you expect this already works (if the latter, is there any documentation that implies it works?) — Reply to this email directly, view it on GitHub <#11844 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BFJKT3YZAQ7RZ3BQ5VWYT6DY7SYCXAVCNFSM6AAAAABG2P5CS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOBRGM4TCOJZGI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Crypto-Spartan]

+1 for a feature request on this