[HAWQ-1639] Unexpected internal error when truncate and alter in a transaction

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.0.0-incubating
• Fix Version/s: backlog
• Component/s: Core
• Assignee: Radar Da Lei
• Reporter: TaoJIn
• Created: 09/Jul/18 01:24
• Updated: 25/Jul/18 09:36

Description

hdb=# select version();
                                                                                                      version                                                    
                                                 
------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
 PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.3.0.0-incubating build dev) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (R
ed Hat 4.8.5-16) compiled on May  4 2018 06:27:27
(1 row)

hdb=# begin;
BEGIN
hdb=# select * from test limit 2;
         a         
--------------------
 asdfsdgrtecvxbfgdh
 asdfsdgrtecvxbfgdh
(2 rows)

hdb=# truncate table test;
TRUNCATE TABLE
hdb=# select * from test limit 2;
 a
—
(0 rows)

hdb=# alter table test add column b varchar(20) default '';
ALTER TABLE
hdb=# commit;
ERROR:  Unexpected internal error (appendonlywriter.c:525)
hdb=# rollback;
WARNING:  there is no transaction in progress
ROLLBACK
hdb=#