sql: CREATE AS [SHOW <show_subcmd> <table>] job fails

[ecwall]

Setup

CREATE TABLE tbl (id int PRIMARY KEY);

Statements causing failing jobs

1. CREATE TABLE t AS SELECT * FROM [SHOW CREATE TABLE tbl];
2. CREATE TABLE t AS SELECT * FROM [SHOW INDEXES FROM tbl];
3. CREATE TABLE t AS SELECT * FROM [SHOW COLUMNS FROM tbl];
4. CREATE TABLE t AS SELECT * FROM [SHOW CONSTRAINTS FROM tbl];
5. CREATE TABLE t AS SELECT * FROM [SHOW PARTITIONS FROM TABLE tbl];
6. CREATE TABLE t AS SELECT * FROM [SHOW PARTITIONS FROM INDEX tbl@tbl_pkey];

Job Failure Error
Error message is slightly different for CREATE MATERIALIZED VIEW and for each statement, but all jobs fail with

relation "tbl" does not exist

Example for CREATE TABLE t AS SELECT * FROM [SHOW CREATE TABLE tbl];:

SELECT job_id, status, error, description 
FROM [SHOW JOBS] 
WHERE job_type IN ('SCHEMA CHANGE', 'NEW SCHEMA CHANGE')
AND status != 'succeeded';

880070398090477569, failed, relation "tbl" does not exist, CREATE TABLE defaultdb.public.t (table_name STRING, create_statement STRING) AS SELECT * FROM [SHOW CREATE tbl]

Jira issue: CRDB-29468

Epic CRDB-27601