db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-568) ERROR 42Y07: Schema 'SchemaName' does not exist. But Schema already present in sql sentence
Date Tue, 06 Dec 2005 00:05:59 GMT
Igor Azarny (JIRA) wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-568?page=comments#action_12359275 ]

> 
> Igor Azarny commented on DERBY-568:
> -----------------------------------
> 
> I think this is a BUG.
> 
> 1.  At sql sentence "select * from lcp.transportgrp where transportgrp.name = 'test 2';"
schema name ALREADY present at from clause. So why we need to specify schema name where clause?
> 

And how should this be resolved if the current schema also had a table 
called "transportgrp"?  I am afraid it can create new sources of 
confusion if "tablename" not always map to "currentschema.tablename".

If you only want to specify the schema once, you can do:

select * from lcp.transportgrp t where t.name = 'test 2';

--
Øystein

Mime
View raw message