You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2011/01/13 20:03:45 UTC
[jira] Updated: (DERBY-3868) dblook generates SET SCHEMA null and
fails to produce correct schema for view
[ https://issues.apache.org/jira/browse/DERBY-3868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-3868:
---------------------------------
Affects Version/s: 10.0.2.0
10.0.2.1
10.1.1.0
10.1.2.1
10.1.3.1
10.2.1.6
10.2.2.0
10.3.1.4
10.3.2.1
10.3.3.0
10.4.1.3
10.4.2.0
10.5.1.1
10.5.2.0
10.5.3.0
10.6.1.0
10.6.2.1
10.7.1.1
Module the authorization parts of the above comments, the weaknesses can be seen back to Derby 10.0.
> dblook generates SET SCHEMA null and fails to produce correct schema for view
> -----------------------------------------------------------------------------
>
> Key: DERBY-3868
> URL: https://issues.apache.org/jira/browse/DERBY-3868
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1
> Reporter: Dag H. Wanvik
> Attachments: reproscript-auth.sh, reproscript.sh
>
>
> Scenario: One user creates a table, another user creates a view of the first user's table.
> dblook output show below (reproscript.sh uploaded).
> > -- Timestamp: 2008-09-04 18:43:33.186
> > -- Source database is: wombat
> > -- Connection URL is: jdbc:derby:wombat;user=dag;password=wanvik
> > -- appendLogs: false
> >
> > -- ----------------------------------------------
> > -- DDL Statements for schemas
> > -- ----------------------------------------------
> >
> > CREATE SCHEMA "DAG";
> >
> > CREATE SCHEMA "KNUT";
> >
> > -- ----------------------------------------------
> > -- DDL Statements for tables
> > -- ----------------------------------------------
> >
> > CREATE TABLE "DAG"."T" ("I" INTEGER);
> >
> > -- ----------------------------------------------
> > -- DDL Statements for views
> > -- ----------------------------------------------
> >
> > SET SCHEMA null;
> > create view v as select * from dag.t;
> >
> > -- Reverting back to default schema 'APP'
> > SET SCHEMA "APP";
> The SET SCHEMA null is illegal and the view "v" is not correctly
> qualified with its schema name ("KNUT").
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.