[jira] [Assigned] (HAWQ-322) Drop tablespace problem: doesn't check database/relations in some cases

["Ming LI (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ming LI reassigned HAWQ-322:
----------------------------

    Assignee: Ming LI  (was: Lei Chang)

> Drop tablespace problem: doesn't check database/relations in some cases
> -----------------------------------------------------------------------
>
>                 Key: HAWQ-322
>                 URL: https://issues.apache.org/jira/browse/HAWQ-322
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: Ming LI
>            Assignee: Ming LI
>
> This defect includes 2 test cases with 2 bugs. 
> Case 1:
> create tablespace myts filespace dfs_system;
> create DATABASE dbinmyts TABLESPACE myts;
> \c postgres
> drop TABLESPACE myts;
> \c dbinmyts
> create table t1 (i int ) tablespace dfs_default;
> ERROR:  lookup failed for tablespace 64127 (tablespace.c:1127)
> Case 2: The last statement doesn't report error.
> postgres=# create filespace fs0 ON hdfs ('localhost:9000/fs0');
> CREATE FILESPACE
> postgres=# create tablespace tsinfs0 filespace fs0;
> CREATE TABLESPACE
> postgres=# create tablespace tsinfs1 filespace fs0;
> CREATE TABLESPACE
> postgres=# create table tableinfs1(i int) tablespace tsinfs1;
> CREATE TABLE
> postgres=# drop tablespace tsinfs1;
> ERROR: tablespace "tsinfs1" is not empty
> postgres=# begin transaction ISOLATION LEVEL SERIALIZABLE;
> BEGIN
> postgres=# create table tableinfs0(i int) tablespace tsinfs0;
> CREATE TABLE
> postgres=# drop tablespace tsinfs0;
> DROP TABLESPACE



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)