Kuien Liu created HAWQ-1557:
-------------------------------
Summary: DROP TABLE IF EXISTS issues ERROR report
Key: HAWQ-1557
URL: https://issues.apache.org/jira/browse/HAWQ-1557
Project: Apache HAWQ
Issue Type: Bug
Components: DDL
Reporter: Kuien Liu
Assignee: Radar Lei
We may re-produce it with following scripts. Open three PSQL consoles and
submit them concurrently, then we may find DROP TABLE IF EXISTS issues an ERROR
report, it defiles the common sense.
Session 1:
postgres=# DROP TABLE IF EXISTS tbl;
NOTICE: table "tbl" does not exist, skipping
DROP TABLE
postgres=# CREATE TABLE tbl (id serial, date text, time text, status bool,
sample1 float, sample2 float, volume int) DISTRIBUTED BY (id);
NOTICE: CREATE TABLE will create implicit sequence "tbl_id_seq" for serial
column "tbl.id"
CREATE TABLE
postgres=# INSERT INTO tbl (date, time, status, sample1, sample2, volume)
SELECT current_date, localtime, (random() > 0.5)::bool,
trunc(random()::numeric, 8), trunc(random()::numeric, 8), v FROM
generate_series(1, 1202200) as v;
INSERT 0 1202200
Session 2:
postgres=# DROP TABLE IF EXISTS tbl;
DROP TABLE
Session 3:
postgres=# DROP TABLE IF EXISTS tbl;
ERROR: relation "tbl" does not exist (tablecmds.c:1534)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
