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

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.1.6, 10.3.1.4
    • 10.2.2.0, 10.3.1.4
    • Tools
    • 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. derby-2030-v1.diff
          6 kB
          Samuel Andrew McIntyre
        2. ij_showalltables.diff
          0.7 kB
          Samuel Andrew McIntyre

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: