[jira] Commented: (DERBY-765) Valid query fails with ERROR X0A00: The select list mentions column 'A' twice...

2006-07-26 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-765?page=comments#action_12423684 ] Rick Hillegas commented on DERBY-765: - Here's a release note for this issue: PROBLEM Derby raises an error for queries with the following profile: o The

Re: [jira] Commented: (DERBY-765) Valid query fails with ERROR X0A00: The select list mentions column 'A' twice...

2006-07-26 Thread Army
Rick Hillegas (JIRA) wrote: WORKAROUND: You can work around this limitation by rewriting your query so that the SELECT list does not alias an expression to the same name as another column or alias. The following rewritten query works fine: select a+1 as a, a+1 as c from myTable group by b;

Re: [jira] Commented: (DERBY-765) Valid query fails with ERROR X0A00: The select list mentions column 'A' twice...

2006-07-26 Thread Rick Hillegas
Hi Army, Thanks for catching this. No, you're not missing anything. I was experimenting with problem queries and didn't correct this one. Thanks, -Rick Army wrote: Rick Hillegas (JIRA) wrote: WORKAROUND: You can work around this limitation by rewriting your query so that the SELECT

[jira] Commented: (DERBY-765) Valid query fails with ERROR X0A00: The select list mentions column 'A' twice...

2006-07-26 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-765?page=comments#action_12423690 ] Rick Hillegas commented on DERBY-765: - Re-entering the release note to correct a problem with the previous version, found by Army. Here's a release note for