Oracle SQL Developer 1.5.4: Bugs Fixed
Date: March 2009
Oracle SQL Developer 1.5.3 and 1.5.4. are primarily
translation releases, with 1.5.3 supporting Japanese and 1.5.4 supporting
the additional languages Spanish, Italian, German, French, Brazilian Portuguese,
Simplified Chinese and Korean. These two releases also incorporate a number
of bug fixes. This list of bug is a combination of fixes in both 1.5.3
and 1.5.4 and is not all-inclusive. It includes the main bugs
fixed that did not make it into SQL Developer 1.5.1 release. For the list
of bugs fixed between SQL Developer 1.5.0 and SQL Developer 1.5.1, please
see the SQL Developer 1.5 Bugs Fixed
list.
This list includes a selection of:
- Higher priority bugs
- Customer bugs reported using Metalink
- Issues reported by the community on the forum
- General
- Reported as fixed for 1.5.3
- 7355899: Performance issues on opening tables nodes
- 6877752: Clicking find tools in external tools displaying registry
exception
- 7243750: Drop table purge
- 6828106: Functions not displaying return type
- 7243714: Navigator: indicate public/private programs in package
body
- 7243766: Performance monitoring
- 5162861: Persist last directory for all os interactions
- 5165109: Tree menu not in sync when doing 'find' in a package
- 7243755: Sort connections & create groupings
- 6802528: Cannot handle identifiers that begin with a dollar
sign
- 7261683: Apex import fails for special characters
- Additional 1.5.4 Fixes
- 7355899 Bad performance opening tables nodes
- 7695380 Database diff > lower-cased column name > don't
have double quote in diff result
- 7695302 Database diff can not diff the table comment.
- 7677735 Diff wizard > diff lower case table - miss double
quote in result
- 7025674 Hangs when working with CLOB columns
- 7592162 Hostname is half displayed in the new/select database
connection dialog box.
- 7162048 Import data wizard prompts loading table 3 times after
clicking cancel
- 7717260 NLS: Manage db option fails on NLS parameter change
- 8267971 Query breaks export
- 7592100 SQL History displays only types of scripts and not
sql
- 7555808 Exception displayed in the console when starting SQL
Developer in win64 platform
- Browser
- Reported as fixed for 1.5.3
- 7246678: Add the ability to refresh a materialized view
- 5214770: Included alphabetical ordering of functions / procedure
in package
- 7243076: Include alphabetical ordering of functions / procedure
in package
- 7310936: View does not show other users columns
- 7151518: Grant > privileges - loading dialog box flashes
3 times after being cancelled
- Additional 1.5.4 Fixes
- 7261683 APEX import fails for special characters
- 7512507 Can't browse materialized view under other users
connection
- 8279405 Can't see the synonym for materialized view in list
- 8249391 Popup describe : schema names are case sensitive
- 7700449 Slow loading for the views metadata from objects
browser
- 7666178 Triggers not displayed for other users
- Connections
- Reported as fixed for 1.5.3
- 6945271: Connection drop lists are sorted,
but not case insensitive sort
- 7206476: Disconnect after creating & browsing
pl/sql objects- shows exception
- 6836296: MAC: new connection dialog too small
for connect button
- 5362733: Network alias not populated from "tnsnames.ora"
in Citrix environment
- 7044022: Not using tns_admin or ldap_admin
to find ldap.ora
- 7044273: Wildcard used when searching for .ora
files
- 7387779: Proxy user objects are not listed
in connection navigator
- Additional 1.5.4 Fixes
- 7704342 Auto connect on connection selection drop list in worksheet
- 6837457 Changing connection on worksheet does not change title
bar
- 7602362 Connection type as TNS, network alias will show same
the TNS name several times
- 8273675 LDAP connection fail while using OCI driver
- 7044022 Not using tns_admin or ldap_admin to find ldap.ora
- 7600304 On upgrade, some connection types are changed
- 8265022 Prompted for password on run/debug with unsaved password
- 8253136 Proxy connection info is not editable
- 6774587 Security: advanced connections aren't encrypted
- 7704324 Use keys to select item in connection selection
- Create and Modify
- Reported as fixed for 1.5.3
- 6817124: Import data : unable to import date using XLS
- 7440901: Error thrown when adding to folder->new folder selected
for a db connection
- 7031876: Single row sub query returns more than one row - view
breaks and no data shows
- Additional 1.5.4 Fixes
- 7112791 APEX: currency symbols incorrectly imported
- 7306357 Can't recreate same xml schema after running dbms_xmlschema.deleteschema
- 6995794 Copy wizard: create procedure containing & not handled
- 7038924 Create unique index on table fails and drops table
- 7674108 Dragging table into worksheet form other user; schema
not included
- 6847255 MAC: copy starts, doesn't end, error goes to java stack
- 7031876 Single row sub query returns more than one row - view
breaks and no data shows
- SQL Worksheet
- Reported as fixed for 1.5.3
- 7132408: Import data wizard - could not run script in worksheet
- 7481915: Refactor: display compile errors in worksheet
- 6282052: Select with joins causes sql developer to loop
- 7478137: Separator: german group separator
- Additional 1.5.4 Fixes
- 7036740 Closing unshared worksheet prompts for save twice
- 7828714 Code insight gives errors on typing rowid in worksheet
- 7534902 Database copy hangs while copying data large tables.
- 7265163 Deadlock on pressing the execute statement button
- 7700139 Describe (shift f4) only works for your own tables
not schema.table
- 6848224 Describe f4 fails on users tables on 9i db, and some
v$ objects
- 7666638 Invalid data in table data display
- 7040155 Keyboard accelerators needed for sql history
- 7599313 NLS: garbled multi byte message in script output
- 6968076 Pause statement not working
- 7655884 Schema diff says constraints are differences when
they are not
- 7481193 Spool command in worksheet does not write results
to the file
- 7540998 SQL Worksheet not appearing when '#' in the windows
username
- 8239038 Start or @ file.sql does not check last opened directory/file.sql
- 8279269 Unable to run a script file with @@ calling other
files
- 7037434 Unshared worksheet launch prompts inconsistently
for password
- Data
- Reported as fixed for 1.5.3
- 7203623: Date and timestamp columns are not showing up in sql
dev 1.5.1
- 6860918: Sorting on table with duplicate column names throws
exceptions
- Additional 1.5.4 Fixes
- 7132326 Can not display data with single quote in it
- 7515681 Can't browse data in BFile edit panel
- 7240969 Data tab's filter is not persisted
- 7712583 Error entering a null value in a number column
- 7344539 Error when sorting columns that require double quotes
- 7421863 Viewing data of olap_table view gives "rowid":
invalid identifier error
- PL/SQL
- Reported as fixed for 1.5.3
- 7463068 probe debugging does not work
- 7389123: Collapse icons don't show
- 7172737: Exception after opening PL/SQL editor and then disconnecting
the connection
- 7374927: Long lines in pl/sql source are broken on 4000 char
boundary
- 7389109: Some code templates don't work
- Additional 1.5.4 Fixes
- 8250324 VISTA: Debugger host for database debugging proposes
IP address 0.0.0.0 for vista
- 7389109 Code template #user# don't work in pl/sql editor
- Preferences
- Reported as fixed for 1.5.3
- 6956545: PL/SQL compiler options: incorrect syntax near the
keyword alter
- 7279723: Preference -> migration
- 7140108: Inappropriate spacing on certain options: = >
instead of =>
- Additional 1.5.4 Fixes
- 7148222 some formatter options cause replace and procedure name
to be concatenated
-
Migrations and Third Party
- Reported as fixed for 1.5.3
- 7319302: Convert to oracle model -- dialog hang in converting
status
- 7488958: Dieresis (#) characters are removed from column names
- 2407737: Line number is wrong in the log window/message when
the parser fails
- 7132629: Microsoft Access exporter tools are not functioning
- 4586853: Online character scanner
- 2148973: Sybase 11 hanging when mapping foreign keys
- 6979432: Print statement with var substitution not translated
correctly
- 2389603: Sys columns not migrated
- 2389594: Update-statements with inline views are not migrated
correctly
- 2523564: User defined data types should be migrated to packages-types
- 3285753: Warning message migrating a sybase procedure to oracle
reported by workbench
- Additional 1.5.4 Fixes
- 2257699 Calling a procedure using a variable to hold the procedure
name
- 8258458 Click cancel when associating repository will removes
all package with md_%
- 6844341 Duplicate column name error reported on translated
ms access query
- 2141159 Map removes closing " on view name with spaces
- 2638876 More than one access built-in-function as default
can't be parsed
- 7155159 MySQL> offline datamove - run oracle_ctl got table
does not exist error
- 7605467 MySQL migration:bit[n] date type missed in set data
map dialog
- 6945225 No context menu to rename third party connections
- 7626613 No drop option for trigger and sequence in captured
and converted model
- 7831232 nvarchar(max) captured as nvarchar(0)
- 6082599 Quick migrate - does not check privileges granted
via a role
- 7013320 Remove migration repository also removes all user
objects with md_%
- 8261477 Run the generated DDL script throws error for cross
referenced tables
- 3375453 Solution needed for "a column may not be out-joined
to a subquery"
- 8230250 Sybase 15 index detail '<column name> desc'
not handled
- 915713 Sybase cursor directly mapped when simple assignment
is required.
- 7605486 Sybase migration: missing data type in set data map
dialog
- 1902272 Sybase:precedence problems with % which becomes mod()
in pl/sql
- 7635749 Sybase:primary key will not be captured if capture
single table with foreign key
- 6853258 Table name is prefixed with some numbers when dropping
it from captured model
- 3377663 Temporary tables defined using local variables fail
to generate
- 2696196 t-sql parser inserts extraneous table name prefix
in 'for update of' clause
- 7696219 user defined types basetype often longsysname instead
of varchar2
- Import and Export
- Reported as fixed for 1.5.3
- 7442419: Export problem with ( . )
- 7265123: Not able to import data containing character such
as quotes (''') and comma (,)
- 7287259: Result panel> export data - throws ora00904 error
- 7154185: Data import wizard, cannot proceed beyond step 1
of 4
- 7136086: Import data from XLS hangs
- Additional 1.5.4 Fixes
- 8286026 Database copy wizard throws errors when table/column
name is in mixed case
- 7322676 Dots are used as value separator when doing insert
export
- 7304338 Error in the console during import data for tables
- 7706547 Error on export is attempted with simple alias
- 7524946 Error when export includes dependent objects
- 7835138 Export data is reordering columns in alphabetical
order
- 7577549 Export DDL fails for some applications in SQL Developer
- 7644208 Export to txt in 'query result', the order of column
and output are inconsistent
- 8278585 Header row with empty or formula cells causes import
to fail
- 7700152 Import fails on a very wide and large XLS
- 7607194 Import from CVS -Changing first data type changes
all data types
- 7197687 Import from XLS fails ...
- 8249063 Import varchar data will fail because it automatically
add a comma
- 7656527 Table > export data: lower case letter in column
names are not preserved
- 7656516 Table > export data: lower case table name fails
- 8197735 Wrong data imported from excel
- Reports
- Reported as fixed for 1.5.3
- 7271134: Add ash row source report
- 7327107: Add encrypted table spaces to report in sql developer
- 7271163: Add more reports for monitoring the database
- Additional 1.5.4 Fixes
- 7022690 Legend in charts no longer readable - x-axis value
is now vertical
- 7557649 Manage data report needs to be closed before it can
be run for a new connection
- 7559629 Order by date error in "daily ash statistics
chart"
|
Bookmark
