Create table select from not supported

[jackysp]

Please answer these questions before submitting your issue. Thanks!

1. What did you do? If possible, provide a recipe for reproducing the error.

create table t1 (a int auto_increment not null primary key, B CHAR(20));
insert into t1 (b) values ("hello"),("my"),("world");
create table t2 (key (b)) select * from t1;

2. What did you expect to see?

Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

3. What did you see instead? ERROR 1105 (HY000): line 0 column 32 near " * from t1" (total length 42)

4. What version of TiDB are you using (tidb-server -V)?

[ghost]

Confirming this is still not supported in master:

mysql> create table t2 (key (b)) select * from t1;
ERROR 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet

mysql> select tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v4.0.0-beta.2-859-gccfc9b2ad
Edition: Community
Git Commit Hash: ccfc9b2ad0dcf8e447210de5f559d7fc208db968
Git Branch: master
UTC Build Time: 2020-07-29 09:37:45
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
1 row in set (0.00 sec)