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