db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Info of what fixes go into 10.1 release ?
Date Wed, 11 May 2005 06:57:52 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Bernd,<br>
<br>
Sorry, I promised to help complete this patch, but haven't been
providing much of a help. The patch as attached is not complete. As
Jack pointed out, we do need to raise error when there is an ORDER BY
on a correlation name that is ambiguous. For example,<br>
<br>
&gt; select i as a, j as a from t<br>
A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
A<br>
----------- -----------<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4<br>
&nbsp; 3 record(s) selected.<br>
&gt; select i as a, j as a from t order by a&nbsp;&nbsp;&nbsp; &lt;==
Needs to raise
error, as order by <b>a</b> could be refering to <b>i</b> or <b>j</b><br>
<br>
But<br>
&gt; select i, i, i from t order by i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;=== This
is OK, since all references to <b>i</b> point to same base column.<br>
<br>
Do you have time and interest to adjust the patch? We still have time
to submit this change to 10.1 release. There is active discussion on
when that release might happen.<br>
<br>
Satheesh<br>
&nbsp;<br>
Bernd Ruehlicke wrote:<br>
<blockquote
 cite="mid1B37BEFB3456F1428E01932AFA147822019BB815@HOUEXCH902.Landmark.lgc.com"
 type="cite">
  <pre wrap="">Hi there,

I added a patch to <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-147">http://issues.apache.org/jira/browse/DERBY-147</a>
 a
while ago.

I just want to know how I can figure out if this is making it into the
next release.
Do we have a site where we list what is going into the 10.1 release ?

Thanx
B-)

-----
I use Derby because I'm worth it



  </pre>
</blockquote>
</body>
</html>


Mime
View raw message