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

'show indexes in SCHEMANAME' does not work with the client driver

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.2.0, 10.3.1.4
    • 10.2.2.1, 10.3.1.4
    • Network Client, Tools
    • None

    Description

      The ij command 'show indexes in SCHEMANAME' does not work at all with the client driver.
      It does work with the embedded driver.

      Sample output from ij:
      ij> connect 'jdbc:derby://localhost/myDB;create=true';
      ij> create table test (id int primary key);
      0 rows inserted/updated/deleted
      ij> show indexes in app;
      ERROR XJ103: Table name can not be null
      ij> show indexes from test;
      TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
      ----------------------------------------------------------------------------
      TEST |ID |0 |3 |A |NULL |NULL

      1 row selected
      ij> show indexes from app.test;
      TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
      ----------------------------------------------------------------------------
      TEST |ID |0 |3 |A |NULL |NULL

      1 row selected
      ij>

      Using delimited table and/or schema names does not work, but I think this is according to documentation.
      I.e.:
      ij> show indexes from "TEST";
      ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
      ij> show indexes from "APP".test;
      ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
      ij> show indexes from "APP"."TEST";
      ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
      ij>

      Attachments

        1. DERBY-2222-1.diff
          13 kB
          Jorgen Loland
        2. DERBY-2222-1.stat
          0.5 kB
          Jorgen Loland
        3. DERBY-2222-2.diff
          23 kB
          Jorgen Loland
        4. DERBY-2222-2.stat
          0.7 kB
          Jorgen Loland
        5. DERBY-2222-3.diff
          24 kB
          Jorgen Loland
        6. DERBY-2222-3.diff
          24 kB
          Jorgen Loland
        7. DERBY-2222-3.stat
          0.7 kB
          Jorgen Loland
        8. DERBY-2222-3.stat
          0.7 kB
          Jorgen Loland
        9. derby-2222-4a-javadoc_whitespace.diff
          7 kB
          Kristian Waagan
        10. ijMultipleResultSetResult.java
          3 kB
          Jorgen Loland

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              jorgenlo Jorgen Loland
              kristwaa Kristian Waagan
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: