Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 5.5.65, 10.4, 10.5, 10.6, 10.7
-
Component/s: Data Manipulation - Delete
-
Labels:None
-
Environment:CentOS 7
Description
MariaDB shares this same bug with MySQL: https://bugs.mysql.com/bug.php?id=82189
In a nutshell: When you do a delete query with table aliases but did not first type "use <database>", the command will fail with ERROR 1046 (3D000): No database selected.