--
-- ALTER_TABLE
-- Add column for empty table, type test
--
set time zone 'PRC';
--
--
CREATE TABLE TESTTABLE_tbl
(
D_ID int,
D_W_ID int,
D_NAME varchar(10),
D_STREET_1 varchar(20)
)
with(orientation = column)
;
COPY TESTTABLE_tbl FROM STDIN;
alter table TESTTABLE_tbl add column d6 decimal(64,10) default null;
SELECT DISTINCT d6 FROM TESTTABLE_tbl;
 d6 
----
   
(1 row)

DROP TABLE TESTTABLE_tbl;
--
--
create table TESTTABLE_tbl
(
D_ID int, 
D_W_ID int, 
D_NAME varchar(10), 
D_STREET_1 varchar(20) 
) 
with(orientation = column) 
;
-- rows number is (56, 64), and then touch this bug
copy TESTTABLE_tbl from STDIN;
delete from TESTTABLE_tbl;
alter table TESTTABLE_tbl add column d11 decimal(32,10) not null;
drop table TESTTABLE_tbl;