- Create a table `user`.`users` with a couple of columns.
- Execute, without having selected a database (through USE statement) the following query:
abc AS (SELECT * FROM user.users)
SELECT * FROM abc
- Now you will get the error '1046 No database selected'.
On MySQL you don't get this error so I guess it only happens on MariaDB.