It is not possible to work with a local temporary table in an uncommitted transaction in the new shared metadata cache mode

```sql
SET AUTODDL OFF;

CREATE LOCAL TEMPORARY TABLE T1 (ID INT) ON COMMIT PRESERVE ROWS;

SELECT COUNT(*) FROM MON$LOCAL_TEMPORARY_TABLES;
/*
                COUNT
=====================
                    1
*/

SELECT * FROM T1;
/*
Statement failed, SQLSTATE = 42S02
table "PUBLIC"."T1" is not defined
*/
```