support querying temporary tables with cross engine joins

MariaDB [test]> select * from c1;

+------+

| i    |

+------+

|    1 |

|    1 |

+------+

2 rows in set, 1 warning (0.016 sec)

MariaDB [test]> show create table c1;

+-------+------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                           |

+-------+------------------------------------------------------------------------------------------------------------------------+

| c1    | CREATE TABLE `c1` (

  `i` int(11) DEFAULT NULL

) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |

+-------+------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)

MariaDB [test]> create temporary table tmp (i int);

Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> select c1.*, tmp.* from test.c1 join test.tmp on c1.i = tmp.i;

ERROR 1815 (HY000): Internal error: CrossEngineStep::execute() fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'test.tmp' doesn't exist)

MariaDB [test]> insert into test.tmp values (1);

Query OK, 1 row affected (0.000 sec)

MariaDB [test]> insert into test.inno values (1);

Query OK, 1 row affected (0.001 sec)

MariaDB [test]> select c1.*, inno.* from test.c1 join test.inno on c1.i = inno.i;

+------+---+

| i    | i |

+------+---+

|    1 | 1 |

|    1 | 1 |

+------+---+

2 rows in set, 1 warning (0.030 sec)