|
Oracle Enhanced Support
------------------------------
1. Visual Editing storage support for Tables, Indexes and Clusters.
2. Scripting support for storage for Tables (CREATE (Full)), Indexes (CREATE) and Clusters (CREATE).
3. Auto-Completion: support for PUBLIC synonyms in the table list
SQL Server 2005 Enhanced Support
------------------------------
1. Schema Browser: Added folders for Synonyms, System Views, Assemblies, XML Schema Collections, Asymmetric Keys, Certificates and Symmetric Keys
2. Schema Browser: Added Schema name to objects in Datatypes, Rules and Defaults
3. Added schema folder to schema browser in database objects
Enhanced Grid Results
------------------------------
1. Column width and height are now calculated using the font metrics, which allows more flexible font settings.
2. Ability to highlight rows by selecting row columns.
3. Ability to select all cells in a column by clicking on column with CTRL hit pressed.
4. Added secondary column sorting capability.
Added Option in File->Options:Grid Results[Copy to clipboard as default]. When coping numeric data to the clipboard,
the numeric values will be copied completely instead of the formatted value is results format in case the format truncates data.
Table Data Editor
------------------------------
1. File->Options->General:Table Data Editor - Option to disable transaction requirements for table data editor. Some Informix databases might have transactions disabled. User may disable transaction requirements at own risk.
2. Added status bar which displays the format pattern of the current selected cell. Pattern is no longer displayed in the cell when editing a NULL value.
Server Registration
------------------------------
1. Generic JDBC connections: When browsing file selection for drivers, user may now select multiple files at a time with Control-Click.
2. Oracle Connections: SID option: Service Name is now allowed by appending "SERVICE:" in front of the value, in which case ADS will use the new URL ServiceName format jdbc:oracle:thin:@//host:port/servicename.
3. Added button next to the Port field which will do a socket connection test on the host and port specified.
4. Username and Password may now be an external application which provides the username or password in the StdOut.
To specify an external application, wrap the value with a "~`" at the beginning and "`~" at the end of the value.
Example: On Windows, the username or password value can be ~`cmd /c more "%HOMEPATH%\username.txt"`~ where username.txt has the username or password in it.
Note: On Unix you may not execute scripts because the JVM has problems retreiving the StdOut when running a command shell (sh, bash), but binary executables work
5. Options:General: Added "SQL Server Quoted Identifier (Default)" and "Sybase Quoted Identifier (Default)" so the user may define the default value when registering a Sybase or SQL Server
Visual Editing
------------------------------
1. Visual Editing & Scripting for Storage & Security: Added quoted identifiers to SQL generation.
2. File->Options->Scripts: Added "Visual Editing Quote Identifier" option to enable/disable quote identifiers in SQL generation while using Visual Editing.
3. (MySQL 5): Added support for bit datatype
Query Analzyer Window/Editor
------------------------------
1. Window Tab: Added an animated icon to the tab of the query window when a query is executing.
2. Editor: Copy and Cut action when there is nothing selected will perform the action on the current line.
3. File->Options->Appearance:[Editor Background Color]: Added option to set the background color of the editor.
4. File->Options:Editor for coloring numerics. Default syntax color of numerics is magenta.
5. File->Options:Editor for enabling/disabling auto-brace matching. Default value is enabled.
6. File->Options->Results Format: Added the option of "[None]" so that the results are displayed in raw values.
7. Added CTRL-Y hot key to Delete Current Line
8. Added File->Options:General:Prompt for commit when auto-commit is OFF which will Determines whether the
application will prompt the user to commit if rows are modified and auto-commit is not enabled.
Dialog will also warn if an UPDATE or DELETE statement is executed without a WHERE clause.
9. Auto-Completion: Added support for SHOW CREATE TABLE <TABLENAME> Syntax
10. (SQL Server, Sybase, Sybase Anywhere, PostgreSQL, MySQL, Oracle) Query Window: Added Connection ID to window toolbar.
11. (Oracle) Query Window Auto-Describe: Added Table and Column Comments to description
12. (DB2) SQL Statement Execution. All "--" comments are removed from SQL statements except for CREATE PROCEDURE, FUNCTION and TRIGGER before execution regardless if they are client or server side comments
General Application
------------------------------
1. Application frame now saves maximized status when exiting and restores it at startup.
2. Status bar: Application status bar now contains the path that is selected in the schema browser
3. Servers that don't have their passwords saved. When a user connects and specifies a username
and password, ADS will now hold the username and password in memory until the user disconnects or closes
ADS. The username and password will be used when openning a query window, tool or scripting.
Schema Browser
------------------------------
1. Added ability to rename a Server connection in the Server Properties
2. Added the following Key Bindings to the schema browser functionalities: CTRL-INSERT: Connect,
CTRL-DELETE: Disconnect, SHIFT-INSERT: Register Server Clone, ALT-ENTER: Server Properties,
ENTER: Will expand/collapse current node
3. (PostgreSQL): Added a Procedure folder to list functions with a VOID return.
4. (DB2): Support for Nicknames. Added support to schema browser and for DDL scripting.
5. (DB2): Added "Materialized View" node to display a list of Materialized Views and the columns and indexes of the views
6. (Sybase Any): added Events folder to support events.
|
|
Server Registration
------------------------------
1. Server Registration: Components on General Tab would not resize with the window size.
Import/Export Tool
------------------------------
1. Import/Export Tool: Average Row Time and Estimated time was calculated without fractions of a millisecond which had less time accuracy. Now time is calculated with 1/1000 of a millisecond accuracy.
2. Export Tool: When exporting a table (not a resultset) ADS will prequery (select count(*) from table) to get a total count of rows to be exported to make an exact estimate to completion.
3. Export Tool: Now does not right trim string values.
4. Import Tool: Now takes into consideration files which only use carriage returns to separate lines (Mac)
5. (Informix) Import/Export/Save Results - Changed date/datetime format to work under any DBDATE formatted connection
(ex: EXTEND(MDY(7,22,1999), YEAR to SECOND)+13 UNITS HOUR+59 UNITS MINUTE+0 UNITS SECOND)
6. (Informix) Import Tool: Importing into a datetime column, ADS would format the date with a trailing ".0" which would cause a syntax error.
7. (MySQL) Added "`Object Name`" quote identifier option to Import/Export tool, Script Generator and File->Options->Scripting
Script Browser
------------------------------
1. F5 would not refresh.
2. Did not have the ability to display files without an extension. In File->Options->General:Script Filters a "*" may be added to include files without extensions
Schema Browser
------------------------------
1. Drag-n-Drop of servers from groups to groups didn't work since the new Shortcut Toolbar.
2. Performance increase on expanding nodes with large lists. UI event update only fired once for all items, instead of firing event for each new node.
3. (Oracle): Script Constraint defintions, added support for Constraint state keywords ENABLE/DISABLE, RELY/NORELY and VALIDATE/NOVALIDATE
4. (Oracle): Previously didn't display tables based off of Object Types.
5. (Oracle): Extraction: NVARCHAR2 lengths were defined as byte length, not character length.
6. (Oracle): Extraction: Declared NUMBER datatype without precision or scale was scripting as (22,0) when it should be defined at all to define unlimited value.
7. (Oracle): Extract Trigger was not appending the WHEN clause
8. (Oracle): Optimized queries for folders Tables, Package Bodies, Package Functions & Procedures and Parameters.
9. (Oracle) Foreign Key constraint sometimes had double identical values.
10. (DB2): Converted almost all SYSIBM schema reference to SYSCAT references in extraction to better support DB2 variants other then DB2 for LUW(Linux/Unix/Windows)
11. (SQL Server 2005): Server Logs only contained date. Now has full log.
12. (SQL Server 2005): Schema names other then dbo(database owner) where not showing up. Changed from using USER_NAME() to SCHEMA_NAME() in 2005
13. (SQL Server): Script Procedure EXECUTE: Variable declarations didn't contain length, precision and scale
14. (SQL Server): Script CREATE TABLE: Binded defaults were not scripted as a separate bind statement.
15. (SQL Server): Script Generator the order of CREATE DEFAULT and CREATE TABLE were not in the correct order.
16. (Sybase) Extraction: In some cases Unique Constraints where not extracted.
17. (Sybase) Script Table CREATE(Full): If table would have more then one trigger, it would add the trigger create to the script more then once.
18. (Sybase) Index Scripting & Script Generator: Scripting Table w/ Indexes would generate CREATE INDEX for Indexes that were supporting constraints.
These indexes are automatically created and dropped with the constraint, so this is now removed.
19. (Sybase 11.5): Scripting Tables & Indexes didn't work because of lack of support for index_colorder() by Sybase 11.5
20. (Sybase): Constraint Scripting & Script Generator: Scripting Table w/ Constraints would generate CREATE INDEX for unique constraints.
21. (Sybase): Script CREATE TABLE: Binded defaults were not scripted as a separate bind statement.
22. (Sybase): Script Generator the order of CREATE DEFAULT and CREATE TABLE were not in the correct order.
23. (Sybase): Script CREATE Table now contains LOCK DATAROWS, ALLPAGES, DATAPAGES syntax.
24. (Sybase Anywhere): Script CREATE View, Trigger and Procedure would use the systriggers.trigdef and sysprocedure.defn catalog view to extract the trigger source instead of the systrigger.source and sysprocedure.source table. The source was
formatted slightly different. Source is now extracted from systrigger.source and sysprocedure.source
25. (Sybase Anywhere): Didn't take into consideration case sensitive schema owners. If user logged in as dba instead of DBA and
SybaseAny server was configured for case-sensitive comparisons objects would not be listed
26. (Sybase Anywhere 9): Unique and Check Constraints would script CREATE statements incorrectly under certain circumstances.
27. (Informix): Table Script CREATE definition. VARCHAR and NVARCHAR datatypes with reserve values (ex: VARCHAR(3,1)) would be scripted with incorrect length values.
28. (Informix): Script Table: Decimal and Floats didn't have precision/scale values.
29. (Informix 10): Extracting Table with columns having "default ''" would fail because Informix 10 stores it as NULL.
30. (Informix): Script Procedure/Function: Scripting Functions & Procedures with a script separator of ";" would include two ";" at the end of the CREATE statement.
31. (Informix): Extract Index: Informix 9.3 and above only supported 8 columns in index when up to 16 are supported.
32. (MySQL) Extraction: Procedure & Functions with 0 parameters where the parameter brackets have a space in between Example: "( )" would not extract
33. (MySQL) Scripting Table CREATE Full would generate an extra CREATE INDEX for the primary key.
34. (PostgreSQL): Script CREATE Table: Tables with varchar columns without column size definition would script as "varchar(-5)"
Save Results
------------------------------
1. XML Format: Added encoding for ><&"' characters
2. Saving to Excel Spreadsheet was limited to 32,767 rows. Increased to 65,536 and rows are broken up into sheets.
3. If data format of Excel is selected and the file browse is activated to select a file name without an extesion, .txt is appended to the file instead of .xls
4. HTML format of data didn't have a closing ">" on </FONT> terminator.
Grid Results
------------------------------
1. HTML Text values where rendered as HTML in the cell of the grid.
2. CTRL-Click on a column to select, where the columns were moved around would cause the wrong column to be selected.
3. Rearranging the column locations and then coping to clipboard would leave the data in the original order, but the headers in the new order.
4. Selecting all column values with CTRL-Click on column would not allow you to copy to clipboard
5. Copy to clipboard would add a line feed after last line.
Query Window
------------------------------
1. Query Panel now shows all databases in combo box, and are not filtered the same as the schema browser
2. Syntax Coloring: Single quoted strings incorrectly colored when preceeded by '-' (Ex: tdate-'01/01/2001')
3. Syntax Coloring: '|' would not terminate keywords and prevent coloring of the keyword.
4. Syntax Coloring: Comments of // and -- with a leading character word, the word would be colored as the comments.
5. Convert Binary to Hex: [File->Options->Results]: Blobs where not being converted to hex, only other binary datatypes
6. Query Results: Added seconds to the default format of and Time/DateTime datatypes
7. Cycling through tab windows with CTRL-TAB would not reset focus to editor
8. Executing a CallableStatement with .executeCallableQuery would not print out sql warnings.
9. Executing a statement when "Auto Commit" enabled, "Commit" and "Rollback" are not re-enabled after query completes.
10. Query statment with a "--" server side comment at the end of the statment would prevent "Execute Edit" from executing.
11. Script parser: Statement with a quoted string that contained a linefeed,GO,linefeed would be split into two statements
12. Auto-Completion where a column was in a function with more then one parameter would cause the auto-completion to always complete with tables.
13. (Oracle) Show Execution Plan on AutoCommit:disabled: Executing wouldn't warn user transaction would be commited if the Explain Plan needed to CREATE/DROP the plan_table
14. (Oracle): Oracle JDBC driver sometimes returns Date value for Timestamp column. ADS was returning Err.
15. (Oracle): Editing source of Procedures/Packages where a '?' was in a quoted string and a commnet block had a single quote (with no matching quote) would save the '?' as ':1'.
Disabled in Oracle JDBC driver EscapeParsing with Statement.setEscapeProcessing() to fix this issue.
16. (DB2) Syntax Coloring: Added keywords: MATCHED, OVER, PARTITION and Functions: ROW_NUMBER
17. (DB2): Syntax Coloring added for vendor keywords of ASSOCIATE, LOCATORS, IF, ELSEIF, LEAVE, LOOP, REPEAT, UNTIL, RESIGNAL, SIGNAL, WHILE, DO
18. (DB2 8.2): Query Execution: Stopped removing CR and LF from queries, because IBM fixed the bug in 8.1 where queries failed when statement
had a CR or LF in it. This allows the saving of formatted query text in CREATE VIEW.
19. (DB2 8.2): Stop removing CR/LF from queries in Visual Editing.
20. (SQL Server) If auto-on-all schemas was enabled and user was not database owner the description of the table would have the username as the schema name instead of dbo.
21. (SQL Server) Change Database in query panel and the schema browser would fail if "Set Quoted_Identifier" is disabled in the Server Properties.
22. (Sybase): Openning a query window with no database context selected in schema browser now sets database to the user default.
23. (SQL Server, Sybase, Sybase Any): Query Window Max Results affected UPDATE/INSERT statements row max modifications because of Driver bug. Workaround now fixes issue.
24. (Informix): Auto-commit being disabled would prevent the user to change the current database.
Table Data Editor
------------------------------
1. String results now do not get right trimmed.
2. (DB2) Enabled editing for LONG VARCHAR data types.
3. (DB2): Execute edit didn't extract primary key on a SELECT where schema name didn't match because of case sensitivity
4. (Oracle) SQL Generator for Date modifications now use TO_DATE('','YYYY-MM-DD HH24:MI:SS')
instead of TO_DATE('','YYYY-MM-DD HH12:MI:SS PM') to prevent a syntax error when running ADS in Japanese locale
5. (Sybase) Table Data Editor: If a SELECT is done on a table with no primary key or unique constraint, but has a unique index, ADS would not use it as a primary key.
Script Generator
------------------------------
1. Ordered the creating of constraints in order of Primary Key, Unique, Check and Foreign Key, and Dropping in reverse order.
2. Scripting Functions & Procedures with a script separator of ";" would include two ";" at the end of the CREATE statement.
3. Script Generator: Now sorting constraints by type, then name to make diffs of schemas easier to do.
4. (Oracle) Script Generator: Now includes the PUBLIC schema.
5. (Oracle) Script Generator: If a foreign key constraint was created on a reference table column which had an Index created on the column before the primary key constraint was created, then the reference column would not appear in the CREATE CONSTRAINT statement.
Visual Editing
------------------------------
1. Table Visual Editor: Changing datatype from VARCHAR to NVARCHAR (or vice versa) with the same length would not generate a change.
2. (DB2): Added support detailed error messages.
3. (SQL Server 2005): Database Visual Editing/Scripting: If a log file had a MaxSize = MAX_INT then the log file would not be included.
4. (MySQL) Now uses backtick quote identifier to support all naming conventions with database objects.
5. (PostgreSQL 8.1) Security Permissions: Added support for the new makeaclitem() signature so that permissions would be supported.
6. (Oracle) Profile Dialog: editing or viewing profile would not set the "Expire in" correctly.
Procedure Editor
------------------------------
1. The adding of "Save Query" made the procedure editor require a file to save to everytime a proc was compiled if there was no file defined.
2. A "--" client side comment in a quoted string would through off the parser.
3. (Oracle): Executing a procedure in a package with a parameter of type REF CURSOR would fail.
|
