[MDEV-6268] SPIDER table with no COMMENT clause causes queries to wait forever - Jira

XML

Word

Printable

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.