Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
An error occurs when joining a Columnstore table and an InnoDB temporary table.
[HY000][1815] (conn=1014) Internal error: CrossEngineStep::execute() fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'b' doesn't exist)
|
|
|
|
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) |
It was already requested 7 years ago, was closed last year without any reason.
There was some architecure changes since 2017, so it makes sense to evualate again.