sql: calling EXECUTE in PL/pgSQL should return more helpful error

[rytaft]

When I run the following on 24.1:

CREATE TABLE mytable (inserted_by TEXT, inserted TIMESTAMP);
CREATE TABLE c (checked_user TEXT, checked_date TIMESTAMP);

CREATE PROCEDURE test(checked_user TEXT, checked_date TIMESTAMP)
AS $$
DECLARE
  c INT;
BEGIN
  EXECUTE 'SELECT count(*) FROM mytable WHERE inserted_by = $1 AND inserted <= $2'
    INTO c
    USING checked_user, checked_date;
END;
$$ LANGUAGE plpgsql;

CALL test('blah', now()::timestamp);

I get the error:

ERROR: unimplemented: attempted to use a PL/pgSQL statement that is not yet supported
SQLSTATE: 0A000
HINT: You have attempted to use a feature that is not yet implemented.

Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.

If you would rather not post publicly, please contact us directly
using the support form.

We appreciate your feedback.

It's not clear exactly which statement is unsupported. Ideally this error would specify the EXECUTE command and reference the dynamic SQL issue: #115300

Jira issue: CRDB-38463

[michae2]

Same error when creating a SP like the following:

CREATE TABLE t6 (a int);

CREATE PROCEDURE p6(IN i int)
LANGUAGE plpgsql
AS $$
BEGIN
  INSERT INTO t6 VALUES (i);
  CASE i
    WHEN 6 THEN
      COMMIT;
    WHEN 7 THEN
      ROLLBACK;
    WHEN 8 THEN
      COMMIT;
    ELSE
      ROLLBACK;
  END CASE;
END;
$$;

It would help to point out the statement (and maybe even the line number?) that is unsupported.