Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.3.7, 10.2, 10.3
-
Fix Version/s: 10.2.17
-
Component/s: Optimizer - CTE
-
Labels:None
-
Environment:Windows
Description
- Create a table `user`.`users` with a couple of columns.
- Execute, without having selected a database (through USE statement) the following query:
WITH
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.
Attachments
Issue Links
- causes
-
MDEV-26504 THD::copy_db_to() fails to return error if THD::db is null
-
- Closed
-
- relates to
-
MDEV-15120 CTE table should not belong to database, that is in use
-
- Closed
-
-
MDEV-22781 CREATE VIEW containing WITH clause Signal 11
-
- Closed
-