MySQL Bugs: #51029: Inserts don't show in Mac OS X MySQL Workbench

Bug #51029	Inserts don't show in Mac OS X MySQL Workbench
Submitted:	9 Feb 2010 15:36	Modified:	27 May 2010 16:31
Reporter:	Michael Beaucourt	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.15b	OS:	Other (Linux/OS X)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
If you add inserts in the insert tab of a Model and save the file, those insert do NOT display in MySQL Workbench for Mac OS X. The information in the inserts tab simply disappears.

How to repeat:
Create a model in windows. Add a table and add some records in the 'Inserts' tab. Save the file and open the file in MySQL Workbench for Mac OS X (5.2.15b). The information in the inserts tab is gone.

you need to "commit" your changes to the insert data using the green checkmark.
we'll add some safety feature that alerts the user when saving with pending changes in inserts editor

I'm am 100% sure i committed, because when I open the file in Windows again, the inserts are still there. Opening it in Mac OS X Workbench, the inserts are completely empty!

I can support Michael in this report.

At my workplace I work on a Windows 7 machine while at home I have a MacBook at home. Both computers have 5.2.15 Beta 5 installed and the .mwb file is "shared" between those two machines via a SVN repository. Inserts I define for tables on my windows machine are lost once opened on my Mac they are no where to be found.

I'm one hundred percent sure that, on my windows machine, the inserts are committed, since I've been making use of them numerous times during today.

Best regards
Christian Rasmussen

Hi

Can you attach one of those files where you are able to view the previously saved INSERTs in Windows, but not in Mac?

Christian:
Thanks for the fast response. Could you tell what table presents the problem?

No problem :)

I beleive I'm experiencing it with all tables I've tried defining some default inserts for - for testing purposes.

But if I am to mention one specific table I'm 100% certain I'm experiencing the problem with it's 'users_information'

By the way, if you want some system output from any of my machine, please let me know.

--
Christian

Marked bug #52053 duplicate of this

libzip stores platform dependent file paths within archive, but '\' is a valid symbol for file name on linux. That leads to wrong directory tree and file names restored from zlib archives packed on windows and then unpacked on linux or mac osx.
Described problem is the real cause of why table inserts from windows model files can't be seen in linux/mac osx.

Added code to fix models with this problem on load.

Fixed load in windows

fix confirmed inrepository

An entry has been added to the 5.2.22 changelog:

Inserts added to a model and saved on Windows were not visible when that model was loaded on Mac OS X.