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: [jira] Commented: (DERBY-18) Exposed name matching has bugs when the column name is qualified with a schema name.
Date Tue, 15 Feb 2005 15:58:28 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">
I tried the previously failing create view statement on DB2 that I have
access to. DB2 matches the new behaviour.... View creation passes with
the schema name qualification and fails without. Derby has had issues
in the past, getting confused between current schema and the schema of
the object during compilation.<br>
<br>
But I am not sure if this behavior is desirable. The new behavior has
the schema name in the front for error messages that the user did not
specify. Can cause confusion to users.<br>
<br>
&nbsp;ij&gt; select * from test.s ss (c1, c2, c3, c4) where exists (select <b>ss.i
</b>from test.tt);<br>
-ERROR 42X04: Column <b>'SS.I' </b>is not in any table in the FROM
list or it appears within a join specification and is outside the scope
of the join specification or it appears in a HAVING clause and is not
in the GROUP BY list.&nbsp; If this is a CREATE or ALTER TABLE statement
then 'SS.I' is not a column in the target table.<br>
+ERROR 42X04: Column <b>'APP.SS.I'</b> is not in any table in the FROM
list or it appears within a join specification and is outside the scope
of the join specification or it appears in a HAVING clause and is not
in the GROUP BY list.&nbsp;&nbsp;&nbsp; If this is a CREATE or ALTER TABLE statement
then 'APP.SS.I' is not a column in the target table.<br>
<blockquote cite="mid4210E5BA.1050303@debrunners.com" type="cite">
  <pre wrap="">Anyone else have any comments on this patch, was the view in dml162
being created incorrectly before? The view has been modified from the
original NIST code, so maybe it was always a hidden bug in Cloudscape.

Dan.


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

Mime
View raw message