sql: CREATE AS [SHOW CREATE FUNCTION] job fails

[ecwall]

Running

CREATE FUNCTION fn(i int) RETURNS INT AS 'SELECT i' LANGUAGE SQL;
CREATE TABLE t AS SELECT * FROM [SHOW CREATE FUNCTION fn];

or

CREATE FUNCTION fn(i int) RETURNS INT AS 'SELECT i' LANGUAGE SQL;
CREATE MATERIALIZED VIEW v AS SELECT * FROM [SHOW CREATE FUNCTION fn];

results in a job failure (error message is slightly different for CREATE MATERIALIZED VIEW):

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

880081200324935681, failed, unknown function: fn(): function undefined, CREATE TABLE defaultdb.public.t (function_name STRING, create_statement STRING) AS SELECT * FROM [SHOW CREATE FUNCTION fn]

Jira issue: CRDB-29473

Epic CRDB-27601