Address feedback, change test with table engine option
@@ -19,14 +19,14 @@ DROP TABLE IF EXISTS t2;
-- prepare test databases for testing 'create table like' and 'as select' statements.
CREATE DATABASE db1;
CREATE DATABASE db2;
-CREATE TABLE db1.test1(a INT, b INT);
+CREATE TABLE db1.test1(a INT, b INT) ENGINE=memory;
INSERT INTO db1.test1 VALUES (1, 1), (2, 2), (3, 3);
-- test 'create table like' statement, expect db2.test2 has the same schema with db1.test1
-CREATE TABLE db2.test2 LIKE db1.test1;
+CREATE TABLE db2.test2 LIKE db1.test1 ENGINE=fuse;
INSERT INTO db2.test2 VALUES (3, 5);
SELECT a+b FROM db2.test2;
-- test 'create table as select' statement, expect db2.test3 has the data from db1.test1 with casting
-CREATE TABLE db2.test3(x Varchar, y Varchar) AS SELECT * FROM db1.test1;
+CREATE TABLE db2.test3(x Varchar, y Varchar) ENGINE=fuse AS SELECT * FROM db1.test1;
SELECT x FROM db2.test3;
-- clean up test databases
DROP DATABASE db1;
