You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Diljeet Dhillon (JIRA)" <ji...@apache.org> on 2008/04/17 00:15:21 UTC
[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same
column name specified twice
[ 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.