Describe the problem

Consider the following test:

CREATE DATABASE db;
USE db;
CREATE SCHEMA sc;
BEGIN;
    CREATE SCHEMA sc2;
    SELECT * FROM crdb_internal.tables;
    DROP SCHEMA sc CASCADE;
COMMIT;

This now fails, and it was broken in #87067

Additional context
This was discovered while investigating #78478.

Jira issue: CRDB-19466