MySQL Workbench Releases
This page gives detailed information about each release.
MySQL Workbench 5.2.8 (2009-11-18)
Platform: mac, linux, windows
[new/improved]
- all new home screen which servers as central landing page where you can launch the different tasks workbench can perform now
- Administration module fully available
- new database overview in query mode
[closed]
- Bug #13006 the creation order of views cannot be controlled
- Bug #23002 In proc. comments dropped by mysqldump
- Bug #26863 Cannot add fields to SELECT and WHERE from LEFT OUTER JOIN’ed table
- Bug #29808 Enabling “Preload Buffer Size” causes Server crashing after reboot
- Bug #31667 Error while restoring schema/table/view with a parentheses “(” in the name.
- Bug #38807 schema default collation is not correctly applied on contained tables
- Bug #40060 Index name too long
- Bug #41460 MySql Workbench SE Fails with Windows Vista
- Bug #42626 Cut, Copy & Paste Should Not Translate To the Main Document
- Bug #43276 Schemata qualifiers always generated for Stored Procedures
- Bug #43455 table layout messed on loading diagram file
- Bug #44813 Workbench:requestFileSave in plugin sets document’s unsaved state
- Bug #45264 Setting column field “NN” multiple times affects “Column Details”
- Bug #45705 Checkbox state abandonment in Foreign Keys tab
- Bug #45881 Filter prevents from reversing only one table
- Bug #45896 Automatic scrolling in the editor procedures and triggers
- Bug #45929 Trigger editor – auto delimiter is very ennoying
- Bug #46510 workbench setting primary key in error
- Bug #46624 In Inserts truncate chars in strings after space.
- Bug #46878 Errors managing default values for columns
- Bug #46894 Text editor for VIEWs is too aggressive in trimming excessive whitespace
- Bug #46970 Navigator in EER Diagram doesn’t show anything
- Bug #47085 Can’t remove default value of a column
- Bug #47100 Insert values for datatype BIT are dropped
- Bug #47102 Table’s tooltip shows info about a column
- Bug #47238 Can’t add a DB connection – couldn’t load library libmysqlclient_r.so
- Bug #47468 Workbench Export sql script deletes schema whene exists.
- Bug #47491 Crash when opening/creating a new model with an unsaved model active
- Bug #47503 GRT Shell “help” with no parameters crash
- Bug #47545 Cannot re-open an EER diagram after closing it
- Bug #47807 Relationship diagram isn’t redrawn when FK table reference is changed
- Bug #48129 Table editor is missing Tool Tip for AI column
- Bug #48156 Unable to export result set to CSV
- Bug #48202 Use compression protocol option will not turn off
- Bug #48345 Workbench overwrites existing projects on saving without warning
- Bug #48347 Crash on managing new server instances
- Bug #48389 Cannot start Workbench 5.2.6-alpha on Windows 32-bit
- Bug #48507 Managing connection in MySQL Workbench
- Bug #48520 cairo error: out of memory
MySQL Workbench 5.2.7 (internal release)
Platform: mac, linux, windows
MySQL Workbench 5.2.6 (2009-10-21)
Platform: mac, linux, windows
[new/improved]
- added remote Server-Administration (mac and linux, windows version yet local admin only)
- added user-account-management, log viewer (for use with log-tables option)
- improved startup scripts
[closed]
- Bug #33005 “Move Up” / “Move Down”
- Bug #42919 support functionality of query browser in Workbench
- Bug #45579 copyToClipboard produces excess newlines
- Bug #46467 Fixing the catalog/model changed column types
- Bug #46613 Can’t delete a field in the MySQL Table Editor
- Bug #47044 Unhandled Exception When Expanding Schemata List
- Bug #47534 Workbench always crashes on startup
- Bug #47565 Workbench crashes when connect to columns is selected
- Bug #47958 Error when closing window
MySQL Workbench 5.2.5 (internal build)
Platform: mac, linux, windows
MySQL Workbench 5.2.4 (2009-10-07)
Platform: mac, linux, windows
[new/improved]
- added Server-Administration-Interface
- added TCP over SSH as connection method
- fixed issues in query interface
- new icons
[closed]
- Bug #46285 REDO wrong accelerator
- Bug #47088 Routines are not listed in Workbench’s Query Browser
- Bug #47385 Layer names not rendered on screen
- Bug #47405 Impossible to properly view/edit DECIMAL column values in query result set
- Bug #47407 Sql error in CREATE on synchronize model
MySQL Workbench 5.2.3 (2009-09-16)
Platform: mac, linux, windows
[improved]
- changed behaviour to not create new document on startup
- improved querying unit
- added compatibility with MacOS 10.6
[closed]
- Bug #36226 Create picture size of model diagram dynamically from diagram
- Bug #38906 illegal/no quoting in Insert Editor
- Bug #41636 Straight vertical or horizontal relationship not clickable
- Bug #44368 Invalid default value for ENUM fields
- Bug #44704 Inserting values separated with space doesn’t work on tables INSERT tab
- Bug #45069 UML Relationship notation displays incorrect values
- Bug #45075 Segmentation fault when creating second table and editing columns
- Bug #45123 MySQL Workbench crashes on timeout session
- Bug #45260 Can’t assign columns to index
- Bug #45692 Program crashes when deleting a table off the diagram designer. MAC OS X
- Bug #45704 Stored procedures code missing from Workbench editor
- Bug #46065 Crash when select a MySQL Connection
- Bug #46993 MySQL Workbench crashes on launch on OS X 10.6 Snow Leopard GM.
- Bug #47122 The NULL value in INSERT statements is quoted
- Bug #47174 Selecting ‘NOT NULL’ when adding a new column causes crash
- Bug #47257 Cancel and Replace are switched
- Bug #47268 On creating foreign keys, selecting referenced column doesnt work
MySQL Workbench 5.1.18 (2009-09-03)
Platform: mac, linux, windows
[improved]
- re-arranged and optimized Table-Columns-Editor
- further improved DBDoc-Reports (SE version only)
- Mac version also runs on Snow Leopard (OSX 10.6)
[fixed]
- Bug #39735 Missing horizontal scrollbar in “Pysical Schemata”
- Bug #40601 editor: change order in lists per drag&drop
- Bug #41589 DBDoc and lack of support for stored routines, views, triggers
- Bug #45936 The Workbench won’t allow to modify custom user types.
- Bug #46302 Underscores in object names parsed as accelerators in context menus
- Bug #46304 Unhandled glibmm exception results in forced exit
- Bug #46363 Foreign key name collision – two foreign keys with the same name
- Bug #46579 Columns editor is user unfriendly on Linux
- Bug #46740 Model/DB Synchronization fails, creates new Schema ‘N/A’
- Bug #46752 Wrong storage engine used
- Bug #46783 Workbench autoticks the “Skip Creation of FOREIGN KEYS” checkbox
- Bug #46787 Forward Engineer for SQL CREATE does not work
- Bug #46789 Line Break issues
- Bug #46829 The escape key does not close preferences dialogs
- Bug #46847 auto completion completes too much
- Bug #46869 icons not changing in diagram
- Bug #46875 foreign key generation not working
- Bug #46937 Right click on the last row (table column) in columns tab crashes the app
- Bug #46940 Changing datatype doesn’t update diagram (but tooltips gets updated)
- Bug #46953 MySQL Workbench crashes on load on MacOSX 10.6 10A432
MySQL Workbench 5.1.17 (2009-08-14)
Platform: mac, linux, windows
[improved]
- more options for saving DBDoc-Reports (SE version only)
[fixed]
- Bug #32813 Help menue should also have a ‘List Reported Bugs’ item.
- Bug #34827 Skipping schema name when creating SQL script
- Bug #35180 No constraints checks during the generated script
- Bug #39511 Can’t rename a foreign key (by renaming index)
- Bug #39610 Version string sould be Clipboard-friendly in about box
- Bug #39887 Text Object doesn’t auto re-size
- Bug #40627 Relationship Notation: Connect to Columns shows wrong referenced line
- Bug #40641 Drag&drop of clumns in columns editor drops column n+1 positions
- Bug #41219 Inbound syncronize does not update the model.
- Bug #41290 Database Synchronisation of datatype double failure
- Bug #41453 Changes in the flags of User Types are not made in columns of tables.
- Bug #41887 Foreign Key Options – incorrect values for each selected constraint
- Bug #42476 Select correct column when is ordered by mouse drag
- Bug #43061 Views Not Exported Correctly
- Bug #43345 Column creation allows a column name with trailing spaces
- Bug #43352 Collation for ENUM type not possible
- Bug #44317 Fwd. Engineer “Filter Objects” duplicated when going back and forward
- Bug #44454 Workbench opens every ER diagram in a model
- Bug #44458 INSERTS Editor does not allow deletes
- Bug #45393 Default referential integrity constraints not set for new tables
- Bug #45456 Synchronize Model is destructive when updating model
- Bug #45472 Cannot Resize Text Object in MySQL Workbench on Mac
- Bug #45515 MySQL Workbench Source RPM not rebuildable
- Bug #45583 Relationship Notation is not always shown
- Bug #45629 PowerPC build
- Bug #45773 Workbench Lost Objects + Crash
- Bug #45798 Build failed with gcc 4.4.0 – boost version is too old
- Bug #45830 Forward Engineer SQL ALTER Script… recreates unmodified unique indexes
- Bug #45861 Can’t change the page setup
- Bug #45867 Synchronize model. Error when sync only stored proc
- Bug #45869 MySQL Workbench crashes on startup
- Bug #45920 Workbench fails to create inserts in the DDL for certain tables
- Bug #45931 Trigger editor useless on copy/paste between tables
- Bug #45939 Typo in Synchronize Model with Database Wizard
- Bug #45943 dont save shema collation attribute
- Bug #45997 Indexes hints are wrong
- Bug #46025 Workbench crashes on Forward Engineer SQL CREATE Script
- Bug #46049 Unable to code stored procedures (Routines)
- Bug #46078 Seg fault on connection
- Bug #46092 Text in a “Text Note” item is validated as sql code
- Bug #46101 Workbench leaks GDI objects, resulting in massive performance drops
- Bug #46150 Workbench crashes when checking AI box
- Bug #46185 Reverse engineer from DBMS fails if SQL_MODE set to ANSI_QUOTES
- Bug #46246 script name reverts to ’script’ using the apply button
- Bug #46255 Text is cut off on Preferences dialog box
- Bug #46280 Choosing “give a prefix to all tables” crashes workbench
- Bug #46292 OverviewBE::get_node: invalid node 1.1
- Bug #46346 synchronize – deletes store procedures from source
- Bug #46349 Trigger ddl disappear when I write it
- Bug #46390 Inserts doesn’t show input field for TEXT datatypes
- Bug #46466 Double-click policy for tables, relationships and layers, text boxes different
- Bug #46477 error on dumpColumns plugin
- Bug #46509 Workbench column defaults cannot be removed
- Bug #46562 Unknown exception caught after placing relationship between two tables
- Bug #46605 Undo after AutoSize results in tiny boxes (ERR digram)
- Bug #46635 Impossible to connect to any MySQL DB Server.
MySQL Workbench 5.2.2 (2009-07-27)
Platform: mac, linux, windows
[fixed]
- Bug #40356 Accidentally Losing Table Inserts
- Bug #44669 Some character are not escaped in INSERT statements
- Bug #44906 Missing return statements
- Bug #45051 Limit 0, 1000 is added to all queries (but hidden)
- Bug #45204 Workbench crash
- Bug #45325 Workbench crashes when checking AI box
- Bug #45439 Constant segmentation faults
- Bug #45480 Cannot set primary key or change index name.
MySQL Workbench 5.1.16 (2009-06-30)
Platform: mac, linux, windows
[fixed]
- Bug #34069 Cannot edit relationship in a new window
- Bug #34919 Untruncated enum values in table can lead to ultra-wide rectangle
- Bug #34938 Double clicking a layer in the “Layers” palette doesn’t select it
- Bug #37273 Change order index
- Bug #38198 Font size is not changed in diagram
- Bug #38654 renaming table causes insert statements to be lost
- Bug #39624 Edit Relationships always opens new tab
- Bug #42149 Synchronization nearly unusable
- Bug #45490 Right-clicking in the User Types window in blank space creates exception
- Bug #45491 Can’t open the mwb file that create and edit by workbench v5.0 in XP
- Bug #45590 Unable to change column ordering for tables
- Bug #45594 Right click context menu missing for all Schema elements
- Bug #45607 datatype ENUM does not accept parenthesis in values
- Bug #42794 Wrong icons displayed on columns depend nullable attribute
- Bug #43837 Latest “Forward Engineer Create SQL” page no longer saves output dir
- Bug #44264 timer fires and adds delimiter when typing trigger code on mac
- Bug #44462 Menu item names wrong
- Bug #45626 Can’t Delete Indexes in Table Editor
- Bug #45718 Segmentation fault on Export / Forward Engineer
- Bug #45821 “Unknown Exception caught” message when creating a table
[other fixes]
- fixed stability issue with undo/redo
- unified behaviour of sidebar-panes for different platform versions
- corrected mis-aligned header texts in wizards
MySQL Workbench 5.1.15 RC3 (2009-06-26)
Platform: mac, linux, windows
[fixed (with associated bug reports)]
- Bug #44298 Context-menus not available in the right pane (catalog, history, etc)
- Bug #45529 PK/unsigned box vanishes 2 seconds after selecting column in Edit Table
- Bug #45619 Overwrite existing file dialog – replace/cancel buttons are reversed
- Bug #45623 Impossible to select tables to export in Forward Engineer SQL Script window
- Bug #45642 Generated INSERT statements don’t have database name
- Bug #45652 When I run Generate Catalog Diff Report, application craches
[other fixes]
- Bug fix: copy/paste of tables, relationship creation
- Bug fix: object copy code was incomplete
- Improvement: multi selection support for items in dialog lists
- Bug fix: added missing undo items for routines in routine groups.
- Bug fix: History tree context menu fixed (Linux)
- Bug fix: odd undo action related to parsing when opening an object editor
- Bug fix: overview context menu works now with multiple selection
- Improvement: support for adding routines to routine groups via drag’n drop
- Bug fix: crash when deleting items from overview
- Bug fix: paste on selection
- Bug fix: table flags display on diagram page
- Improvement: activate item from layer tree
- Bug fix: rework of inline editing on overview page (Mac)
- Bug fix: reuse object editor instead opening a new one everytime an object is edited (and allow editing in a new window if required)
- Improvement: avoid renaming objects with the same name (triggers a chain of notifications)
- Bug fix: overwrite confirmation dialog is not always displayed when working with wizards
- Bug fix: crash in inserts editor when trying to delete a row if nothing is there yet
- Bug fix: update column type icon when a column flag is changed in columns editor (Mac)
- Improvement: added explicit setting of connection timeout parameter to 5 secs to avoid long pause when trying to access inaccessible IP address
- Bug fix: SQL generation now uses fully qualified names
- Bug fix: Connection parameters are copied after connection.
- Bug fix: fixed layout of lists in object filters
- Improvement: centralized context menu handling on all supported platforms
MySQL Workbench 5.1.14 RC2 (2009-06-19)
Platform: mac, linux, windows
[fixed (with associated bug reports)]
- Bug #44268 Right-clicking an item on the “MySQL Model” tab does not de-select other items
- Bug #44988 Relationship visiblity control has no effect
- Bug #45391 Edit table in foreign key tab do nothing
- Bug #45518 Printing crashes WB
- Bug #45519 Crash when creating a new document
[other fixes]
- Bug fix: fixed view rename action on diff generation
- Bug fix: fixed crash in parser when encoding for script file was not explicitely set
- Bug fix: main toolbar icons for undo/redo did not follow the current undo stack
- Improvement: allow specifying the encoding of a script file
- Improvement: reworked general popup handling for overview pane (Linux)
- Bug fix: crash in print setup if a certain paper type wasn’t found
- Bug fix: crash when diagrams were destroyed in a certain order
- Improvement: added modelOnly flag for foreign keys for export and synchronization
- Improvement: support for installing script plugins (Linux)
MySQL Workbench 5.1.13 RC1 (2009-06-12)
Platform: mac, linux, windows
[fixed]
- Bug #43799 INSERTs creation when forward-engineering SQL doesn’t work
- Bug #43893 Trying to select a stored connection in reverse engineering crashes
- Bug #44070 Error on “Synchronize Model with Database” dialog
- Bug #44134 Workbench preserves flags when data type changes on fwd. eng.
- Bug #44202 Can’t change the layer name
- Bug #44220 Schema default collation not saved
- Bug #44240 Columns order on diagram doesn’t change when changed in editor
- Bug #44254 “Copy SQL to Clipboard” is missing.
- Bug #44267 When exiting with unsaved changes, “cancel” closes application
- Bug #44296 Linux edit window not expanded horizontally by default
- Bug #44326 workbench unhandled exception
- Bug #44340 Deleting/cutting relation from diagram crashes MySQL Workbench
- Bug #44385 Fwd. Eng. SQL Script doesn’t generate INSERT Statements for Tables
- Bug #44407 Workbench Crashes when deleting diagram
- Bug #44435 Window close button does not reflect document dirty state
- Bug #44437 Fwd. Eng. SQL Create Script Wizard Does Not Warn When Overwriting
- Bug #44461 Workbench:copyToClipboard creates only garbage characters
- Bug #44503 Renaming a routine group does not update EER diagram
- Bug #44524 Page Setup, Print Preview and Print not working.
- Bug #44531 Not possible to copy with cmd+c
- Bug #44532 New Index Creation Shows Existing Index Field Selection
- Bug #44551 Changing column order doesn’t redraw/revalidate table box
- Bug #44552 INTEGER(n) not allowed, but INT(n) is ok
- Bug #44586 Show column types and flags partly broken
- Bug #44612 Workbench segfaults when selecting AI on second table
- Bug #44674 Program craches if the Indexes pane is clicked on a table without a PK
- Bug #44675 Rows not appear in EER diagram for table with > 20 columns
- Bug #44678 Crash after calling “manage connections”
- Bug #44701 Cannot properly create more than one foreign key per table
- Bug #44872 datatype integer get none unsigned and zerofill flag
- Bug #44906 Missing return statements
- Bug #44913 Can not copy text
- Bug #44972 layer rename
- Bug #44974 Workbench crashes on every save (segfault)
- Bug #45024 No Error Reporting during Synchronization
- Bug #45027 Default generated Foreign Key names are identical
- Bug #45042 MySQL Workbench crash when delete a entity.
- Bug #45139 Too long foreign keys name, error 1059
- Bug #45165 can’t use auto_increment attribute with user defined type
- Bug #45229 Forward Engineer Export or Live causes “quit unexpectedly”
- Bug #45230 Copy a model entity object from one model to another crashes app
- Bug #45233 After adding INSERTs to table, they can’t be removed
- Bug #45234 Stored Connection info not filled using Compare and Report Diffs in Catalogs
- Bug #45241 SQL Create Script option window duplicates items in export filtr
- Bug #45358 workbench exit when i try to use Database->Manage Connections
MySQL Workbench 5.1.12 beta3 (2009-04-27)
Platform: mac, linux, windows
MySQL Workbench 5.1.11 beta (internal build)
Platform: mac, linux, windows
MySQL Workbench 5.1.10 beta2 (2009-04-09)
Platform: mac, linux, windows
MySQL Workbench 5.1.9 beta (2009-03-21)
Platform: mac, linux, windows
MySQL Workbench 5.1.8 alpha (internal build)
Platform: mac, linux, windows
MySQL Workbench 5.1.7 alpha (2009-02-02)
Platform: mac, linux
MySQL Workbench 5.1.6 alpha (2008-12-24)
Platform: mac
MySQL Workbench 5.1.5 alpha (2008-11-13)
Platform: linux
MySQL Workbench 5.1.4 alpha (2008-11-08)
Platform: linux
MySQL Workbench 5.1.3 (internal build)
Platform: linux
MySQL Workbench 5.1.2 alpha (2008-09-23)
Platform: linux
MySQL Workbench 5.1.1 alpha (2008-09-18)
Platform: linux
MySQL Workbench 5.0.30 (2009-02-18)
We managed to close 27 bugs for this released build. While 10 were actually fixed in code, we also re-validated many reports in our bug-DB and found 17 which could be closed as the reported issue has been fixed in the meantime. As a minor addition, we added the possibility to navigate through the wizards in WB using shortcut keys.
[improved]
- added short-cuts to navigation buttons in wizards
[fixed]
- Bug #35905 Last column dissapears
- Bug #35989 dragged objects on layers are placed with an offset of -1:-1 when grid activated
- Bug #37709 Forward Engineer SQL Alter script has erroneous contents when no changes made
- Bug #38553 More detail and formatted item in table view of diagram sheet.
- Bug #39607 The viewport (combobox in top right corner) doesn’t scale/zoom less than 40%
- Bug #40846 Synch problem
- Bug #41355 Error in history when renaming model diagram
- Bug #41475 MySql Workbench, export, forward engineer SQL create script
- Bug #42085 Workbench .29 crashes afer File->Export->Forward Engineer SQL CREATE script
- Bug #42847 WB crashes on mousewheel
[closed]
- Bug #32284 Model changes that cannot be undone
- Bug #32347 Pipe symbol after END in routine body template
- Bug #32360 Reporting: text output not ok
- Bug #32372 WB deletes trigger code when I try to modify it
- Bug #32530 Errorneous routine editor behavior
- Bug #32701 Unhandled exception while reverse engineering
- Bug #33253 Crash while docking GRT inspection window
- Bug #34361 wrong coordinates when putting objects into nested layer
- Bug #35858 Context menu shows ” as caption for relationships
- Bug #38866 Make it easier to rename a diagram
- Bug #38867 Rename diagram does not automatically update label of diagram tab
- Bug #40213 Unnamed tab when open a script file
- Bug #33407 Click leaving datatype field in columneditor does not set datatype
- Bug #39244 “Synchronization” and “Generate catalog diff report” without foreign keys
- Bug #40237 Out of memory notice
- Bug #41727 unable to model a two-attributive hierarchical entity within one table
- Bug #42043 Error when saving model – Renaming Temporary File Failed: File Exists
MySQL Workbench 5.0.29 (2008-12-12)
This release is a quick follow-up to 5.0.28 where we fixed a serious bug that slipped through our tests in last release on 12/06/2008. Also, the windows installer was missing some additional icon files which are now included.
[fixed]
- Bug #41358 crash when moving objects half way out of layer
- Bug #41326 Not-Null Icon should be displayed
MySQL Workbench 5.0.28 (2008-12-06)
We managed to fix 16 bugs for this released build, and added a new display option – Column-properties like “Not Null”, “Auto Increment” and “Unsigned” can now be displayed as NN, AI and UN in the table-figures (This option can be switched on in options menu on the Diagram-Tab). Additionally we have done a small change on the column-icons inside the table figures – the little diamond shaped icons are now fulled for NN columns and outlined for columns which allow NULL as value.
[improved]
- new display option for column properties on table-figures
[fixed]
- Bug #33838 New n:m relationship table created in wrong layer
- Bug #34719 Export to PNG or PDF
- Bug #35811 Warning if trying to export a incorrect script
- Bug #36110 EER Diagram Table Objects Interactivity
- Bug #36168 Connection properties should be configurable in the Foreign Keys tab
- Bug #36987 workbench compilation problem
- Bug #38615 Add more icons to the left toolbar
- Bug #39360 EER diagram corrupted, not usable anymore
- Bug #39405 problems deleting Workbench source folder -privilege issue
- Bug #39976 crash on loading project with priviously deleted FK
- Bug #40327 When renaming a table MW loses inserts.
- Bug #40649 Renaming a Foreign Key clears its Referenced Columns
- Bug #40971 Unhadled Exception thrown on add and delete functions
- Bug #41025 Unhandled Exception when delete a doble foreingnkey
- Bug #41149 edit new table will crash the system
- Bug #41201 Unhandled Exception when Add Table is clicked in the table list
MySQL Workbench 5.0.27 (2008-11-07)
We managed to fix 15 bugs for this released build, improved the memory usage significantly and updated the layer pane to display connections as child-nodes of the corresponding table.
[improved]
- memory-usage reduced
- improved layer-pane (shows connection-objects now)
[fixed]
- Bug #37178 DBDesigner4 model import error
- Bug #38439 Workbench is very slow!
- Bug #38775 DEFAULT NULL not permitted for INT fields
- Bug #39257 exporting BOOLEAN gives BOOLEAN(2)
- Bug #39302 Workbench crashes frequently
- Bug #39476 Copy SQL to clipboard can’t be pasted to MySQL command line client directly
- Bug #39732 “Error: Invalid Object Name” during Forward Engineer SQL Alter Script
- Bug #39983 MyQSL Workbench crash when openning my model file
- Bug #39989 Renaming triggers cause failed database synchronisation
- Bug #39992 Workbench for Linux crashes on opening an existing file from XP
- Bug #40019 “Workbench” Misspelled as “Workbech”
- Bug #40041 Values missing from sql created by “Copy Insert to Clipboard” option
- Bug #40167 no method to show hidden relationships again
- Bug #40408 Foreign Key Options not updated
- Bug #40426 Routine editor jumps to top of page after a few seconds of no keyboard activity
MySQL Workbench 5.0.26 (2008-10-14)
We managed to fix 8 bugs for this released build while we focus on the Linux and Mac versions. Also, some minor improvements to the UI have been made. The Property-pane now shows object-properties on the MySQL-Model-Page too and there’s a new algorithm working for the Autolayout-Feature (basic implementation, yet needs to be optimized).
[improved]
- Property Pane is now also working on MySQL Model Page
- new algorithm for Autolayout-feature
[fixed]
- Bug #36183 Error in Executing Scripts with Comments in C-Style
- Bug #38325 Workbench crashes in Windows Vista
- Bug #39088 triggers calling procedures fails on insert
- Bug #39211 Forward Engineer Sql Script write invalid statements when using two schematas
- Bug #39256 table rename not reflected in SQL ALTER Script
- Bug #39477 “Copy insert to Clipboard” uses lower case for keywords
- Bug #39578 Workbench crash when exporting SQL script
- Bug #39772 Simplify (un)hiding objects in the model
MySQL Workbench 5.0.25 (2008-09-11)
We managed to fix 19 bugs for this released build while we focus on the Linux and Mac versions.
[fixed]
- Bug #32126 Zooming out too far or maximizing window makes the model disappear
- Bug #34510 Columns in table editor do not word-wrap properly
- Bug #35113 Reporting should render table comments
- Bug #36047 undo for creating views/routines doesn’t work as expected
- Bug #36085 Auto increment option was not cleared off internally on table editor
- Bug #36178 Forward engineer SQL ALTER script doesn’t handle database names correctly.
- Bug #38420 Access violation – no RTI data popup upon creating new mwb project
- Bug #38639 Can’t delete index of type FOREIGN
- Bug #38752 Trigger DDL editor trims down DROP IF EXISTS statements
- Bug #38783 SQL scripts don’t support UTF8 encoding
- Bug #38790 Forward Engineer script ignores selection
- Bug #38825 DEFAULT property is not being stored
- Bug #38944 Table lists should be ordered by name
- Bug #39118 Edit table opens table editing with “insert” mode on triggers tab
- Bug #39119 Missing DROP TRIGGER commands on export
- Bug #39122 Missing GRT Tree when Workbench is started with GRT-shell open
- Bug #39140 Missing quote for index name in forward eng. sql
- Bug #39150 Remove a table referenced in foreing key constraint
- Bug #39346 WB crashes on closing when all tabs (including overview) are cosed
MySQL Workbench 5.0.24 (2008-08-12)
The next bug fix release is ready. We were able to close 24 bugs for this released build. There are still remaining bugs for version 5.0 left which we’ll continue to fix – and at the same time version 5.1 is making good progress.
[fixed]
- Bug #34537 Font for Views and Routines should be configurable
- Bug #35052 Running MySQLgrtShell.exe does not open the GRT shell palette
- Bug #35315 able to download SE edition
- Bug #37059 Errors during “Forward Engineer Schema” for Inserts on TIMESTAMP cols
- Bug #37385 Error creating fisical script
- Bug #37574 Forward Engineer SQL CREATE script does not reflect changes in the model
- Bug #37634 Synchronize does not update model view
- Bug #37640 Cannot edit table in new window
- Bug #37665 Update Wizard crashes WB when trying to close it
- Bug #37685 Trigger auto formatting problems
- Bug #37686 Table comments are not synchronized
- Bug #37736 I can’t copy SQL to Clipboard
- Bug #37794 FK options (onDelete, onUpdate) not imported from DBDesigner schema
- Bug #38115 Workbench 5.0.23 SE Crashes on Model->Validate(MySQL)->Validate All
- Bug #38117 Crash at startup screen on Radeon 7500 display adapter
- Bug #38146 Mapping failed for datatype
- Bug #38196 Import DBD4 xml file MySQL style insert statements imported incorrectly
- Bug #38337 Creating a view with replace clause
- Bug #38402 A large database with multiple diagrams results in memory errors
- Bug #38429 Uncaught Exception when copying tables
- Bug #38431 Resizing Comment column under Physical Schemata view doesn’t save
- Bug #38436 “Synchronize to database” fail for triggers
- Bug #38488 Duplicate relationships from DBDesigner models cause create script to fail
- Bug #38632 Model >> Validation reports unreadable table names
MySQL Workbench 5.0.23 (2008-06-25)
The next bug fix release is ready. 26 bugs have been fixed for this released build. We’re still fixing remaining bugs for version 5.0 and at the same time working on version 5.1.
[fixed]
- Bug #32442 Application should remember window position/state
- Bug #34398 Plural used instead of the singular when generating a catalog diff
- Bug #34812 DB-Sync does not work correctly
- Bug #35644 Database synchronisation
- Bug #35716 Physical Schemata view is not saved between application launches
- Bug #35717 Collapse status of ERR Diagram pane not saved on application relaunch
- Bug #35878 Generate Schema Diff Report (re-opened)
- Bug #36115 Options windows bad layout/formatting with high DPI
- Bug #36177 Database Synchronize shows inconsistent behaviour
- Bug #36355 Forward Engineer SQL ALTER Script causes unhandled exception
- Bug #36374 Mouse wheel doesn’t work in table settings
- Bug #36381 Multiple Reverse Engineer operations destroy model diagrams
- Bug #36674 Synchronization generates invalid DDL when adding foreign key
- Bug #36753 Syntax error in export ‘Forward engineer SQL CREATE script
- Bug #36889 Forward Engineer SQL ALTER script generates script with syntax error
- Bug #37008 Workbench loses Inserts data (re-opened)
- Bug #37045 Delete multiple slected columns deletes wrong columns
- Bug #37060 “Forwar Engineer Schema”: failed database connect is displayed as ok
- Bug #37061 Parameters for stored server connections get lost
- Bug #37079 “cairo error” persistent after trying to place new image
- Bug #37180 EER Diagram – menu “Edit in New Window…” does not work anymore
- Bug #37192 Workbench loses Inserts data II
- Bug #37393 Generate Schema Diff Report Crash
- Bug #37432 Issue in exporting trigger DDL from Workbench
- Bug #37562 Forward Engineer SQL Alter script generates erroneous statements …
- Bug #37563 Forward Engineer SQL Create generates script it can’t then Reverse Engineer
MySQL Workbench 5.0.22 (2008-05-27)
This is the first release after moving our sources into a bazaar repository. 17 bugs have been fixes since last released build and some additional improvements were made. While we are already working on 5.1 in parallel we are still on eliminating remaining bugs in our current version.
[fixed]
- Bug #32972 WB doesn’t handle default-Value for columns
- Bug #35547 reading error : all-files from non-english directory
- Bug #35718 Saving a MWB file restores column widths to default
- Bug #35874 Forward Engineer Wizard Message-Log: Error messages are assigned wrong
- Bug #36166 Copy Connection does not seem to have a purpose
- Bug #36170 Workbench creates unnecessary SQL code on Fwd-Engineer Alter and Sync
- Bug #36253 Mouse wheel has wrong focus when INSERT-Editor is open
- Bug #36328 Scrolling, shifted content, navigation renders unusable
- Bug #36358 text box edit: cut/undo updates canvas, fails to update ‘edit’ box.
- Bug #36397 Model Integrity Validation (MySQL) does not allow DEFAULT NULL
- Bug #36453 Problem with FOREIGN keys
- Bug #36645 undo after creating relation does not work
- Bug #36647 Print functionality is not working properly
- Bug #36669 default values are not quoted for TIME columns
- Bug #36815 auto formatting trigger cause SYNTAX_ERROR_1
- Bug #37008 Workbench loses Inserts data
- Bug #37009 Can not add values for TIMESTAMP columns in the Inserts editor
MySQL Workbench 5.0.21 (2008-04-25)
In this release we incorporated several fixes to improve overal stability of Workbench. It includes 4 fixed bugs since GA-release. We are fixing open issues and plan to release next update in about 3 weeks. Please don’t hesitate to report a bug if it still occurs.
[fixed]
- Bug #35947 “Export” => “Forward Engineer SQL Create Script” creates wrong SQL Syntax
- Bug #36017 Mysql Workbench crash before startup
- Bug #36192 Forward Engineer Schema – Progress/Results Advanced Log does not scroll
- Bug #36208 Error: Export images to location containing german umlauts in name
MySQL Workbench 5.0.20 (internal build)
MySQL Workbench 5.0.19 (2008-04-15)
With this build, Workbench has reached GA. It includes 32 fixed bugs since RC3. We have hunted down all the known P1 and P2 bugs (and hopefully there are not many of them still hidden deeply inside). But we will keep fixing issues as they appear on our bug-reports page and publish improved versions frequently.
[fixed]
- Bug #30902 MySQL Workbench – Foreign Key Label Issues
- Bug #32453 Cancelling the file open dialogue window crashes the application
- Bug #32755 Typing ‘q’ in GRT Shell yields unknown exception and closes Workbench
- Bug #32888 autoplace needs to resize diagram to fit large models
- Bug #33545 Exception – Deleting row
- Bug #34430 Exporting via Forward Engineer to SQL Script fails quietly
- Bug #34493 “Hide Menu Items no Applicable to this Edition” can confuse the user
- Bug #34507 Table comments are allowed to be too long
- Bug #34856 Double clicking the Catalog title bar undocks the GRT Tree window
- Bug #35008 Connector problems on diagram
- Bug #35065 Relationship drawing tool should default “Pick Columns” to on
- Bug #35429 Catalog FK Changes don’t update the EER Diagram
- Bug #35497 Model navigator dosn’t update properly
- Bug #35547 reading error : all-files from non-english directory
- Bug #35649 Unexpected behaviour of undo hotkey in SQL script editor
- Bug #35655 navigation is too slow for a scheme with more than 200 tables
- Bug #35746 Export as PNG on Mysql Model produces nothing
- Bug #35800 update connection-style (solid/dashed) when changing corresp. column
- Bug #35840 System.AccessViolationException When creating a new View and deleting it.
- Bug #35859 font for FK caption not among workbench options
- Bug #35861 Please limit dblclick sensitive area for PK in column editor
- Bug #35870 disabled “DBDoc” feature still visible even when “hide ”
- Bug #35872 Pack Keys option is not savable
- Bug #35878 Generate Schema Diff Report
- Bug #35884 Fatal crash when synchronizing datamodel with live database
- Bug #35897 error message after upgrading MySQL workbench OSS 5.0.12 to 5.0.17
- Bug #35898 Impossible to use the word ‘position’ in a procedure
- Bug #35925 Crash on new document after manipulations in table editor
- Bug #35926 crash after pressing Esc in FK dropdown box
- Bug #35948 Foreign Key Reference Column taking 20-30 seconds to populate
- Bug #35969 Input focus extremely difficult to obtain
- Bug #36060 DBDoc HTML Basic Single Page missing schema and table numbers
MySQL Workbench 5.0.18 RC (internal build)
MySQL Workbench 5.0.17 RC (2008-04-07)
This is the third Release Candidate which includes 49 closed bugs. Improvements for this build include Syntax Highlighting for all schema object editors (view-, routine-, routine-group- and trigger-editor), a new description palette which allows easy access to the description/comment field of every object, more plugins (and a organized plugin-menu) and speed-optimized drawing for the canvas.
[Improved]
- Syntax Highlighting activated for all schema object editors
- Canvas Speed Optimizations
- Description Palette enabled
- Added more Plugin examples, restructured Plugin menu
- New toolbar buttons and icons
[fixed]
- Bug #32279 Undo/Redo does not work properly with Partitioning settings
- Bug #32502 Obscure error when attempting to start with no .NET installed
- Bug #32598 Overview page needs scrolling for schema list
- Bug #32882 Print to PDF and Export as Single Page PDF Relations for EER Diagram
- Bug #33013 Manifest XML signature is not valid.
- Bug #33179 Attempting to place an image on the canvas crashes the app
- Bug #33586 Export as single PDF shows extra lines
- Bug #33627 bad refresh model navigator on layers move
- Bug #34099 Forward Engineer ALTER script
- Bug #34134 Erroneous Duplicate plugin name warning message
- Bug #34153 Cannot add more than 5 storeprocs
- Bug #34248 Diagram Option “Draw Line Crossing” after restart of Workbench not used
- Bug #34397 Triggers tab automatically adds new header info after field update
- Bug #34483 copy/paste from one schemata to another just copies one table
- Bug #34509 The scrollbar in the Message log does not show the end of the log
- Bug #34610 “Hide Connection Captions” should be per diagram
- Bug #34630 Printing diagram yeilds only a blank page
- Bug #34808 Buttons on “Diagram Size” window not drawing
- Bug #35062 Mouse cursor hides when creating table indexes
- Bug #35112 Reporting with Text Basic template does not render table columns
- Bug #35123 Crash after trying to import a DB Designer scheme
- Bug #35251 Workbench SE crashes during startup with special date format settings
- Bug #35262 Validating double identifiers doesn’t seem to work…
- Bug #35265 Export to Alter Script fails to recognize all differences
- Bug #35349 crash when opening grt shell while table editor open
- Bug #35397 Connector positions are not saved
- Bug #35400 HTML Model report gives fatal error
- Bug #35426 Crash when selecting diagram while loading model
- Bug #35442 Cannot set negative value in Inserts Tab of the Table
- Bug #35446 Create Relatioship doesn’t show the line in file opened by doble click
- Bug #35447 errors creating relationships
- Bug #35465 Undo does not Undo all the movements in the Model
- Bug #35501 trouble with many colums per table
- Bug #35516 WB ignores per-model options
- Bug #35525 Inserts editor does not wrap TEXT or BLOB fields with quotes
- Bug #35598 Unhandled Exception when expanding indexes in diagram
- Bug #35601 Unknown Exception caught when changing to “Connect to Columns”-notation
- Bug #35603 Unhandled Exception when moving mouse after deleting a layer
- Bug #35604 Forward Engineer Wizard always fails MySQL-specifc validation.
- Bug #35613 Double-Clicking on column-editor row toggles primary key instead of editing
- Bug #35639 No refresh on the key icon on the eer diagram
- Bug #35642 Model navigatio window not closable
- Bug #35646 select all (CTRL+A) doesn’t work in script edit text box
- Bug #35650 Impossible to put upper case in stored procedures name
- Bug #35677 Constant “crash” in MySQL Workbench 5.0.16 RC
- Bug #35710 INSERTs do not escape column names
- Bug #35719 Physical schemata list view is not updating modified timestamp when modified
- Bug #35828 Segfault on procedure editor
- Bug #35830 deleting a fk connection in EER model causes exception
MySQL Workbench 5.0.16 RC (2008-03-26)
This is the second Release Candidate which includes 6 fixed and 11 closed bugs and yet further improvements. Loading times for Models with large diagrams were improved; colors of figures used on different diagrams can be synced now; the “pick columns” option of Relationship-tools is now a seperate tool (used to create connections using already existing columns); added a all new GRT Scripting IDE to create/modify/manage plugin scripts;
All users are recommended to update to this release.
[Improved]
- Better loading times for large models
- Try to automatically guess default ref column for FK editor
- Allow config of default On Update and On Delete values in Options dlg
- Option to synchronize color of objects that are present in different diagrams
- Removed “Pick Columns” relationship option and added a new rel tool type
- User defined datatypes (ie type aliases)
- Drag/drop definition of column types from user datatypes tree
- Option to define default table engine
- Optional auto-load of last opened model
- General optimizations (load time of large models reduced to a fraction of previous times)
- added GRT Scripting IDE
[Fixed]
- Bug #32597 Print preview: cannot discern individual tables
- Bug #32601 Able to drag Sections in the “MySQL Model” over themselves.
- Bug #32622 Workbench crashes in normal mode with OpenGL 1.5
- Bug #34964 Screen flicker and redraw problems when not full screen
- Bug #35417 Import of DBDesigner loses insert statements
- Bug #35466 Application crashes while importing this DBDesigner 4 file.
MySQL Workbench 5.0.15 RC (2008-03-17)
This is the first Release Candidate which includes 56 fixed and 81 closed bugs and further improvements. The connections of relationship-lines are now evenly spaced along the sides of the table-figures. SE version also got a new relationship-notation which connects lines directly from corresponding columns. DDL-Syntax of views is now parsed while editing – this also names the object regadring to the name of the view used in DDL. Overview page has been cleaned up and new pages in SQL export plugins for validation were added.
All users are recommended to update to this release.
[Improved]
- Better layouting of relationship lines
- New Relationship Notation which connects Relationship lines directly to columns (SE)
- Overview page cleaned up, especially for small icon views, auto scroll on focus disabled.
- Added validation pages for SQL Script/Database Diff/Export plugins (SE)
- Added wizard for import from sql script: #34213 Import -> Reverse Engineer SQL Script creates tables but do not display.
- Added background parsing of DDL statement in view editor.
[Fixed]
- Bug #32320 Print crashes (when printer is not available?)
- Bug #32328 Clicking the “Save Model” icon crashes Workbench
- Bug #32734 Cannot delete the relationship between two tables
- Bug #32835 Schemata Redraw problem
- Bug #32891 Placing object on canvas corrupts memory
- Bug #33007 Drag and Drop a table to the EER Diagram from Catalog window fail (sw render)
- Bug #33263 Program crash when attempting Forward Engineer SQL CREATE script…
- Bug #33265 Length on Table Name, Column Name, View Name, etc
- Bug #33340 Setting the endCaptionXOffs property to true throws an exception
- Bug #33477 Unexcepted exception when trying to add a Table on a Diagram (Vista 64)
- Bug #33577 Complete Crash after Clicking Save to File button
- Bug #33588 Import DBDesigner file causes exception straight away
- Bug #33612 Color picker for object color
- Bug #33818 Relationships not drawing correctly with non-default display options
- Bug #33980 Pressing ‘enter’ in comment field of a table, opens to the column tab
- Bug #34148 after resizing page, still can’t move objects past old page boundaries
- Bug #34170 The Find -> Entire Model option doesn’t work
- Bug #34329 Older WB versions still points to a site that claims there is no newer version
- Bug #34345 Table editor is not closed if schema of edited table is deleted
- Bug #34397 Triggers tab automatically adds new header info after field update
- Bug #34423 Checkbox in connection wizard does not describe its function
- Bug #34425 Database no longer highlighted after checking check box
- Bug #34433 The “Properties” palette retains the properties of an object that no longer exis
- Bug #34499 Repeatedly changing the object notation crashes Workbench
- Bug #34500 Initial Inserts not automatically updated when changing a column name
- Bug #34527 When creating a table in the ER mode, workbench crashes
- Bug #34618 Crash when i try to add a new table
- Bug #34662 Last table or view not shown on EER canvas
- Bug #34784 MWB File->New menu entry without function
- Bug #34810 Self-joined relationships are drawn as a single line
- Bug #34816 workbench crash after deleting a relationship
- Bug #34822 Docking Windows Bounce/Reallign
- Bug #34847 MySQL Workbench 5.0.14 crashes when editing model saved with 5.0.13
- Bug #34848 Crashes corrupt previusly saved file and make it inusable
- Bug #34849 Windows .mwb files explorer asociation doesn’t open and crashes
- Bug #34857 A new GRT Inspector tab is created every time the GRT shell is opened
- Bug #34897 Syncronize creates an invalid alter script when the user adds a new foreign key
- Bug #34904 Add Table icon disappears in the large icons view
- Bug #34922 Mysql Workbench 5.0.14a crashes on Vista when selecting a column
- Bug #34934 Changing the drawSplit property of a connection is not updated in the editor
- Bug #34975 Don’t scroll unnecessarily
- Bug #34976 Changes to VIEWS can be overwritten
- Bug #34987 Cairo Error : input string not valid UTF-8 after a DB Designer scheme import
- Bug #34988 Navigation scroolbar not fontionnal after Import a big scheme DB of Designer
- Bug #35093 Changing foreign key name in key editor doesn’t change table definition
- Bug #35119 Typo in the GRT help file for “cd”
- Bug #35127 Can’t press enter key in “default” field in table column editor
- Bug #35186 deleting objects from overview with editor open crashes WB
- Bug #35197 Print to PDF gives corrupt file
- Bug #35205 Impossible to insert booleans
- Bug #35213 Alter script produces extra set of connection lines
- Bug #35227 Reverse Engineering from DB using autoplace feature crashes WB
- Bug #35237 reflexive foreign key connector not clickable
- Bug #35243 On undo in EER Diagram Unhandled Exception
MySQL Workbench 5.0.14a Beta (2008-02-28)
This was an unsceduled Beta release that was released to fix a bug which slipped through our pre-release tests. This bug caused some documents created with earlier versions of Workbenchnot to open properly in 5.0.14.
MySQL Workbench 5.0.14 Beta (2008-02-25)
The sixth Beta release includes 35 closed bugs and some major improvements. The software-rendering engine was changed from using mesa to GDI which increases performance remarkably and brings working with software-rendering much closer to the openGL experience. The property editor was brushed up with value-editors to easier enter/edit the property values (color-picker dialog, dropdown-true/false, …) and better multi-selection-editing. And the possibility to manually change sizes of the table-objects on the canvas (a much requested feature).
All users are recommended to update to this release.
Change Log
[Fixed]
- Bug #32578 Forward Engineer ignores de-selected database objects
- Bug #32758 Draging 65 tables into the EER Diagram tab, makes it unusable to work with.
- Bug #33074 “Select Objects” page shows all objects from all schemata
- Bug #33139 Workbench is crashing on save after changing foreign key column
- Bug #33171 Misleading window subtitle when creating ALTER script
- Bug #33183 Database Synchronize crashes workbench when server shuts down
- Bug #33749 Annoying screen redraw
- Bug #33964 Crashes after changing name on schema tab and saving with File > Save or Ctrl-S
- Bug #34038 Cannot find module directory .\\plugins.; Error scanning for modules: Invalid pat
- Bug #34100 Export of specific tables doesn’t export all tables
- Bug #34206 Diagram do not refresh when put new foreign keys
- Bug #34230 copy/paste from model-page to diagram creates inconsistent table
- Bug #34234 context-menu on empty area around MySQL Model shows unwanted items
- Bug #34315 undo on FKs created via Table-Ed crash WB
- Bug #34342 Create user is omitted when exporting SQL-Script
- Bug #34396 Unhandled exception generating catalog diff report
- Bug #34400 Inconsistent naming of menu option
- Bug #34405 Incorrect heading in Forward Engineering dialogue
- Bug #34416 WB SE Version Check links to OSS download
- Bug #34419 DBDesigner4 imported table constraints show duplicate paths
- Bug #34434 Unhandled Exception when Deleting Multiple Objects from Diagram not Catalog
- Bug #34435 DBDesigner4 imported tables are missing some table level attributes
- Bug #34457 Autoplace when reverse engineering a database dosn’t display all tables
- Bug #34474 Mixed case display of hex numbers
- Bug #34476 Creating a relation leads to unhandled exception
- Bug #34496 On the EER canvas you cannot reduce the width of a table
- Bug #34501 UI problems in Export > Forward Engineer
- Bug #34503 State of selections in Export > Forward Engineer
- Bug #34516 Clicking “NN” or “AI” checkboxes without highlighting a field causes error
- Bug #34536 Long identifiers make icon view look messy / Add table button should stay in place
- Bug #34558 Title for a EER Diagram
- Bug #34697 Software rendering redraw strategy broken
- Bug #34704 Entity Relation (ER Display) on workbench does not show added entities on Vista
- Bug #34736 Table Names Overlap in “Physical Schemata” section
- Bug #34743 keyboard entry of table data enhancement
[Improved]
- added manual resizing of table figures
- added “Arrange -> Fit Objects to Contents” command
- added Help -> System Info menu command for information usefull when reporting bugs
- added Arrange -> Expand All and Collapse All
- added SVG export support
- code base cleanup – removed many warnings
- added type wise editor for properties form and GRT Inspector (supported types: text/longtext/bool/color/file/)
[Changed]
- Removed Mesa based rendering and added GDI support (-mesa option is now -swrendering)
MySQL Workbench 5.0.13 Beta (2008-02-07)
The Fifth Beta release including ~70 closed bugs a new features like live-update and Catalog Diff Reporting. All users are recommended to update to this release.
Change Log
[Fixed]
- Bug #31913 Validation: using identical identifiers for a view and a table not detected
- Bug #31943 Table editor / indices: key_block_size not preserved on export
- Bug #31948 Reverse engineering of INT ZEROFILL UNSIGNED failed
- Bug #31962 Exported CREATE USER lacks password from GUI
- Bug #31984 String types: missing length check cause invalid SQL CREATE script – many issues
- Bug #31985 Don’t allow the specification of a length for MEDIUMBLOB, LONGBLOB
- Bug #31987 Default value validator for DATETIME/TIMESTAMP is too strict / duplicate warning
- Bug #31991 Validator for YEAR default values could be improved, YEAR(3) should be detected
- Bug #31995 BIT(M) – number of bits lost in export, forgotten during import, validation
- Bug #31998 TINYINT(M) – support for the ‘M’ in general, default validation wrong
- Bug #32000 SMALLINT[(M)] issues – similar to TINYINT etc.
- Bug #32214 Warn of conflicting import table/trigger selections in reverse engineering
- Bug #32535 Validating ignores table columns not having datatype.
- Bug #32544 Add/Remove Programs Menu has wrong links for both company and product updates
- Bug #32548 Deleting schema and diagram crashes Workbench
- Bug #32811 Draging detached Navigator window displays mysterious icons (Not a Bug)
- Bug #32885 Import from SQL script does not recreate views, functions and stored procedures
- Bug #32930 Routines are populated when changing name
- Bug #32931 Routines Group Editor does not handle dragging routines correctly
- Bug #32950 “Edit Table…” freezes Workbench in some cases
- Bug #32958 Deleting FK silently removes the columns
- Bug #32960 “Edit in New Window” context menu option missing in the “Model” view
- Bug #32982 Relationship editor has tab caption “DbMysqlRelationshipEditor”
- Bug #32984 Error message for invalid column for fk not prominent enough
- Bug #33075 Forward Engineer SQL Create Script and CREATE DATABASE
- Bug #33076 Scrollbar does not allow scrolling all the way across the EER diagram
- Bug #33078 Printing a diagram that has more than one vertical page does not work (Duplicate)
- Bug #33176 Extra menu separator when right clicking a note
- Bug #33178 It’s possible to create two notes with the same name
- Bug #33187 Unclear reporting option
- Bug #33264 Clicking on Column NN or AI property causes Column Details to disapear
- Bug #33276 Able to attempt a rename via slow double click in Physical Schemata section
- Bug #33326 The foreign key are not showed automatically after reload. (Duplicate)
- Bug #33335 Dropping objects on the edge of a layer makes them inaccessible
- Bug #33338 Use of non-existent verb form “splitted”
- Bug #33339 Property named “referedMandatory”
- Bug #33343 Typo “Entitiy” in relationship editor
- Bug #33374 Roles fail to display in the “Roles” section of the MySQL Model window
- Bug #33385 Table name not always displayed in Catalog view
- Bug #33444 Tables and other canvas elements can have the same name (Not a Bug)
- Bug #33453 Forward Engineer Wizard is missing scrollbars when showing generated SQL
- Bug #33557 Forward engineer SQL script places insert commands in wrong place in script
- Bug #33625 layers size modifications can’t be saved
- Bug #33656 Workbench Generates Invalid Foreign Index Statements
- Bug #33660 Insert Editor: print bug on multi inserts
- Bug #33664 Workbench Allows Foreign Relationships With Unmatching Data Definitions
- Bug #33775 “Delete attached database objects” prompt should be “corresponding”
- Bug #33776 Catalog not updated after delete from canvas
- Bug #33777 Right click on selection of multiple objects undoes current selection
- Bug #33787 Deleting table from MySql Model
- Bug #33788 Sort Catalog Tree
- Bug #33839 Diagram scrollbars do not work when zoom < 100 (Duplicate)
- Bug #33867 There is no option for closing the “Find” dialogue window
- Bug #33874 Import of SQL dump from phpmyadmin ignores all relationships
- Bug #33892 Message when closing Workbench with unsaved changes
- Bug #33927 Import DBDesigner4 Layers are not handled correctly
- Bug #33940 Unhandled exception has occured (Duplicate)
- Bug #33942 DBDesigner4 imported table generates incorrect ROW_FORMAT
- Bug #33981 ‘Edit in new window’ opens the output window displaying error ‘Invalid Path’
- Bug #33994 Inconsistent behaviour removing objects from layers
- Bug #34012 Inconsistent use of upper case
- Bug #34088 Line feeds in table comments (Duplicate)
- Bug #34143 Typo in “Forward Engineer to SQL Script” window
- Bug #34152 Reverse Engineer shows “Execution completed succesfully” even if it is no succes
- Bug #34154 dragging objects from catalog to model doesn’t draw relationships
- Bug #34212 Reverse Engineer Schema Messages (Duplicate)
- Bug #34226 wrong undo when used “pick columns”
- Bug #34233 pressing ‘v’ on model page adds and brings up a new EER-Diagramm
- Bug #34253 import sql workbech script generates errno 121 (Not a Bug)
- Bug #34268 Keyboard tabbing sequence incorrect when editing a table
- Patch for tinyxml to support utf8 encoded filenames. Now it’s possible to import dbd4 model from path containing wide characters.
- Bug in SQL scanner: fail to process “:=” sequence properly.
- Bug in SQL splitter: fail to process empty statements (consisting of delimiter only) in some circumstances.
[Improved]
- Added plugin for easy updating of Workbench to latest version via Internet.
- Added catalog diff reporting plugin
- Updated SQL parser to process drop statements (so far only for schemata, tables & views). Now it’s possible to import SQL dump files with their temporarily created tables.
- Improved parsing/syntax checking of column datatypes
[Changed]
- Reverse engineering plugin: naming of triggers in filter control was changed to include table name: schema.trigger -> schema.table.trigger.
- Context menus now can work on multiple selected items
MySQL Workbench 5.0.12 Beta (2008-01-17)
The Fourth Beta release including 47 closed bugs with 22 hot fixes. All users are recommended to update to this release.
Change Log
[Fixed]
- Bug #33410 Undo broken – does not restore previous state
- Bug #33668 Invalid table comments in SQL exports |
- Bug #32721 Forward engineer SQL Alter script causes crash within SQL Diff Tree |
- Bug #32809 File–>Import–>Reverse Engene… ignores selected schema in Physical Schema |
- Bug #32939 The value of “shema collation” is reset when executes some operations |
- Bug #33090 Open mwb – file |
- Bug #33383 The check update url does not work |
- Bug #33394 Problem when saving with french accented characters |
- Bug #33408 Crash during opening of a mwb file |
- Bug #33422 Awkwardly worded check box label |
- Bug #33585 Partition option cannot be removed. |
- Bug #33589 Crash when clicking on a foreign key when its referenced table has been deleted
- Bug #33606 Exported SQL script has invalid format (create table with comment) |
- Bug #33674 Lowercased word “UNSIGNED” in column defs skipped when importing SQL
- Bug #33765 UI Performance issues |
- Bug #32192 New Layers, created on another layer are displayed as child in layer-tree-pane
- Bug #32224 Partitions not recognized by reverse engineering |
- Bug #33069 Windows with the redundant name “Database Schema” |
- Bug #33089 New database name is not propagated |
- Bug #33225 Changing the object notation crashes the application |
- Bug #33603 | Table comment generates incorrect SQL |
- Bug #33681 | Import from sql script doesn’t show any error when the sql file contain errors
[Improved]
- Updated SQL parser to be compatible with SQL grammar of MySQL DBMS v5.1.22-community.
- Added table column reordering by drag-n-drop
- Update Lua scripting integration
- Added Lua demo plugin
MySQL Workbench 5.0.11 Beta (2007-12-20)
Third Beta release including 60 bug fixes and a lot of improvements. All users are recommended to update to this release.
Change Log
[Fixed]
- Corrected collation label texts
- Bug #32936 Cannot show the help file information from the help menu.
- Bug #33054 Reverse engineering schemas with space in name fails.
- Bug #31924 Default Collation of a schemata not recognized during reverse engineering.
- Bug #31926 Default collation and character set of column not recognized during rev. eng.
- Bug #32930 Routines are populated when changing name
- Bug #32931 Routines Group Editor does not handle dragging routines correctly
- Bug #33279 crash when dragging into EER diag due to bad foreign key defs in imported sql.
- wb.mysql.import.sql: changed to autocreate index supporting foreign key constraint, only if no appropriate (same field set) index was found.
- grt.db.be (table_editor): added missing synchronization of foreign key columns with supporting index columns.
[Improved]
- Added output SQL table formatting for export/sync plugins
- Added new page to reverse engineering wizard, showing generated DDL script before actual parsing. (Bug #32531)
- Improved GRT Shell input console
- wb.mysql.import.sql was updated to create index supporting foreign key constraint, only if no appropriate (same field set) index was found.
[Changed]
- Disabled renaming for Routines in Overview Form
- Routine editor will save its contents immediatelly after new routine creation
MySQL Workbench 5.0.10 Beta (2007-11-30)
Second Beta release including 75 bug fixes and a lot of improvements. All users are recommended to update to this release.
Change Log
[Fixed]
- Fixed crash during save on Windows Vista
- Fixed FK names to use configured template on relationships created with the “Pick Columns” option set
- Escape table and column comments (containing newlines and ‘ or “) when exporting SQL
- Remove foreign key columns when a connection is deleted
- Fixed exception when a bad color value was input in the Options
- Fixed selection loss bug in FK and Index tabs in table editor
- Fixed relationship visibility options
- Fixed crash in Index editor
- Fixed a crash when attempting to load invalid models
- Fixed Add Object icons in overview to not allow renaming
- Fixed nested layer placement
- Fixed stored document creatime time
- Fixed copy/paste to properly copy table objects (with PK etc)
- Crash after deleting View figure (Bug #32368)
- Bug #32326 Follow up on missing ENGINE: SQL ALTER script does not detect engine change
- Bug #31855 WB crashes when calling File -> Export -> SQL Alter Script…
- Bug #31885 WB: DROP TABLE after CREATE TABLE in exported SQL ALTER script
- Bug #31904 WB exports everything regardless of object select during export
- Bug #31908 Changing table engine from InnoDB to MyISAM produces invalid SQL ALTER script
- Bug #31914 Create a table, get a view in your CREATE SQL script
- Bug #32367 Syncronization: no DELETE table, no DROP PROCEDURE, DROP TRIGGER
- Bug #32231 No dependency checks when exporting views / export fails
- Bug #32280 WB shows wrong table engine for merge table / CREATE script wrong
- Bug #32329 Changing index columns not reflected in SQL ALTER script
- Bug #32321 Export CREATE/ALTER SQL gets confused when removing PK
- Bug #32324 WB does not always reflect column oder changes in SQL ALTER script
- Bug #32327 SQL ALTER script: problems when renaming PK index
- Bug #32330 SQL ALTER script does not have DROP TABLE after deleting table
- Bug #32331 Renaming table not reflected in SQL ALTER script
- Bug #32332 SQL CREATE/ALTER/Sync script: newly added view not properly exported
- Bug #32334 SQL ALTER script fails on table options
- Bug #32336 Exception/”Crash” during ALTER script generation because of invalid column
- Bug #32340 ALTER script/Model validation: Exception/Crash after adding new field to FK
- Bug #32343 WB does not detect “hanging” foreign keys and exports buggy SQL
- Bug #32358 Crash during SQL CREATE script generation after adding PK
- Bug #32371 Automatic synchronization fails as soon as schemata has a procedure
- Bug #32373 Synch: new columns not detected
- Bug #32576 Nothing entered in Forward Engineer Filter’s causes unhandled exception
- Bug #32687 Synchronize on an InnoDB table containing records and an auto_increment column
- Bug #32761 Forward Engineer out of sync with SHOW WARNINGS
- Reverse engineering:
- Fixed restoring of trigger DDL from metadata. Problem was caused by usage of unquoted ‘definer’ expression.
- If there was at least 1 error message, set erroneous state. (Bug #32531, still open)
- Always sort items in object filter by name. (Bug #32545)
- Fixed error when pressing enter in the GRT shell without a command
[Improved]
- Added Popup Menus to objects in the Overview tab
- Added a diagram sizing dialog
- Added a UI layout reset command
- Allow zoom to be set with keyboard in navigator
- Added scrollbars to text edit boxes
- Allow copy/paste of DB objects in overview
- Escape and Enter default to Cancel and Next in wizards
- Implemented missing View -> Windows commands
- Save Document confirmation dialog when exitting or new/open document
- Saving/Loading of application options
- Disable Next button in wizards when Input or Output files are not specified
- Unhighlight tables when connection is deleted
- Added MySQLWorkbench.chm to distributions and enabled Help Index menu item
- Added scripts to create distribution zips
- Enabled ‘Advanced’ button in wizard when performing long running tasks.
- Added runtime check of OpenGL version to select between software/hardware rendering (GRT shell reports active rendering method).
- Reverse engineering:
- Make check for names duplication within common tables/views namespace during rev-eng (forbid if necessary).
- Log error & skip statement if name of the object to rev-eng conflicts with existing object name. Exclusion made for schema, only warning is returned in its case & previous schema object is reused.
- Added scrolling to last message in Output and History grids
- Added popup menu to copy messages from the Output and History grids
[Changed]
- Moved page settings storage from global to document
- Reordered Catalog and Layers panel
- Option to hide SE specific items from menus
- Loading document with non-utf8 characters will result in ingoring statements with those characters (was: load aborted)
- Removed .vshost files from distributions
- Changed naming of stub routines (routines in routine group having invalid sql syntax) by prefixing with routine group name to avoid name conflicts with stubs from other routine groups.
MySQL Workbench 5.0.9 Beta (2007-11-19)
First official Beta release of the tool on the Windows platform.