Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4957

describe and show commands failed to execute in Eclipse Plugin

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Eclipse Plug-in
    • Labels:
      None
    • Environment:
      Eclipse Ganymede (3.4) - Eclipse IDE for Java EE Developers
      Build id: I20080617-2000

      Windows XP Professional

      Dell OPTIPLEX 755
    • Urgency:
      Normal
    • Bug behavior facts:
      Wrong query result

      Description

      Reproduce Steps:
      1. Install Derby plugin to Eclipse
      2. Connect to Derby database
      3. Create a SQL file
      4. Execute "show schemas;" statement — Execution failed and syntax error message "Encountered "show" at line 1, column 1." showed in status panel.
      5. Execute "describe task;" statement — Execution failed and syntax error message "Encountered "describe" at line 1, column 1." showed in status panel. Note: task is the table name.

      Note:
      1. It seems that show and describe commands can not be recognize by the SQL Engine of Eclipse Derby plugin.
      2. commands create, drop, select, update, delete, insert work well

        Attachments

        1. Derby_ShowCommandFailed.jpg
          43 kB
          Bruce Wen

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              wengm Bruce Wen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: