List of items new/enhanced/fixed

Product: Database Workbench - version: 2.8.9

Item#CategoryDescription
#749 (Feature)Firebird ModuleComplete Firebird 2.0 support
#842 (Feature)PrintingNeed a way to print editor contents
#763 (Feature)Schema CompareSuppress default character set during comparison
#263 (Feature)Schema MigratorMigrate Foreign Keys for ODBC drivers that support it
#845 (Enhancement)Data Export/ImportSlow CSV import with large numbers of columns
#871 (Enhancement)Firebird ModuleRunning scripts without "set term"
#585 (Enhancement)GeneralNo longer clear the parameter history in the SQL Editor unless the (number of) parameters has changed
#588 (Enhancement)GeneralBLOB editor does not work on last record
#693 (Enhancement)GeneralAbility to save Stored Procedure/Function parameters for run/debug
#703 (Enhancement)GeneralAbility to delete items from the procedure parameter history on Run/Debug procedure
#741 (Enhancement)GeneralSP Debugging/run parameters history improvements
#773 (Enhancement)GeneralAbility to extract table DDL without primary key constraint
#790 (Enhancement)GeneralMake INSERT/OVERWRITE mode visual by changing caret (cursor) when on a character
#805 (Enhancement)GeneralAbility to reset "fetch all" setting when starting the application
#40 (Enhancement)InterBase ModuleRunning scripts without "set term"
#932 (Enhancement)MS SQL ModuleTable Editor supports editting default of existing columns
#792 (Enhancement)MySQL ModuleSupport for the BOOLEAN synonym for TINYINT(1)
#884 (Enhancement)MySQL ModuleAbility to set connecting characterset for MySQL 4.1 and up
#752 (Bug)Data Export/ImportExport Data in dbase format - values not correct when there's an auto-inc column
#764 (Bug)Data Export/ImportCSV import chokes on optional " text enclose character
#801 (Bug)Data Export/ImportCSV export has double quotes around NULL values
#802 (Bug)Data Export/ImportXML data export fails with "file in use"
#876 (Bug)Data Export/ImportImporting using TAB as a column delimiter fails on empty fields
#892 (Bug)Data Export/ImportExporting negative integers to .dbf changes the value to 0.
#913 (Bug)Data Export/ImportExported date format (standard SQL) for INSERT statements in MySQL is incorrect
#914 (Bug)Data Export/Import"Next" button doesn't become enabled after selecting DWX file to save in Export Multiple Tables
#744 (Bug)DataPumpCommand line datapump fails to connect to source database despite correct parameters
#814 (Bug)DataPumpEnabling/disable indices fails on dialect 1 databases
#828 (Bug)DataPump"database" box for MS SQL is too narrow
#861 (Bug)DataPumpIt appears that a single source column can be assigned to multiple destination columns, but this fails.
#905 (Bug)DataPumpProblem when grouping all actions in a single transaction
#686 (Bug)Firebird ModuleTriggers named CHECK<something> won't show
#760 (Bug)Firebird ModuleDebugger returns timestamp as float
#766 (Bug)Firebird ModuleRemoving NULL flag/default from columns fails on mixed case tables
#775 (Bug)Firebird ModuleStored Procedure syntax check/debug hangs
#806 (Bug)Firebird ModuleUDFs with BLOB as the return argument generate faulty DDL
#809 (Bug)Firebird ModuleExternal functions DDL sometimes incorrect, editor can't handle all cases.
#811 (Bug)Firebird ModuleAccess violation when removing UDF argument from Editor
#826 (Bug)Firebird ModuleDebugger doesn't support [NOT] STARTING WITH outside SQL statements
#869 (Bug)Firebird ModuleWhen duplicating a table, the duplicated primary key object has the same name as it's original if not editted before saving
#908 (Bug)Firebird ModuleTRIM not recognized in Stored Procedure debugger/syntax check
#922 (Bug)Firebird ModuleDebugger fails on cast date to certain char length, while Firebird runs just fine
#944 (Bug)Firebird ModuleError viewing of last BLOB in BLOB editor and moving through them
#946 (Bug)Firebird ModuleStored Procedure Plan Analysis fails on some FOR EXECUTE STATEMENT statements
#977 (Bug)Firebird Modulepage sizes for "new database" and "restore database" are different
#277 (Bug)GeneralCreating a PK by using checkboxes in the Table Editor for an existing table doesn't show a PK-object
#684 (Bug)GeneralNo copy/paste popup menu in edit parameter values dialog
#692 (Bug)GeneralWhen debugging a select-able Stored Procedure, 1 extra row is returned
#707 (Bug)GeneralMemory leak in query parameter cache in SQL Editor
#740 (Bug)GeneralMemory leak in "available database connections" for each server registration
#745 (Bug)GeneralBLOB Editor small bugs
#761 (Bug)GeneralExternal Functions in COMPUTED BY columns not found by Search or Dependencies
#776 (Bug)GeneralClosing the application on a multi-monitor system may cause a startup failure once monitor is removed
#784 (Bug)GeneralThe bottom Data panel is sometimes hidden when opening a new SQL Editor
#787 (Bug)GeneralColumns not being resized in Visual Query Builder query test results
#788 (Bug)GeneralStatus panel shows highlighted (blue) 'Create database ...' icon and text when it should not do this.
#831 (Bug)GeneralExtract DDL for Procedures including DROP returns faulty DDL for InterBase & Firebird
#836 (Bug)GeneralGrant manager doesn't provide feedback on failed grants and doesn't refresh properly for failed grants
#837 (Bug)GeneralRefresh List on Tables won't create a "primary key" object assigned to the table
#846 (Bug)GeneralWarning when deleting all rows doesn't mention table name
#883 (Bug)GeneralWhen duplicating objects, the DDL isn't recorded when using the statement recorder
#933 (Bug)GeneralSQL Server's Data path is wrong
#941 (Bug)GeneralSelecting "Debug" from the popup menu in the Navigator raises Access Violation
#952 (Bug)GeneralSQL Insight doesn't double quote field names with spaces/special characters
#980 (Bug)GeneralSQL Insight fails inserting text properly when "in context"
#685 (Bug)InterBase ModuleTriggers named CHECK<something> won't show
#759 (Bug)InterBase ModuleDebugger returns timestamp as float
#767 (Bug)InterBase ModuleRemoving NULL flag/default from columns fails on mixed case tables
#774 (Bug)InterBase ModuleStored Procedure syntax check/debug hangs
#807 (Bug)InterBase ModuleUDFs with BLOB as the return argument generate faulty DDL
#810 (Bug)InterBase ModuleExternal functions DDL sometimes incorrect, editor can't handle all cases.
#812 (Bug)InterBase ModuleAccess violation when removing UDF argument from Editor
#827 (Bug)InterBase ModuleDebugger doesn't support [NOT] STARTING WITH outside SQL statements
#870 (Bug)InterBase ModuleWhen duplicating a table, the duplicated primary key object has the same name as it's original if not editted before saving
#923 (Bug)InterBase ModuleDebugger fails on cast date to certain char length, while InterBase runs just fine
#970 (Bug)InterBase Modulepage sizes for "new database" and "restore database" are different
#709 (Bug)MS SQL ModuleSQL Editor doesn't always return a resultset for EXEC <procedure> while it should.
#734 (Bug)MS SQL ModuleNot possible to connect to a Sqlserver 6.5 database.
#739 (Bug)MS SQL ModuleTrigger source parse fails on certain triggers, source mangled
#882 (Bug)MS SQL ModuleRefresh List on Indices causes error on SQL 2005
#897 (Bug)MS SQL ModuleSQL2005: Block when using "Options" on a database that the user used in server registration doesn't have access to
#898 (Bug)MS SQL ModuleGetting server user information fails when "Windows Authentication" is used without proper permissions
#899 (Bug)MS SQL ModuleBrowsing for a folder raises "cannot find xp_available_media"
#900 (Bug)MS SQL ModuleSQL error after attaching database with numerical name or a name that includes special characters
#926 (Bug)MS SQL ModuleWrong Primary Key is shown for Primary Key-less table
#934 (Bug)MS SQL ModuleIn SQL 2005, numerical defaults have brackets around them
#945 (Bug)MS SQL ModuleSometimes an invalid COLLATE clause is included for columns with a custom type
#702 (Bug)MySQL ModulePlan analysis in SQL Editor doesn't get cleared between queries
#736 (Bug)MySQL ModuleMySQL Object Templates are missing
#758 (Bug)MySQL ModuleMySQL: Check & Repair Tables fails to open when there are corrupt tables
#804 (Bug)MySQL ModuleAdding/removing a parameter from a stored function doesn't do the "changed" state
#825 (Bug)MySQL ModuleFetching indices raises "field 'table_name' not found" on table "STATUS"
#838 (Bug)MySQL ModuleDropping a table from the Navigator can sometimes cause a "table does not exist" error
#841 (Bug)MySQL ModulePrimary key metadata sometimes lists wrong columns
#894 (Bug)MySQL ModuleGrant manager doesn't show grants for tables and views
#895 (Bug)MySQL ModuleGrant manager doesn't list grants for mixed case functions and procedures
#957 (Bug)MySQL Moduledeleting an account in usermanager deletes the wrong one visually, but correct on server
#765 (Bug)NexusDB ModuleCharacter string default on SHORTSTRING datatype not quoted
#777 (Bug)NexusDB ModuleNexusDB extension "EMPTY" for DEFAULT isn't handled
#778 (Bug)NexusDB ModuleDate/Time defaults should be prefixed by their type
#796 (Bug)NexusDB ModuleAdding/removing a parameter from a stored function doesn't do the "changed" state
#916 (Bug)NexusDB ModuleException on "Data" tab in Stored Function Editor if the function updates tables
#917 (Bug)NexusDB ModuleCannot use input parameters of type "GUID" in Stored Procedure or Function Editor on "Results" tab
#737 (Bug)Oracle ModuleRefresh List on Triggers won't add new triggers
#797 (Bug)Oracle Module"delete all rows" from Navigator doesn't work if it's not in your schema
#803 (Bug)Oracle ModuleSaving Stored Procedure returns assertion error/list index out of bounds
#839 (Bug)Oracle ModuleALTER trigger in trigger editor can fail with "table or view does not exist" if the table is not in your schema
#890 (Bug)Oracle ModuleAccess violation when saving a new package
#891 (Bug)Oracle ModuleList index out of bounds when opening editor for certain invalid Stored Functions
#906 (Bug)Oracle ModuleIndex-Organized system generated overflow tables (named: SYS_ something) are shown
#907 (Bug)Oracle ModuleBUFFER POOL storage attribute not in DDL for non-new tables
#947 (Bug)Oracle ModuleMemory leak for Tablespace and Rollback segment objects
#896 (Bug)PrintingObject description not printed for NexusDB objects
#974 (Bug)PrintingOracle "description" will never be printed
#795 (Bug)Schema Comparedatabase compare report fields in different order but cannot correct or stop report
#816 (Bug)Schema CompareComparing "default" for a column isn't done according to the Schema Migrator mapping, this results in differences
#817 (Bug)Schema CompareWhen PK-names differ in case, results are "constraint not found in source", which is incorrect
#853 (Bug)Schema CompareAccess violation while collecting change script
#931 (Bug)Schema Comparechanged default constraints not exported
#706 (Bug)Schema MigratorInterBase/Firebird BLOB to Oracle conversion raises Assertion Error
#956 (Bug)Schema Migratornot valid integer value error raised during migration from Oracle to Firebird or InterBase
#930 (Bug)Test Data GeneratorRandom Values: Between X and Y -> Y is skipped


Total of 122 items.