MariaDB [test]> CREATE OR REPLACE TABLE user (
-> username VARCHAR(50) NOT NULL
-> , password VARCHAR(50) NOT NULL
-> ENGINE = SPIDER;
Query OK, 0 rows affected (0.12 sec)
MariaDB [test]> SELECT * FROM user;
I beleive that the table should not be created, since the COMMENT clause misses.
The query waits forever. Note that even KILL HARD, in some cases, does not kill the query/process.