db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-5004) Typo in column name "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system table documentation
Date Mon, 07 Feb 2011 16:35:30 GMT

    [ 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

        

Mime
View raw message