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
