Derby
  1. Derby
  2. DERBY-5004

Typo in column name "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system table documentation

    Details

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

      Description

      ij> CONNECT 'jdbc:derby:myDb;create=false';
      ij> select HASH_KEY_COLUMN_NUMBER from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
      ERROR 42X04: Column 'HASH_KEY_COLUMN_NUMBER' 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 'HASH_KEY_COLUMN_NUMBER' is not a column in the target table.
      ij> select HASH_KEY_COLUMN_NUMBERS from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
      HASH_KEY_COLUMN_NUMBERS
      --------------------------------------------------------------------------------------------------------------------------------
      NULL

      1 row selected
      ij>

      1. derby-5004.diff
        0.5 kB
        Nirmal Fernando

        Activity

        Nirmal Fernando created issue -
        Nirmal Fernando made changes -
        Field Original Value New Value
        Description ij> CONNECT 'jdbc:derby:myDb;create=false';
        ij> select HASH_KEY_COLUMN_NUMBER from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        ERROR 42X04: Column 'HASH_KEY_COLUMN_NUMBER' 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 'HASH_KEY_COLUMN_NUMBER' is not a column in the target table.
        ij> select HASH_KEY_COLUMN_NUMBERS from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        HASH_KEY_COLUMN_NUMBERS
        --------------------------------------------------------------------------------------------------------------------------------
        NULL

        1 row selected
        ij>
        Nirmal Fernando made changes -
        Description ij> CONNECT 'jdbc:derby:myDb;create=false';
        ij> select HASH_KEY_COLUMN_NUMBER from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        ERROR 42X04: Column 'HASH_KEY_COLUMN_NUMBER' 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 'HASH_KEY_COLUMN_NUMBER' is not a column in the target table.
        ij> select HASH_KEY_COLUMN_NUMBERS from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        HASH_KEY_COLUMN_NUMBERS
        --------------------------------------------------------------------------------------------------------------------------------
        NULL

        1 row selected
        ij>
        ij> CONNECT 'jdbc:derby:myDb;create=false';
        ij> select HASH_KEY_COLUMN_NUMBER from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        ERROR 42X04: Column 'HASH_KEY_COLUMN_NUMBER' 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 'HASH_KEY_COLUMN_NUMBER' is not a column in the target table.
        ij> select HASH_KEY_COLUMN_NUMBERS from (MY_SCHEMA.SYSXPLAIN_SCAN_PROPS NATURAL RIGHT OUTER JOIN MY_SCHEMA.SYSXPLAIN_RESULTSETS) where STMT_ID = 'a13ec033-012d-a987-d37e-000002c23230';
        HASH_KEY_COLUMN_NUMBERS
        --------------------------------------------------------------------------------------------------------------------------------
        NULL

        1 row selected
        ij>

        * Link to the document: http://db.apache.org/derby/docs/10.6/ref/rrefsysxplain_scan_props.html
        Nirmal Fernando made changes -
        Attachment derby-5004.diff [ 12470347 ]
        Dag H. Wanvik made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 10.8.0.0 [ 12315561 ]
        Resolution Fixed [ 1 ]
        Rick Hillegas made changes -
        Fix Version/s 10.8.1.1 [ 12316356 ]
        Fix Version/s 10.8.1.0 [ 12315561 ]
        Rick Hillegas made changes -
        Fix Version/s 10.8.1.2 [ 12316362 ]
        Fix Version/s 10.8.1.1 [ 12316356 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12544646 ] Default workflow, editable Closed status [ 12802749 ]

          People

          • Assignee:
            Nirmal Fernando
            Reporter:
            Nirmal Fernando
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development