[
https://issues.apache.org/jira/browse/HAWQ-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ming LI resolved HAWQ-322.
--------------------------
Resolution: Fixed
> 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)
