Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.24
-
None
-
CentOS 7 Source build
Description
Documentation at https://mariadb.com/kb/en/innodb-online-ddl-operations-with-the-instant-alter-algorithm/#alter-table-drop-index-and-drop-index states that 10.4 supports DROP INDEX ..., ALGORITHM=INSTANT, but it does not.
This is what I get when I run the example from that URL:
MariaDB [(none)]> \s
|
--------------
|
./bin/mysql Ver 15.1 Distrib 10.4.24-MariaDB, for Linux (x86_64) using readline 5.1
|
|
Connection id: 8
|
Current database:
|
Current user: bdempsey@localhost
|
SSL: Cipher in use is DHE-RSA-AES256-GCM-SHA384
|
Current pager: stdout
|
Using outfile: ''
|
Using delimiter: ;
|
Server: MariaDB
|
Server version: 10.4.24-MariaDB-debug Source distribution
|
Protocol version: 10
|
Connection: Localhost via UNIX socket
|
Server characterset: latin1
|
Db characterset: latin1
|
Client characterset: utf8
|
Conn. characterset: utf8
|
UNIX socket: /home/bdempsey/mariadb/10.2/data/mysql.sock
|
Uptime: 1 min 8 sec
|
|
Threads: 6 Questions: 4 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 10 Queries per second avg: 0.058
|
--------------
|
|
MariaDB [foo]> CREATE OR REPLACE TABLE tab (
|
-> a int PRIMARY KEY,
|
-> b varchar(50),
|
-> c varchar(50),
|
-> INDEX b_index (b)
|
-> );
|
Query OK, 0 rows affected (0.053 sec)
|
|
MariaDB [foo]> SET SESSION alter_algorithm='INSTANT';
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [foo]> ALTER TABLE tab DROP INDEX b_index;
|
ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: DROP INDEX. Try ALGORITHM=NOCOPY
|
Attachments
Issue Links
- relates to
-
MDEV-13134 Introduce ALTER TABLE attributes ALGORITHM=NOCOPY and ALGORITHM=INSTANT
- Closed
- mentioned in
-
Page Loading...