Skip to content

Dropping schema with double quote in name fails #9459

@Alex-Monahan

Description

@Alex-Monahan

What happens?

Howdy folks!

If you are (like me) so unwise as to create a cursed-name schema like "blah, then it can only be destroyed if you throw the entire database into the fires of Mt. Doom. (The drop schema command fails.). On the MotherDuck side, you can run a drop database <database_with_cursed_schema> command as an alternative.

To Reproduce

create schema """cursed_schema";
drop schema """cursed_schema";

Error: Parser Error: Unterminated quote in qualified name!

OS:

MacOS

DuckDB Version:

0.9.2-dev115, 0.9.1, 0.8.1

DuckDB Client:

CLI

Full Name:

Alex Monahan

Affiliation:

MotherDuck and DuckDB Labs

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