Stored procedure: temp table created in procedure not visible

[zachmu]

Temporary tables created during stored procedure execution are not visible in the session in later statements.

Repro:

DROP PROCEDURE IF EXISTS CreateTemporaryTable;
DELIMITER //
CREATE PROCEDURE CreateTemporaryTable()
BEGIN
  DROP TEMPORARY TABLE IF EXISTS TEMP_TABLE;
  CREATE TEMPORARY TABLE TEMP_TABLE (NAME TEXT);
  INSERT INTO TEMP_TABLE VALUES ('A'),('B');

  SELECT * FROM TEMP_TABLE;
END //
DELIMITER ;

CALL CreateTemporaryTable();

Related bug: DROP TEMPORARY TABLE does not parse correctly.

[jycor]

Did some digging.

While it is true that both temporary and durable tables are not visible within the procedure body, we don't actually support creating temporary or durable tables within procedures. The insert and select statements just trigger an error before we validate the stored procedure.

I will move some analyzer rules around to return the more appropriate error