[
https://issues.apache.org/jira/browse/DERBY-5004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991447#comment-12991447
]
Kim Haase commented on DERBY-5004:
----------------------------------
Thanks, Nirmal and Dag.
Many tables in the documentation have columns whose text is unreadable in the
PDF. The text column is narrow, but even using the full page width would not
help in many cases. I don't know of any way to fix the problem (i.e. to make
the text wrap within a word). The tables do look fine in the other two output
formats.
> 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
> Fix For: 10.8.0.0
>
> Attachments: derby-5004.diff
>
>
> 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
