You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Gerard Dellemann (Jira)" <ji...@apache.org> on 2019/09/16 08:19:00 UTC
[jira] [Commented] (METAMODEL-1217) Drop table doesn't work for
views with JDBC Tables
[ https://issues.apache.org/jira/browse/METAMODEL-1217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16930317#comment-16930317 ]
Gerard Dellemann commented on METAMODEL-1217:
---------------------------------------------
The PR has been merged, the issue can be set to done?
> Drop table doesn't work for views with JDBC Tables
> --------------------------------------------------
>
> Key: METAMODEL-1217
> URL: https://issues.apache.org/jira/browse/METAMODEL-1217
> Project: Apache MetaModel
> Issue Type: Bug
> Reporter: Gerard Dellemann
> Priority: Minor
> Time Spent: 50m
> Remaining Estimate: 0h
>
> A JdbcTable is a MutableTable. A MutableTable can have different TableType including TABLE and VIEW.
> The JdbcDropTableBuilder (line 69) builds a SQL Statement to drop tables:
> {code:java}
> "DROP TABLE " + tableLabel
> {code}
> This doesn't work if the MutableTable has TableType VIEW. Then it should be:
> {code:java}
> "DROP VIEW " + tableLabel
> {code}
> I haven't investigated this issue for other types of datastores. Only for JDBC.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)