-
-
Notifications
You must be signed in to change notification settings - Fork 141
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
bug: ALTER table DROP primary key is forbidden #1034
Labels
Milestone
Comments
ACK |
Execution stack for alarm:(gdb) bt
#0 THD::send_statement_status (this=0x7f0c18006f20) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/sql/sql_class.cc:4799
#1 0x00000000023a6a1b in dispatch_command (thd=0x7f0c18006f20, com_data=0x7f0dfeabd730, command=COM_QUERY) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/sql/sql_parse.cc:1912
#2 0x00000000023a4445 in do_command (thd=0x7f0c18006f20) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/sql/sql_parse.cc:1034
#3 0x00000000024d5ad9 in handle_connection (arg=0x878fe70) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/sql/conn_handler/connection_handler_per_thread.cc:313
#4 0x0000000002ba2e22 in pfs_spawn_thread (arg=0x8169180) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/storage/perfschema/pfs.cc:2197
#5 0x00007f0e0946d1ca in start_thread () from /lib64/libpthread.so.0
#6 0x00007f0e067bfe73 in clone () from /lib64/libc.so.6
|
Self-test completed, repairablemysql> show create table t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)
mysql> alter table t1 drop primary key;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`id` int(11) NOT NULL
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)
|
14 tasks
Repository owner
moved this from Todo
to Done
in StoneDB for MySQL 5.7
Dec 2, 2022
Repository owner
moved this from Todo
to Done
in StoneDB for MySQL 8.0
Dec 2, 2022
Only one problem is handled at a time. This problem is about deleting the primary key. Other problems are not recorded in this ISSUE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Have you read the Contributing Guidelines on issues?
Please confirm if bug report does NOT exists already ?
Describe the problem
Expected behavior
How To Reproduce
Environment
Are you interested in submitting a PR to solve the problem?
The text was updated successfully, but these errors were encountered: