db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice
Date Mon, 28 Feb 2005 22:12:30 GMT
On Mon, 28 Feb 2005 19:57:59 +0100 (CET), Bernd Ruehlicke (JIRA)
<derby-dev@db.apache.org> wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_59875 ]
> 
> Bernd Ruehlicke commented on DERBY-147:
> ---------------------------------------
> 
> Ok I made the changes and build Derby - and tested it - seams to work.
> 
> We may consider to make this change permanent.
> 
> Any reason for this error log was added ?
> 
> Here the code snipled (need to chnage getOrderBy(String, String) and getOrderBy(String,
String, int)
> 
> ...
>                        if (columnName.equals( resultColumn.getName()) )
>                        {
>                                if (retVal == null)
>                                {
>                                        retVal = resultColumn;
>                                }
> //      DERBY-147                               else if (index < size - orderBySelect)
> //      DERBY-147                               {
> //      DERBY-147                                       throw StandardException.newException(SQLState.LANG_DUPLICATE_COLUMN_FOR_ORDER_BY,
columnName);
> //      DERBY-147                               }
>                                else
>                                {// remove the column due to pullup of orderby item
>                                        removeElement(resultColumn);
>                                        decOrderBySelect();
>                                        break;
>                                }
>                        }
> ...
> 

Hi,

Don't know why the system was coded to throw exception for duplicate
columns but it seems like it has been around in Cloudscape from very
beginning.

Mamta

Mime
View raw message