Skip to content

Error happened when open a view in DBeaver  #4777

@pengxiangyu

Description

@pengxiangyu

Describe the bug
When you are operating doris using DBeaver, an error happens when you are opening a view.
You can't see the description information for a view in DBeaver.
This operation need to call SELECT CHECK_OPTION,DEFINER,IS_UPDATABLE FROM information_schema.VIEWS
information_schema.VIEWS doesn't exist, so it will get an error.

To Reproduce
Steps to reproduce the behavior:

  1. Download DBeaver on version 6.0.0
  2. Create a view
  3. Open the view in DBeaver
  4. You can see the error and can't get the description of the view.

Expected behavior
I want to see the description of the view.

Additional context
a new table names views is needed in database information_schema, which has the same schema as views in mysql.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions