Skip to content

SELECT and DROP statement with enums doesn't work with db scoping #9593

@k-anshul

Description

@k-anshul

What happens?

SELECT and DROP enums doesn't work with db scoping

To Reproduce

ATTACH ':memory:' as db;
CREATE TYPE db.mood AS ENUM ('sad', 'ok', 'happy');
drop type db.mood;

Error: Parser Error: syntax error at or near "."
LINE 1: drop type "db".mood;

SELECT enum_range(NULL::db.mood) AS my_enum_range;

Error: Parser Error: syntax error at or near "."
LINE 1: SELECT enum_range(NULL::db.mood) AS my_enum_range;

OS:

macOS

DuckDB Version:

0.9.1

DuckDB Client:

CLI

Full Name:

Anshul Khandelwal

Affiliation:

RillData

Have you tried this on the latest main branch?

I have tested with a main build

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

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions