Oracle SQL Developer 2.1.1: Bugs Fixed

Date: March 2010

Bugs Fixed since Oracle SQL Developer 2.1 was released in December 2009.

Oracle SQL Developer 2.1.1. is a patch release. A patch release is a full and complete install with a focus on fixing issues not addressed in the main SQL Developer 2.1 release. As such there is no new functionality in the release. In this instance a number of minor feature requests on the SQL Developer Exchange have also been included, where they tie into the features included in the previous release or where they are related to bugs fixed in the path. A list of fixed bugs is included below.

The list of bugs shown below is not a complete list of issues or minor feature updates addressed in this patch, it contains a selection of:

  • Higher priority bugs
  • Customer bugs reported using Metalink
  • Issues reported by the community on the OTN Forum
  • Minor feature requests logged on the Exchange

Bugs Fixed List

  • Browser
    • 9203081 Cannot browse columns for foreign key and check constraints
    • 9385807 Java source tab shows different java source in some connections
    • 9393294 Other users tables - cannot see synonym
    • 9201088 Forum: Comments contain schema reference when option to show them is off
    • 9347307 Tables not included in tree when select_catalog_role is granted
  • Connect
    • 9355628 Forum:TNS entry list doubled due to multithreaded access to tnshelper
  • Create/Modify
    • 9200137 Forum: Drop constraint SQL is missing the table owner.
    • 9202526 Forum: Action button disappears when filter is too long
    • 9113440 Edit table dialog with inherited privileges
    • 9344872 Cannot create synonyms in other user's schemas
  • Data
    • 9403127 Can't update more than 1 row of blob in 1 commit
    • 9238312 Forum: Problem browsing table data when col name a number
    • 9362767 Forum: grid sorting can't be cancelled
    • 9238165 Forum: Data tab does not open for a table when same name public synonym present
    • 9192156 Double-click the list to remove filter will get invalid number
    • 9204372 Cannot insert data of interval day to second type
    • 8992440 Forum: jumping result sets
    • 9044739 Forum: paste into grid cell eats up quote chars
    • 9035886 Insert records and commit in data tab,in data editor -log order is not correct
    • 9205959 Forum: Setting data in grid cell make the scrollbar go to bottom
    • 9158124 Intermittent "stream has already been closed" viewing cols tab for tabs
    • 9389689 ctrl+home does not select first row
    • 9238364 View data for nested data type will show many sub dialogs in view data dialog
    • 9379438 With post edit on row change DML issued immediately after row insertion
  • Export
    • 9246364 Forum: Export to XLS is not working for a query
    • 9137379 Export data with hidden column, an extra comma was introduced
    • 9322168 Export data from navigator tree node functionality broken
    • 9200151 Could not export all columns in report
    • 9292881 Missing SQL tab in XLS file when exporting from resultset
    • 9205946 Object type showing in the data tab, should have quote for varchar
    • 9329939 Sample data in export wizard display nothing
    • 9154681 Database copy: lowered-cased table name will not copied correctly
    • 9242832 Adding more "" when taking out one column and set delimit as ;;
    • 9302833 Forum: Could not export the query result of keep (dense_rank...) function
    • 9162423 Could not export in pl/SQL object
    • 9242809 Set column delimiter in export wizard to null results incorrect
  • Installation
    • 9118902 Add xml files to userextensions folder in \sqldeveloper folder fails
    • 7555808 Exception displayed in the console when starting SQL Developer in win64 platform
    • 8502609 Exception displayed when starting SQL Developer in ipv6 environment
  • Migration
    • 9281594 Create view fails with Sybase outer join
    • 9257908 Data move fails: quotation mark used for object name is not correct
    • 9137543 Raiseerror converted incorrectly
    • 9193314 Schema name lost when translated in view
    • 6976327 Forum: Update join clause not translated correctly
    • 9191456 MS Access: Failed to move guid data offline
    • 9327104 Case sensitive MS SQL Server 2005: run offline capture script get invalid object name
    • 9168809 Sybase: Failed to unload table's data if table name contains white-spaces
    • 9348923 Sybase: Offline capture error: ora-00955
    • 9214091 Sybase/mySQL:fail to move data online if table name contains white-spaces
    • 9181879 Teradata:fail to move data online if table name contain white-space
    • 6655252 Side by side viewing/editing of captured/converted objects
    • 9205347 Export data tab for SQL Server included but does not work
  • PL/SQL
    • 9320685 Forum: PL/SQL objects in the other schemas not editable
    • 9299015 Debug procedures of other users hang with dialog 'connected to database..'
    • 9304463 Forum: Remote debug sessions not terminating
  • Reports
    • 9253844 Failed to add a child when creating a user defined report
    • 9206084 Pressing cancel when exporting report still export it
    • 9253847 Can't open reports with bind variables
    • 9084476 Testing report in create report dialog not working for SQL with binds
  • Unit Tests
    • 9236694 Forum: ut_test.object_call column not exported/imported
    • 9342438 Linux: loses the input parameters for implementations
    • 9317285 Forum: Open cell edit changes not picked up when using run/debug from toolbar
    • 9241182 'manager user' for lower-case user name fails
    • 9137004 Sorting report column scrolls results table to last row
    • 9346931 Unit Test Repos connection does not enable unit test roles
    • 8810928 Request rename delete options when right click unit test lookups category
  • Version Control
    • 9217448: Commit,add,update items for CVS are all disabled
  • Worksheet
    • 9287407 x.y fieldname does not show in query results
    • 9257691 Export data pivot key work in it - got no valid columns available for export
    • 9304402 Forum: SQL History not maintaining history and loses entries
    • 9222873 Forum: SQL History incorrect for F5
    • 9223009 Forum:extended ascii chars not persisted correctly by SQL History
    • 9238928 Forum: SQL History shortcut keys not working
    • 9247525 Forum: Worksheet results tab being pinned for f9 exec of selected SQL
    • 9182590 Script being logged as multiple SQL statements in SQL History
    • 9203660 Text delete from within a string literal when adding a line break
    • 9201619 Error when running create procedure containing / within multi-line literal
    • 9253703 Extra semicolon is added when re-executing the script in SQL History
    • 9322597 Fetch time shown in worksheet results tab toolbar should be cumulative
    • 9201580 Forum: Default path slowing down SQL Developer
    • 9177245 SQL History was not ordered by timestamp by default
    • 7251045 Forum: Accept default option does not work in worksheet
    • 6506986 Zero year date handled differently in SQL*Plus and worksheet in SQL Developer
    • 9015160 Forum: User guide column supports 'column...newval' only
    • 8868888 Shortcut key for code template removed (Placeholder added to shortcut keys)
    • 9327711 Use relative path from current file in spool command
    • 9301717 Run statement fails for qbe against dba_schedule_jobs in SQL dev 2.1
    • 9364437 F9 gives no output dba_scheduler_jobs
    • 9165946 Forum: Bind value of null under worksheet F9 not stored persistently
    • 9299984 F9 (run statement) does not allow select on dba_scheduler_jobs
    • 9206464 Forum: PL/SQL file extensions should go to the worksheet
    • 9238456 Forum: Select connection dialog should be presented when exec in worksheet with no conn

Requests from the SQL Developer Exchange Included

  • 8411043 : Commit confirmation
  • 8755723 : Copy column name to clipboard (ctrl - shift- C)
  • 8487257 : Do not use ora_rowscn (Request implemented using a preference)
  • 8487263 : Keyboard access to sub-tabs, SQL worksheet and results
  • 8487262 : Sort of huge resultsets
  • 9030307 : Move rowcount display
  • 8316080 : Ability to save table filter criteria when switching between table in schema
  • 8316066 : Cancel button in data grid
  • 8316213 : Column name selection
  • 8315770 : Column order in results undefined
  • 8315929 : Copy single column from a grid
  • 8316006 : Link a blob column with an external tool
  • 8316234 : Make right click copy and paste available
  • 8316078 : Save results window size
  • 8315793 : Use Keyboard to minimize result area
  • 8316203 : Copy and paste data from excel to table
  • 8316020 : Reinstate ability to drag columns to worksheet
  • 8315865 : Hot key to show/hide result grid
  • 8315875 : Print output from query in a separate thread
  • 8315877 : Quick way to open blob data for known type
  • 8315760 : Visualize PDF, doc... in blobs
  • 7243745 : Long running operations (long ops)
  • 9210696 : SQL History recall using ctrl up/down