DTP SQL Dev Tools Galileo Plan

← Back to DTP Galileo Planning

Status

• Created September 4, 2008
• Added Sybase SQL Dev Tool/Enablement related features and bugzilla entries, 9/7/2008.

General Themes and Priorities

• SQL Query Builder work continues (pending resource availability)
  • The following items should be considered...
    • Improve Core UI (http://bugs.eclipse.org/202596)
    • SQL Support: Comment Handling (http://bugs.eclipse.org/202602)
    • DTP Enablement: SQL Dialect Support/Extensibility (http://bugs.eclipse.org/202592)
    • DTP Enablement: Enablement for exemplary database (http://bugs.eclipse.org/202593)
    • SQB: Error message logged when condition added (http://bugs.eclipse.org/217690)
    • SQB: Column names do not appear when launched from editor (http://bugs.eclipse.org/220431)
    • SQB: Minimize dependencies for packaging in a RCP application (http://bugs.eclipse.org/225009)
    • SQB: Easy access to Database Objects (http://bugs.eclipse.org/202597)
    • Properties pane (http://bugs.eclipse.org/202598)
    • Integration with DTP SQl Editor (http://bugs.eclipse.org/202590)
    • DTP Enablement: Variables Support (http://bugs.eclipse.org/216556)
    • SQL Support: Quoted Identifiers (http://bugs.eclipse.org/202601)
    • SQL Support: Qualified and Unqualified Names (http://bugs.eclipse.org/202603)
    • SQL Support: SQL Execution (http://bugs.eclipse.org/202604)
    • SQL Support: Subquery Support (http://bugs.eclipse.org/202605)
    • SQL Support: Union, Intersect, Except (http://bugs.eclipse.org/202606)
    • SQB: Define and implement connection strategy (http://bugs.eclipse.org/206756)
    • SQB: Duplicate parameter added (http://bugs.eclipse.org/229229)
    • SQB: exception thrown when running SQL including parameter (http://bugs.eclipse.org/231982)

• Multi-page SQL Schema Editor Framework & exemplary implementations for Sybase ASA in enablement project(pending resource availability)
  • The following items should be considered...
    • Multi-page Schema Editor GUI Framework and the generic preference pages
    • Concrete exemplary schema implementations for Sybase ASA including the following (pending resource availability)
      • Table Schema Editor
      • Index Editor
      • Stored Procedure editor
      • User Defined Function editor
      • User Defined Type editor
      • Constraint/Rule editor

• SQL Editor Framework/SQL File related bug fixing (Sybase)
  • http://bugs.eclipse.org/252005 (P2) (M5) -- UI code should be separated from editor.core plugin
  • http://bugs.eclipse.org/221362 (P3) (M5) -- poor error handling in datatools when browser can't be started
  • http://bugs.eclipse.org/217923 (P3) (M5) -- Editor does not inherit from STD text editors - specifically tabs
  • http://bugs.eclipse.org/241618 (P3) (M5) -- Error logged when save and close a scrapbook to a sql file
  • http://bugs.eclipse.org/244682 (P3) (M5) -- SQL Statement Editor cannot save the content
  • http://bugs.eclipse.org/246180 (P3) (M5) -- SOE:Lost line focus after saving
  • http://bugs.eclipse.org/237037 (P3) (M5) -- postgresql code assist didn't work in SQL File Editor
  • http://bugs.eclipse.org/220318 (P3) (M5) -- sql editor opens by default
  • http://bugs.eclipse.org/185501 (P3) (M5) -- execute current statement
  • http://bugs.eclipse.org/171718 (P3) (M7) -- Overloading Function names
  • http://bugs.eclipse.org/199353 (P3) (M7) -- RoutineEditor to open different SQL Objects with same name
  • http://bugs.eclipse.org/170602 (P3) (M7) -- SQL Editor auto format
  • http://bugs.eclipse.org/244180 (P3) (M7) -- SQLToolsFacade doesn't recognise SQL server versions correctly

• SQL Results view bug fixing (Sybase)
  • http://bugs.eclipse.org/221845 (P3) (M5) -- Inconsistent behavior on execution
  • http://bugs.eclipse.org/245484 (P3) (M5) -- Scrollbar doesn't work in the grid mode
  • http://bugs.eclipse.org/246106 (P3) (M5) -- ResultExportWizard throws NPE when outputter.output throws Exception
  • http://bugs.eclipse.org/231401 (P3) (M5) -- Show the elapsed run time of a SQL

• SQL Query Plan view bug fixing (Sybase; no bugs so far)

• Sybase Enablement project related bugs
  • http://bugs.eclipse.org/213390 (P3) (M5) -- Sybase enablement plug-ins should be refactored for UI/non-UI separation
  • http://bugs.eclipse.org/105625 (P3) (M7) -- MySQL SQL formatter uppercase table names

Work Items

• Individual BZ entries