MySQL Bugs: #84193: Error dumping views

Bug #84193	Error dumping views
Submitted:	13 Dec 2016 20:52	Modified:	16 Dec 2016 6:29
Reporter:	Javier Polo	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.8	OS:	Windows (Microsoft Windows 10 Home Single Language)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
Hi,

I have had problems with exporting views using MySQL Workbench, when I export the views, all columns are exported with a value of 1 instead of being exported with the definition of the sql that corresponds to it, then an example of this

DROP TABLE IF EXISTS `myview`;
/*!50001 DROP VIEW IF EXISTS `myview`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `myview` AS SELECT 
 1 AS `oid`,
 1 AS `der_year`,
 1 AS `der_month`*/;
SET character_set_client = @saved_cs_client;

This happens with all the views in my database

Thanks by your support

JP

How to repeat:
1. Click in the "Management" tab
2. Click in "Data Export" option
3. Click in the data base and select all views(I tried with "Dump Structure Only" and "Dump Structure and Data")
5. Click in the "Export to Self-Contained File" option
6. Click in the "Start Export" button

Thank you for the bug report. Please try version 6.3.8, if the issue continues please provide a small test case with a sql script to create the table/view to export. Thanks.

Hello Javier Polo,

Thank you for your feedback.
Could you please provide us create table statements (please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

Hello Javier Polo,

Thank you for your feedback.
I could not repeat the issue at our end using with WB 6.3.8 while taking backup of views.
Create view statement is created in dump file after this comment "Final view structure for view".

Thanks,
Chiranjeevi.

output dump file

Attachment: test_routines.sql (application/octet-stream, text), 2.84 KiB.

Hi Chiranjeevi

Thanks by your support

Now I realize that the structure of the view is commented under the structure:

-
- Final view structure for view `view_test`
-

Note that when importing the dump as this view is badly imported. I would not have any problem copying the views of the comments, but my base weighs 1.7GB and I have around 100 views, so this complicates my situation.

Please, let me know if there is any way to solve this problem

Thank you.

Hello Javier Polo,

Thank you for your feedback.
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.
Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/
Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.