Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Not a Bug
-
Affects Version/s: 10.2.36
-
Fix Version/s: N/A
-
Component/s: Scripts & Clients
-
Labels:None
-
Environment:Last login: Fri Dec 25 13:10:59 2020 from 94.31.96.126
root@localhost:~# uname -a
Linux localhost 4.15.0-99-generic #100-Ubuntu SMP Wed Apr 22 20:32:56 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
root@localhost:~#
Description
mysqldump dumps views as tables when there is only one view
dump create this:
/*!50001 CREATE TABLE `VIEW1` (
`id` tinyint NOT NULL,
`c` tinyint NOT NULL
) ENGINE=MyISAM */;
i have also test it on Windows Version 10.5.8 with the same error
In the attachment is the create, use and the mysqldump output.
Regards
Bernd