[
https://issues.apache.org/jira/browse/DERBY-5004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
C.S. Nirmal J. Fernando updated DERBY-5004:
-------------------------------------------
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
was:
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>
> Typo in column name "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system
> table documentation
> -----------------------------------------------------------------------------------------------
>
> Key: DERBY-5004
> URL: https://issues.apache.org/jira/browse/DERBY-5004
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Reporter: C.S. Nirmal J. Fernando
> Assignee: C.S. Nirmal J. Fernando
> Priority: Trivial
>
> 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
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
