Database Workbench v4 - Change Log

0000874: [General] Ability to export SQL/Code catalogs when exporting user data (Martijn Tonies) 0001117: [MySQL Module] Issue with saving registered databases to export config file (Martijn Tonies)

0000955: [General] Foreign key naming doesn't accept non-template input (Martijn Tonies) 0001032: [General] Find Text dialog is misbehaving (Martijn Tonies) 0001090: [General] Access violation on using ctrl+c in Procedure Editor after certain sequence of events (Martijn Tonies)

0000794: [Visual Query Builder] Firebird TRIM Function with extended paramters not correctly parsed by VQB. (Martijn Tonies) 0000977: [Microsoft SQL Server Module] SQL Insight pop up not working with top 1 clause (Martijn Tonies) 0000974: [Oracle Module] Modifying a column to "not null" with a default of "null" makes the change un-save-able (Martijn Tonies) 0000978: [Firebird Module] Possible access violation on dependencies in calculated column depending on stored procedure (Martijn Tonies) 0000992: [Firebird Module] Procedure parameter default with syntax " = <value> " fails DDL extraction (Martijn Tonies) 0000996: [General] DB Navigator "incremental search" can produce strange results when not scrolled down first (Martijn Tonies) 0001012: [General] Unable to debug stored procedure with particular syntax (Martijn Tonies) 0001017: [Microsoft SQL Server Module] During database compare, TEXT is always said to be different from TEXT (Martijn Tonies)

0000921: [Diagramming] Ability to print diagram on larger size than A4/Letter (Martijn Tonies) 0000944: [Microsoft SQL Server Module] TRUNCATE command in SQL Editor doesn't enable commit/rollback buttons (Martijn Tonies) 0000417: [Firebird Module] Support for EXECUTE STATEMENT on external data source in parsing and debugging (Martijn Tonies) 0000898: [NexusDB Module] Re-compiling Stored Procedure/Function fails (Martijn Tonies) 0000923: [Oracle Module] After opening a "library" in the Library Editor, it always tells you it's been modified (Martijn Tonies) 0000931: [General] Lines automatically added to the SQL Editor when switching between SQL pages (Martijn Tonies) 0000937: [Firebird Module] Issue starting debugger with certain parameter default values (Martijn Tonies) 0000934: [Firebird Module] "columns are different" on column with domain with a default and specific database issue (Martijn Tonies) 0000935: [NexusDB Module] Constraint meta data fetching issue in specific combination of meta data (Martijn Tonies) 0000939: [General] If a default expression evaluates to NULL it's not properly set when starting debugging (Martijn Tonies) 0000945: [Diagramming] Possible "no physical table block found" error when loading Oracle diagram into a session (Martijn Tonies)

0000853: [Microsoft SQL Server Module] Compile a trigger - get an Access Violation (Martijn Tonies) 0000854: [Microsoft SQL Server Module] Create and save a Trigger, then load it up again for editing and it has the wrong trigger type (Martijn Tonies) 0000855: [General] Query statistics not shown for non-SELECT queries (Martijn Tonies) 0000879: [Oracle Module] Using Oracle 12 always resulted in an Assertion error (Martijn Tonies) 0000881: [MySQL Module] Column Attributes for MySQL timestamp not triggering a change, won't update the structure (Martijn Tonies) 0000884: [General] Possible access violation on corner case with Preferences editing (Martijn Tonies) 0000885: [Data Import & Export] CSV import completed succesfully, but columns are missing data (Martijn Tonies) 0000886: [Visual Query Builder] Firebird: issue with DATEADD and WEEK, parser fail (Martijn Tonies) 0000888: [Data Pump] DataPump fails on CSV file with large (char) values converted to BigInt (Firebird) (Martijn Tonies) 0000894: [Oracle Module] NUMBER can be incorrectly be returned as INTEGER (Martijn Tonies)

