Ming LI created HAWQ-322:
----------------------------
Summary: 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: Lei Chang
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)
