Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

unquoted EXPORT for enum with same name as keyword #2923

Closed
c-meier opened this issue Jan 13, 2022 · 0 comments
Closed

unquoted EXPORT for enum with same name as keyword #2923

c-meier opened this issue Jan 13, 2022 · 0 comments
Assignees

Comments

@c-meier
Copy link

c-meier commented Jan 13, 2022

What happens?

When exporting an enum with the same name as a keyword, the enum name is not quoted.

To Reproduce

CREATE TYPE "group" AS ENUM ( 'one', 'two');
CREATE TABLE table1(col1 "group");
EXPORT DATABASE 'test_export' 

Which generates a test_export/schema.sql that can't be imported:

CREATE TYPE group AS ENUM ( 'one', 'two');
CREATE TABLE table1(col1 group);

Environment (please complete the following information):

  • OS: Archlinux
  • DuckDB Version: 0.3.1, 0.3.2.dev722, master:f1c8c7a
  • DuckDB Client: Python
@hawkfish hawkfish self-assigned this Feb 1, 2022
hawkfish pushed a commit to hawkfish/duckdb that referenced this issue Feb 1, 2022
Add appropriate quotes when exporting ENUM names.
Mytherin added a commit that referenced this issue Feb 2, 2022
@hawkfish hawkfish closed this as completed Feb 2, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants