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

'set schema sys' followed by 'show tables' does not show tables in sys schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.2.2.0, 10.3.1.4
    • Component/s: Tools
    • Labels:
      None

      Description

      If you create a new database in IJ, followed by 'set schema sys' and then 'show tables', ij shows no tables in the schema. This is because ij's show tables command only shows system tables if a schema is provided.

        Attachments

        1. ij_showalltables.diff
          0.7 kB
          Samuel Andrew McIntyre
        2. derby-2030-v1.diff
          6 kB
          Samuel Andrew McIntyre

          Activity

            People

            • Assignee:
              fuzzylogic Samuel Andrew McIntyre
              Reporter:
              fuzzylogic Samuel Andrew McIntyre
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: