Hi Tony, Would you fill a issue for better track and it's easier to attach logs and screenshots? Thanks.
https://issues.apache.org/jira/projects/HAWQ/issues/ Regards, Radar On Thu, Jul 5, 2018 at 4:19 PM, tao tony <tonytao0...@outlook.com> wrote: > Sorry for the screenshot not shown in the mail: > > 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=# > > > On 07/05/2018 04:17 PM, tao tony wrote: > > hi , > > We had found a bug in 2.3.0.0. > > It appeared when truncate and alter in the same transaction. > > Thanks! > > Tao Jin. > > > >
