Difference between revisions of "DTP SQL Dev Tools Galileo Plan"

Revision as of 00:00, 24 October 2008

← 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/210050 (P3)-- (Not delivered due to IBM's rejection)Collapse all virtual nodes when refresh is not a user friendly behavior.
  • http://bugs.eclipse.org/244093 (P1)-- INSERT statement followed by comment flag as error in SQL file Editor
  • http://bugs.eclipse.org/171718 (P2)-- Overloading Function names
  • http://bugs.eclipse.org/221362 (P2)-- poor error handling in datatools when browser can't be started
  • http://bugs.eclipse.org/228233 (P2)-- database server types not externalized
  • http://bugs.eclipse.org/170602 (P2)-- SQL Editor auto format
  • http://bugs.eclipse.org/196609 (P2)-- Cannot auto indent
  • http://bugs.eclipse.org/199353 (P2)-- RoutineEditor to open different SQL Objects with same name
  • http://bugs.eclipse.org/217923 (P1)-- Editor does not inherit from STD text editors - specifically tabs
  • http://bugs.eclipse.org/241618 (P1)-- Error logged when save and close a scrapbook to a sql file
  • http://bugs.eclipse.org/244682 (P1)-- SQL Statement Editor cannot save the content
  • http://bugs.eclipse.org/245494 (P1)-- SQL Editor should allow token matching
  • http://bugs.eclipse.org/246180 (P1)-- SOE:Lost line focus after saving
  • http://bugs.eclipse.org/242361 (P2)-- Column type "null" in CREATE TABLE results in NPE
  • http://bugs.eclipse.org/237037 (P2)-- postgresql code assist didn't work in SQL File Editor
  • http://bugs.eclipse.org/220318 (P2)-- sql editor opens by default
  • http://bugs.eclipse.org/201129 (P3)-- External Discouraged Access warnings in o.e.d.sqltools.common.ui
  • http://bugs.eclipse.org/130521 (P3)-- HCG_BIDI: Undesirable order of BiDi chars in SQL editor
  • http://bugs.eclipse.org/130522 (P3)-- HCG_BIDI: Undesirable order of BiDi chars in Run dialog
  • http://bugs.eclipse.org/130523 (P3)-- HCG_BIDI: Undesirable order of BiDi chars in duplicated BiDi conf. name
  • http://bugs.eclipse.org/134996 (P3)-- BiDi3.2: The text inside SQL editor window is right aligned.
  • http://bugs.eclipse.org/244577 (P3)-- SQL Editor incorrectly specifies version number for open connections
  • http://bugs.eclipse.org/192874 (P3)-- TVT33:TCT681: ar: Parenthesis incorrectly displayed

• SQL Results view bug fixing (Sybase)
  • http://bugs.eclipse.org/221845 (P1)-- Inconsistent behavior on execution
  • http://bugs.eclipse.org/185501 (P1)-- execute current statement
  • http://bugs.eclipse.org/245484 (P1)-- Scrollbar doesn't work in the grid mode
  • http://bugs.eclipse.org/246106 (P1)-- ResultExportWizard throws NPE when outputter.output throws Exception
  • http://bugs.eclipse.org/231401 (P2)-- Show the elapsed run time of a SQL
  • http://bugs.eclipse.org/212426 (P3)-- Comma(s) for results with more than 3 digits

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

• Sybase Enablement project related bugs
  • http://bugs.eclipse.org/213390 (P1)-- Sybase enablement plug-ins should be refactored for UI/non-UI separation
  • http://bugs.eclipse.org/245879 (P1)-- SQL generated by 'Edit' of stored procedure is not runnable
  • http://bugs.eclipse.org/105625 (P3)-- MySQL SQL formatter uppercase table names

Work Items

• Individual BZ entries