[MDEV-24490] mysqldump generate "create Table" by Views Created: 2020-12-25  Updated: 2020-12-27  Resolved: 2020-12-27

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.2.36
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Bernd Buffen Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
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:~#

Attachments: Text File dumpview.txt    

 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

 Comments   
Comment by Sergei Golubchik [ 2020-12-27 ]

Expected behavior. See below under the create table you'll find drop table if exists and create view.

Generated at Thu Feb 08 09:30:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.