0000084: [Compare & Migration] Stored procedure: the variables with default value had to be last parameters (Martijn Tonies) 0000756: [Compare & Migration] Firebird: Domains for procedure parameters not used when creating change script after compare (Martijn Tonies) 0000795: [Oracle Module] Exiting drop down combos in Create/Edit Table Space dialog raises exception (Martijn Tonies) 0000806: [SQL & Parameter Insight] Possible out of memory when invoking sql insight (Martijn Tonies) 0000808: [MySQL Module] Creating full text index on nchar/nvarchar column raises error (Martijn Tonies) 0000812: [General] When using "quick browse", use table name as task bar caption instead of "unnamed" (Martijn Tonies) 0000820: [MySQL Module] Server Process window fails to connect on non-default port server (Martijn Tonies) 0000821: [Data Import & Export] NexusDB CSV import fails on integer column (Martijn Tonies) 0000822: [General] Grid font size in Preferences not used in editor grids (Martijn Tonies) 0000828: [MySQL Module] Debugger: Server side raised SQL errors not always caught by declared condition handlers (Martijn Tonies) 0000841: [Firebird Module] Create database can fail on multi-instancing and having multiple clients on the workstation (Martijn Tonies) 0000843: [Firebird Module] Single line comments in scripts should not be replaced for Firebird 1.5 and up (Martijn Tonies) 0000807: [Microsoft SQL Server Module] Query prevents access (Martijn Tonies) 0000844: [Diagramming] Diagram editor updateable from database (Martijn Tonies) 0000845: [Diagramming] Using "get format"/"apply format" ignores font color (Martijn Tonies) 0000846: [Diagramming] Comment Box context menu has an item saying "Action1" which does nothing (Martijn Tonies) 0000847: [General] "Data" tab in Table & View Editor wasn't using the default transaction isolation from the Preferences (Martijn Tonies)

0000753: [General] Have the "copy" function work when not in cell-edit mode (Martijn Tonies) 0000764: [Sybase SQL Anywhere Module] CREATE SEQUENCE fails on NOCACHE (Martijn Tonies) 0000765: [Microsoft SQL Server Module] Cannot register multiple server instances with same hostname (Martijn Tonies) 0000774: [Diagramming] Loading a project for Oracle with foreign keys can block due to update rules (Martijn Tonies) 0000401: [Compare & Migration] SQL Server compare, "nocheck" is not in script after compare (Martijn Tonies) 0000699: [SQL & Parameter Insight] Firebird & InterBase: ":" wrongly added after selecting field from list in RETURNING_VALUES clause (Martijn Tonies) 0000750: [General] Navigating a locally sorted grid with next/previous/home/end buttons doesn't use sorting order (Martijn Tonies) 0000782: [Firebird Module] Access Violation when clicking "Add File Spec" in Backup Project manager with no project selected (Martijn Tonies) 0000783: [InterBase Module] Access Violation when clicking "Add File Spec" in Backup/Restore Project managers with no project selected (Martijn Tonies) 0000784: [Microsoft SQL Server Module] Variant error on SQL_VARIANT in data result set (Martijn Tonies) 0000786: [General] Possible code parse error resulting in out of memory error (Martijn Tonies) 0000787: [Firebird Module] Possible code parse error resulting in out of memory error (Martijn Tonies) 0000788: [InterBase Module] Possible code parse error resulting in out of memory error (Martijn Tonies) 0000789: [MySQL Module] Ability to set ping-time for MySQL database connections to avoid server side timeout (Martijn Tonies)

0000759: [General] Cannot start due to GDI+ error after certain Windows XP update (Martijn Tonies)

0000628: [Data Import & Export] Empty varchar imported as null (Martijn Tonies) 0000407: [General] Tooltip screen at startup does not have keyboard focus, and you cannot bring keyboard focus to it using only the keyboard (Martijn Tonies) 0000487: [General] After execute prodecure result windows still displays procedure result grid when executing select statement (Martijn Tonies) 0000714: [Diagramming] Access violation when saving diagram (Martijn Tonies) 0000715: [Diagramming] "documentation link" has two empty labels attached (Martijn Tonies) 0000716: [Diagramming] Extra label on a "link" moves in the wrong way when scrolling the diagram (Martijn Tonies) 0000712: [Microsoft SQL Server Module] run of UDF with datetime parameter value allways error : "syntax error near to ','" (Martijn Tonies) 0000718: [General] Ability to use BLOB Editor on large (VAR)CHAR columns (Martijn Tonies) 0000719: [General] Possible error using Debug Function if not supported (Martijn Tonies) 0000720: [General] Misc small changes (Martijn Tonies) 0000728: [Firebird Module] Using a domain as parameter data type doesn't include quotes when needed (Martijn Tonies) 0000725: [General] CTRL+Insert cannot be used to 'Copy' tekst (Martijn Tonies) 0000726: [General] List index out of bounds error on delete of script page when only 1 page is available (Martijn Tonies) 0000729: [Firebird Module] Debugger fails on (IF <variable> IS NULL) on variable based on BLOB data type (Martijn Tonies) 0000732: [InterBase Module] Debugger fails on (IF <variable> IS NULL) on variable based on BLOB data type (Martijn Tonies) 0000733: [Firebird Module] Using "type of" and a table column as parameter data type in stored routine, doesn't show up in editor (Martijn Tonies) 0000736: [Data Pump] Custom SQL source: click "save" button on IB/Fb connections raises access violation (Martijn Tonies) 0000739: [Data Pump] When loading a project with custom SQL transfers, mappings for custom SQL transfers won't be restored (Martijn Tonies) 0000738: [Data Pump] Error on transferring blobs/empty blobs to Oracle (Martijn Tonies) 0000746: [Data Import & Export] XML export fails when filtering result set names (Martijn Tonies) 0000747: [Data Import & Export] XML Export with multiple tables to folder fails and keeps files locked (Martijn Tonies)

