View couldn't be changed or deleted

[uslss]

System information:

• Operating system (distribution) and version win10 x64
• DBeaver version 7.1.3

Connection specification:

• Database name and version Clickhouse

Describe the problem you're observing:

Error appears when trying to change or delete view.

View changing:

Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

SQL Error [57]: ClickHouse exception, code: 57, host: 127.0.0.1, port: 40127; Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

  ClickHouse exception, code: 57, host: 127.0.0.1, port: 40127; Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

  ClickHouse exception, code: 57, host: 127.0.0.1, port: 40127; Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

    java.lang.Throwable: Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

    Code: 57, e.displayText() = DB::Exception: Table default.NewView already exists., e.what() = DB::Exception

Delete view

Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

SQL Error [62]: ClickHouse exception, code: 62, host: 127.0.0.1, port: 40127; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

  ClickHouse exception, code: 62, host: 127.0.0.1, port: 40127; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

  ClickHouse exception, code: 62, host: 127.0.0.1, port: 40127; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

    java.lang.Throwable: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

    Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 6: VIEW default.NewView. Expected one of: DATABASE, TEMPORARY, TABLE, e.what() = DB::Exception

[serge-rider]

View delete fixed. View alter is not supported by current Clickhouse version (ClickHouse/ClickHouse#1226)

[uslss]

verified