Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Sat, 5 Feb 2011 07:36:30 +0000 (UTC)
From: "C.S. Nirmal J. Fernando (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1897228617.1524.1296891390762.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <973346945.1517.1296891150749.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] Updated: (DERBY-5004) Typo in column name
 "HASH_KEY_COLUMN_NUMBER" in SYSXPLAIN_SCAN_PROPS system table documentation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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>

> 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>

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira