1. Derby
  2. DERBY-4190

Incorrect example for SYSCS_DIAG.CONTAINED_ROLES in the reference manual


    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s:
    • Fix Version/s:
    • Component/s: Documentation
    • Labels:


      The example for SYSCS_DIAG.CONTAINED_ROLES in the reference manual does not work.

      The example looks like this:

      There are two problems:

      1) the table needs an alias (for instance, append AS T1), otherwise this error is raised:
      ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 56.
      Issue the 'help' command for general information on IJ command syntax.
      Any unrecognized commands are treated as potential SQL commands and executed directly.
      Consult your DBMS server reference documentation for details of the SQL syntax supported by your server.

      2) the name of the role should be a string (needs single quotes), not an identifier, otherwise this error is raised:
      ERROR 42X04: Column 'READER' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'READER' is not a column in the target table.

      1. docs.diff
        1 kB
        Bryan Pendleton
      2. rrefsyscsdiagtables.html
        18 kB
        Bryan Pendleton


        Knut Anders Hatlen created issue -
        Bryan Pendleton made changes -
        Field Original Value New Value
        Assignee Bryan Pendleton [ bryanpendleton ]
        Bryan Pendleton made changes -
        Attachment docs.diff [ 12424736 ]
        Attachment rrefsyscsdiagtables.html [ 12424737 ]
        Bryan Pendleton made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s [ 12313727 ]
        Resolution Fixed [ 1 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12461852 ] Default workflow, editable Closed status [ 12800231 ]


          • Assignee:
            Bryan Pendleton
            Knut Anders Hatlen
          • Votes:
            0 Vote for this issue
            0 Start watching this issue


            • Created: