CREATE SCHEMA... AUTHORIZATION is unsupported

[vy-ton]

In Postgres,

postgres=# create user andy;
CREATE ROLE
postgres=# CREATE SCHEMA AUTHORIZATION andy;
CREATE SCHEMA
postgres=# CREATE SCHEMA andy_schema AUTHORIZATION andy;
CREATE SCHEMA
postgres=# \dn
    List of schemas
    Name     |  Owner
-------------+----------
 andy        | andy
 andy_schema | andy
 public      | postgres
(3 rows)

In CockroachDB,

[email protected]:63916/vy> CREATE SCHEMA AUTHORIZATION andy;
invalid syntax: statement ignored: at or near "andy": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
CREATE SCHEMA AUTHORIZATION andy
                            ^
[email protected]:63916/vy> CREATE SCHEMA andy_schema AUTHORIZATION andy;
invalid syntax: statement ignored: at or near "authorization": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
CREATE SCHEMA andy_schema AUTHORIZATION andy
                          ^

We should at least return an unimplemented error

[blathers-crl]

Hi @vy-ton, please add a C-ategory label to your issue. Check out the label system docs.

While you're here, please consider adding an A- label to help keep our repository tidy.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}