db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C.S. Nirmal J. Fernando (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-5004) Typo in column name "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system table documentation
Date Sat, 05 Feb 2011 07:38:30 GMT

     [ 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

        

Mime
View raw message