db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Diljeet Dhillon (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice
Date Wed, 16 Apr 2008 22:15:21 GMT

    [ https://issues.apache.org/jira/browse/DERBY-147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12589750#action_12589750
] 

Diljeet Dhillon commented on DERBY-147:
---------------------------------------

I will be out of the office on the 14/04/08, returning on the 17/04/08.
For any urgent issues, please contact one of my colleagues on ext 5355.

I will however respond to your message when I return.

Regards,

Diljeet Dhillon
The PCMS Group plc,
PCMS House
Torwood Close
Coventry
CV4 8HX

Tel: +44 (0) 24 7669 4455
Fax: +44 (0) 24 7642 1390

Email Address:  diljeet.dhillon@pcmsgroup.com
Corporate Website: - www.pcmsgroup.com

The Architecture Team promoting PCMS Values
~Integrity~Respect~Commitment~Continuous Improvement~

The information contained in this e-mail is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.  If you are not the
intended recipient of this e-mail, the use of this information or any disclosure, copying
or distribution is prohibited and may be unlawful.  If you received this in error, please
contact the sender and delete the material from any computer.  The views expressed in this
e-mail may not necessarily be the views of the PCMS Group plc and should not be taken as authority
to carry out any instruction contained.   The PCMS Group reserves the right to monitor and
examine the content of all e-mails.

The PCMS Group plc is a company registered in England and Wales with company number 1459419
whose registered office is at PCMS House, Torwood Close, Westwood Business Park, Coventry
CV4 8HX, United Kingdom. VAT No: GB 705338743





> ERROR 42X79 not consistant ? - same column name specified twice
> ---------------------------------------------------------------
>
>                 Key: DERBY-147
>                 URL: https://issues.apache.org/jira/browse/DERBY-147
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Bernd Ruehlicke
>            Assignee: Bryan Pendleton
>             Fix For: 10.2.3.0, 10.3.1.4
>
>         Attachments: derby-147-10.0.2.1.diff, derby-147.diff, patch_with_tests.diff
>
>
> This happens from JDBC or ij. Here the output form ij>
> ij version 10.0 
> CONNECTION0* - 	jdbc:derby:phsDB 
> * = current connection 
> ij> select a1.XXX_foreign, a1.native, a1.kind, a1.XXX_foreign FROM slg_name_lookup
a1 ORDER BY a1.XXX_foreign;
> ERROR 42X79: Column name 'XXX_FOREIGN' appears more than once in the result of the query
expression. 
> But when removing the ORDER BY and keeping the 2 same column names it works
> ij> select a1.XXX_foreign, a1.native, a1.kind, a1.XXX_foreign FROM slg_name_lookup
a1;
> XXX_FOREIGN                                                                     |NATIVE
                                                                         |KIND           
                        |XXX_FOREIGN                                                     
                -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
> 0 rows selected 
> ij> 
> So - it seams to be OK to specify the same column twice - as long as you do not add the
ORDER BY clause.  
> I woul dof course like that the system allows this - but at leats it should be consistant
and either allow both or none of the two queries above.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message