0000632: [ADO/ODBC Explorer] Small ODBC issues with NexusDB ODBC Driver (Martijn Tonies) 0000627: [General] TO-DO item priority not saved (Martijn Tonies) 0000655: [Visual Query Builder] Window size (Martijn Tonies)

0000636: [General] Registered Server order without folders not saved (Martijn Tonies) 0000697: [General] Multi-line text impossible to edit/paste in large (but not BLOB) text columns (Martijn Tonies) 0000615: [General] MRU lists in SQL Editor are overwritten by last SQL Editor (Martijn Tonies) 0000623: [General] Better concurrency when running multiple scripts (Martijn Tonies) 0000637: [MySQL Module] Debugger error with output parameters (Martijn Tonies) 0000358: [Firebird Module] Debugger: Possible "datatype not supported" error on preparing certain SQL statements. (Martijn Tonies) 0000359: [InterBase Module] Debugger: Possible "datatype not supported" error on preparing certain SQL statements. (Martijn Tonies) 0000616: [General] An error in one running Script Editor stops other Script Editors running the script (Martijn Tonies) 0000644: [Firebird Module] SP debugger doesn't support INSERT INTO ... RETURNING (Martijn Tonies) 0000645: [Firebird Module] WHEN (something that's invalid) DO... is used in a Stored Procedure, the program freezes (Martijn Tonies) 0000648: [InterBase Module] WHEN (something that's invalid) DO... is used in a Stored Procedure, the program freezes (Martijn Tonies) 0000620: [SQL & Parameter Insight] SQL Insight stops after CONTAINING/STARTING WITH in InterBase and Firebird (Martijn Tonies) 0000672: [General] Run Stored Routine: Saving parameter values for re-use fails to save current (new) entry (Martijn Tonies) 0000673: [General] Run Stored Routine: Clicking OK on "parameter values" dialog might miss last entered value (Martijn Tonies) 0000676: [MySQL Module] Routine Debugger: Using CAST inside a statement/assignment raises an error (Martijn Tonies) 0000677: [InterBase Module] Routine Debugger: Handling of CHAR assignments is incorrect (Martijn Tonies) 0000678: [Firebird Module] Routine Debugger: Handling of CHAR assignments is incorrect (Martijn Tonies) 0000679: [MySQL Module] Routine Debugger: Handling of CHAR assignments is incorrect (Martijn Tonies) 0000681: [InterBase Module] Routine Debugger: CHARs are trimmed when fetched into variables (Martijn Tonies) 0000680: [Firebird Module] Routine Debugger: CHARs are trimmed when fetched into variables (Martijn Tonies) 0000685: [General] Routine Debugger: misc small fixes (Martijn Tonies) 0000692: [Firebird Module] Querying case sensitive binary column fails in SQL Editor (Martijn Tonies) 0000700: [Firebird Module] Cancel Statement in SQL Editor fails (Martijn Tonies)

0000434: [MySQL Module] Saving a modified, but invalid trigger followed by saving it corrected fails with "drop" error message (Martijn Tonies) 0000520: [MySQL Module] Debugger should accept hex literal defaults for integer values (Martijn Tonies) 0000523: [Firebird Module] Debugger/syntax check error on SELECT if first item is a parameter with colon (Martijn Tonies) 0000494: [Microsoft SQL Server Module] SQL Server 2008 back-end: if a user has no "Execute Query Plan" permissions, DBWB does not show query results. See screen shot. (Martijn Tonies) 0000505: [Firebird Module] Debugger error with certain construct (Martijn Tonies) 0000506: [InterBase Module] Debugger error with certain construct (Martijn Tonies) 0000510: [Firebird Module] Problem with SP debuger (Martijn Tonies) 0000519: [Firebird Module] Debugger should accept hex literal defaults for integer values (Martijn Tonies) 0000521: [Firebird Module] Debugger should accept hex literal values for integers (Martijn Tonies) 0000522: [MySQL Module] Debugger should accept hex literal values for integers (Martijn Tonies) 0000531: [ADO/ODBC Explorer] BLOb TEXT and NUMERIC metadata not properly fetched (Martijn Tonies) 0000536: [General] Large text blobs still causes SQL Editor to hang because of hints if you set to "Don't show" in Preferences (Martijn Tonies) 0000574: [Firebird Module] entering generator value (Martijn Tonies) 0000579: [Firebird Module] Debugger SQL errors when using Float/Decimal values with specific regional settings (Martijn Tonies) 0000580: [InterBase Module] Debugger SQL errors when using Float/Decimal values with specific regional settings (Martijn Tonies) 0000581: [MySQL Module] Debugger SQL errors when using Float/Decimal values with specific regional settings (Martijn Tonies) 0000582: [InterBase Module] entering generator value (Martijn Tonies) 0000592: [General] Import CSV: should use text open file dialog with Encoding selector (Martijn Tonies) 0000593: [General] Ability to select the data grid font, so users can use their own specific Unicode font (Martijn Tonies) 0000597: [Compare & Migration] Migrating Blob (Domain) from Firebird to InterBase fails on "segment size" (Martijn Tonies) 0000477: [Compare & Migration] Database Compare wizard ignores the setting regarding column position "Ignore column position" (Martijn Tonies) 0000500: [General] Can't edit descriptions of Trigger (Martijn Tonies) 0000501: [General] Date editor doesn't use local date settings (Martijn Tonies) 0000526: [General] Misc small issues (Martijn Tonies) 0000535: [General] Running a script fails with no error messages on certain combination of settings (Martijn Tonies) 0000549: [Firebird Module] Dependencies (Martijn Tonies) 0000594: [General] Install GNU Unifont as part of the setup and use this font as default in the code editors (Martijn Tonies) 0000601: [General] First version of support for SQL Insight in Trigger Editors (Martijn Tonies) 0000602: [General] First version of support for SQL Insight in Stored Function Editor and Stored Procedure Editor (Martijn Tonies) 0000604: [MySQL Module] "SQL Indication" in Stored Procedure/Function Editor doesn't fill on existing routines with "no sql" indicator (Martijn Tonies) 0000608: [Firebird Module] Error with specific sequence in creating a computed by field (Martijn Tonies) 0000609: [InterBase Module] Error with specific sequence in creating a computed by field (Martijn Tonies) 0000610: [Firebird Module] NUMERIC computed by fields sometimes have incorrect precision (Martijn Tonies) 0000611: [MySQL Module] can't create Database like "test-test23" (Martijn Tonies) 0000612: [Firebird Module] Some metadata changes sometimes fail because of transaction isolation of metadata statements (Martijn Tonies) 0000613: [InterBase Module] Some metadata changes sometimes fail because of transaction isolation of metadata statements (Martijn Tonies) 0000470: [Sybase SQL Anywhere Module] Plan Analysis in SQL Editor locks up application (Martijn Tonies) 0000437: [Firebird Module] Create SUID procedure - wrong type with BLOB fields (Martijn Tonies) 0000439: [General] Misc small issues (Martijn Tonies) 0000440: [Oracle Module] Extracting TYPE definition lists Schema name in "TABLE OF" clause despite option not to include schema name (Martijn Tonies) 0000449: [InterBase Module] Interbase module in 4.3.1: Tab order in server registration wrong (Martijn Tonies) 0000447: [Data Import & Export] Oracle NUMBER fails export to XML (Martijn Tonies) 0000473: [General] Clicking Plan Analysis in the Procedure Editor without a procedure raises an access violation (Martijn Tonies) 0000476: [General] Large text blobs cause SQL Editor to hang because of hints and auto-edit (Martijn Tonies) 0000478: [Oracle Module] INTEGER becomes NUMBER (floating point) but should be NUMBER(38) (Martijn Tonies) 0000480: [Oracle Module] Columns with object type have schema name included despite "no schema name" option during Extract DDL (Martijn Tonies) 0000481: [General] Stored Procedure/Function Editors Parameter length reset (Martijn Tonies) 0000483: [InterBase Module] Create SUID procedure - wrong type with BLOB fields (Martijn Tonies)