db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3868) dblook generates SET SCHEMA null and fails to produce correct schema for view
Date Mon, 15 Sep 2008 19:55:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12631117#action_12631117
] 

Dag H. Wanvik commented on DERBY-3868:
--------------------------------------

I notice that dblook_test.java does not test grant/revoke of privileges.

> 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
>            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.


Mime
View raw message