Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create table select from not supported #3839

Closed
jackysp opened this issue Jul 20, 2017 · 1 comment
Closed

Create table select from not supported #3839

jackysp opened this issue Jul 20, 2017 · 1 comment
Labels
feature/accepted This feature request is accepted by product managers type/compatibility type/enhancement The issue or PR belongs to an enhancement. type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@jackysp
Copy link
Member

jackysp commented Jul 20, 2017

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;
  1. What did you expect to see?
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0
  1. What did you see instead?
    ERROR 1105 (HY000): line 0 column 32 near " * from t1" (total length 42)

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

bb7133 added a commit to bb7133/tidb that referenced this issue Sep 28, 2018
@morgo morgo added type/compatibility type/enhancement The issue or PR belongs to an enhancement. labels Oct 28, 2018
bb7133 added a commit to bb7133/tidb that referenced this issue Nov 30, 2018
bb7133 added a commit to bb7133/tidb that referenced this issue Dec 6, 2018
bb7133 added a commit to bb7133/tidb that referenced this issue Dec 24, 2018
bb7133 added a commit to bb7133/tidb that referenced this issue Jan 17, 2019
@ghost
Copy link

ghost commented Jul 30, 2020

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)

@zz-jason zz-jason added the type/feature-request Categorizes issue or PR as related to a new feature. label Jul 31, 2020
@zz-jason zz-jason added the feature/accepted This feature request is accepted by product managers label Jul 31, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature/accepted This feature request is accepted by product managers type/compatibility type/enhancement The issue or PR belongs to an enhancement. type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
4 participants