[DERBY-5004] Typo in column name "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system table documentation

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 10.8.1.2
• Component/s: Documentation
• Assignee: Nirmal Fernando
• Reporter: Nirmal Fernando
• Created: 05/Feb/11 07:32
• Updated: 17/Jun/13 09:19
• Resolved: 05/Feb/11 15:26

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>

• Link to the document: http://db.apache.org/derby/docs/10.6/ref/rrefsysxplain_scan_props.html