Unable to rename database due to views.

[Defman]

Describe the problem

Cannot rename database do to views.

To Reproduce

CREATE VIEW issue AS SELECT 1;
ALTER DATABASE foo RENAME TO bar;

Expected behavior
I expect the database to be renamed without issue.

Jira issue: CRDB-18231

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-schema (found keywords: ALTER DATABASE)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

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

[postamar]

I can't repro this, it works on master, so it appears that this has been fixed at some point. Please feel free to re-open in case I missed something.

[ajwerner]

This is probably #10083. This is unfortunately expected. We hope to address this in a future release (though not the proximate release, 22.2).