db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4838) dblook outputs GRANT statements for ignored tables
Date Thu, 07 Oct 2010 09:27:31 GMT

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

Knut Anders Hatlen commented on DERBY-4838:
-------------------------------------------

This bug also makes dblook_test and dblook_test_territory output the following error:

FAILED: to execute cmd from DDL script:
GRANT SELECT("'Single' and ""double"" quoted column name") ON "'Single' and ""double"" quoted
schema name"."'Single' and ""double"" quoted table name" TO "SOMEONE"
Schema ''Single' and "double" quoted schema name' does not exist

The tests try to execute the DDL statements produced by dblook, but fail because the table
in the GRANT statement is an ignored table, and the corresponding CREATE TABLE statement has
not been executed. When this bug is fixed, the GRANT statement should not be printed and executed,
and the error message must be removed from the test canons.

> dblook outputs GRANT statements for ignored tables
> --------------------------------------------------
>
>                 Key: DERBY-4838
>                 URL: https://issues.apache.org/jira/browse/DERBY-4838
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.7.0.0
>            Reporter: Knut Anders Hatlen
>
> dblook has an option that allows the user to specify which tables to produce DDL statements
for:
>  	-t <tableOne> <tableTwo> ... to specify a list of tables for which
>  	 the DDL will be generated; any tables not in the list will be ignored.
> However, GRANT statements for privileges on tables not in that list will still be printed.

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