bug: create temporary..select...from,Syntax not supported

[shangyanwen]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

CREATE TEMPORARY TABLE Temp1 SELECT * from t1;

ERROR 6 (HY000): The query includes syntax that is not supported by the storage engine. Either restructure the query with supported syntax, or enable the MySQL core::Query Path in config file to execute the query with reduced performance.

Expected behavior

Syntax support, can be created successfully

How To Reproduce

CREATE TABLE t1 (c1 INT)engine=tianmu;
INSERT INTO  t1 VALUES(1);
CREATE TEMPORARY TABLE Temp1 SELECT * from t1;
SELECT * FROM Temp1;

Environment

./mysqld Ver 5.7.36_v1.0.1_beta-StoneDB for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: https://github.com/stoneatom/stonedb/commit/208f79d80bae1667d147e0713950317c9ca6c6b9
Last commit time: Date: Sat Sep 17 16:19:42 2022 +0800
Build time: Date: Sat Sep 17 17:59:04 CST 2022

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[duanfuxiang0]

now tianmu not support insert_select; turn on tianmu_ini_allowmysqlquerypath=1 in my.cnf, use mysql query handler; problem can be solved

[shangyanwen]

Verification by