[DERBY-568] ERROR 42Y07: Schema 'SchemaName' does not exist. But Schema already present in sql sentence

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.1.0
• Component/s: SQL
• Labels: derby_triage10_5_2
• Environment: Win XP prof, Java SDK 1.4.2_06, Derby 10.1.1.0
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Igor Azarny
• Created: 14/Sep/05 17:40
• Updated: 15/Feb/11 21:08

Description

Here files with short remarks to reproduce error
/****************** create.bat **********************/
java org.apache.derby.tools.ij derby.sql > create-schema.log
java org.apache.derby.tools.ij derby-data.sql > init-data.log
/****************** end create.bat **********************/

/****************** derby.sql **********************/
connect 'jdbc:derby:c:\data\test;create=true;databaseName=test';
create schema lcp;

CREATE TABLE lcp.transportgrp (
transportgrp_id INTEGER GENERATED ALWAYS AS IDENTITY,
name VARCHAR(128) NOT NULL,
moddate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
moduser VARCHAR(32) NOT NULL DEFAULT USER,
CONSTRAINT transportgrp_pk PRIMARY KEY (transportgrp_id)
);
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireAuthentication','true');
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.authentication.provider','BUILTIN');
– DEFAULT USERS –
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.ADMIN', 'admin');
/****************** end derby.sql **********************/

/****************** derby-data.sql **********************/
connect 'jdbc:derby:c:\data\lcpdb;user=ADMIN;password=admin';

insert into lcp.transportgrp(name) values('test 1');
insert into lcp.transportgrp(name) values('test 2');
insert into lcp.transportgrp(name) values('test 3');

– this sql will be passed
select * from lcp.transportgrp where lcp.transportgrp.name = 'test 2';

– this will be failed, but this select does not contains errors
– the same sql run correctly on versions before 10.1.1.0
select * from lcp.transportgrp where transportgrp.name = 'test 2';

– this will be passed also
select * from lcp.transportgrp a where a.name = 'test 2';
/****************** end derby-data.sql **********************/