Temporary tables are not dropped together with the database which contains them

USE test;

CREATE TEMPORARY TABLE tt (c INT);

INSERT INTO test.tt VALUES (1);

DROP DATABASE test;

CREATE DATABASE test;

USE test;

SELECT * FROM tt;

12.2.0-dbg>USE test;

Database changed

12.2.0-dbg>CREATE TEMPORARY TABLE tt (c INT);

Query OK, 0 rows affected (0.001 sec)

12.2.0-dbg>INSERT INTO test.tt VALUES (1);

Query OK, 1 row affected (0.000 sec)

12.2.0-dbg>DROP DATABASE test;

Query OK, 0 rows affected (0.006 sec)

12.2.0-dbg>CREATE DATABASE test;

Query OK, 1 row affected (0.000 sec)

12.2.0-dbg>USE test;

Database changed

12.2.0-dbg>SELECT * FROM tt;

+------+

| c    |

+------+

|    1 |

+------+

1 row in set (0.000 sec)