[
https://issues.apache.org/jira/browse/DERBY-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13924246#comment-13924246
]
Mamta A. Satoor commented on DERBY-6361:
----------------------------------------
I will look further into following failure but after doing a merge to 10.10
codeline, when I compile the code using ant clobber, ant clean and ant all, ant
all gives following error
[javac]
C:\p4clients\svn10.10\client1\10.10\java\testing\org\apache\derbyTesting\functionTests\tests\lang\GeneratedColumnsTest.java:5640:
getSchemas() in java.sql.DatabaseMetaData cannot be applied to
(<nulltype>,java.lang.String)
[javac] JDBC.assertEmpty(conn.getMetaData().getSchemas(null, user));
[javac] ^
[javac]
C:\p4clients\svn10.10\client1\10.10\java\testing\org\apache\derbyTesting\functionTests\tests\lang\GeneratedColumnsTest.java:5659:
getSchemas() in java.sql.DatabaseMetaData cannot be applied to
(<nulltype>,java.lang.String)
[javac] JDBC.assertEmpty(conn.getMetaData().getSchemas(null, user));
[javac] ^
[javac] 2 errors
> Valid statements rejected if Derby has not implicitly created the current
> user's schema.
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-6361
> URL: https://issues.apache.org/jira/browse/DERBY-6361
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Reporter: Rick Hillegas
> Assignee: Mamta A. Satoor
> Fix For: 10.11.0.0
>
> Attachments: d6361-ignore-missing-schema.diff,
> derby-6361-01-aa-createDefaultSchema.diff
>
>
> There are many examples of statements failing because Derby has not
> implicitly created the schema associated with the current user. You don't see
> this if the schema is the default APP schema. But if the user is anyone other
> than APP, then various statements can fail. Maybe we should implicitly create
> a schema even if the user isn't APP. Right now, you get an error like this:
> ERROR 42Y07: Schema 'ROOT' does not exist
> The following script shows an example of this problem:
> connect 'jdbc:derby:memory:db;create=true;user=esq';
> create table licreq( domain varchar( 10 ) );
> connect 'jdbc:derby:memory:db;user=root';
> -- fails
> ALTER TABLE esq.licreq ADD COLUMN u_domain GENERATED ALWAYS AS
> (UPPER(domain));
> connect 'jdbc:derby:memory:db;user=app';
> -- succeeds
> ALTER TABLE esq.licreq ADD COLUMN u_domain GENERATED ALWAYS AS
> (UPPER(domain));
--
This message was sent by Atlassian JIRA
(v6.2#6252)
