Dong Li created HAWQ-231:
----------------------------
Summary: Alter table by drop all columns of it, then it has some
interesting problems
Key: HAWQ-231
URL: https://issues.apache.org/jira/browse/HAWQ-231
Project: Apache HAWQ
Issue Type: Improvement
Components: Storage
Reporter: Dong Li
Assignee: Lei Chang
It is a design behavior problem.
When we drop all the columns, should it truncate the table?
Otherwise if the count of invisible rows has meaning.
You can not see anything, but it shows that there are 1000 rows here.
I know that in storage view and design view it is ok.
But in user view, it may be puzzled.
{code}
intern=# create table alterall (i int, j int);
CREATE TABLE
intern=# insert into alterall VALUES
(generate_series(1,1000),generate_series(1,2));
INSERT 0 1000
intern=# alter table alterall drop COLUMN i;
ALTER TABLE
intern=# alter TABLE alterall drop COLUMN j;
ALTER TABLE
intern=# select * from alterall ;
--
(1000 rows)
intern=# alter TABLE alterall add column k int default 3;
ALTER TABLE
intern=# select * from alterall;
k
---
3
3
3
3
3
3
3
...
(1000 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
