[ 
https://issues.apache.org/jira/browse/HAWQ-1639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Radar Lei updated HAWQ-1639:
----------------------------
    Affects Version/s: 2.3.0.0-incubating
        Fix Version/s:     (was: 2.3.0.0-incubating)
                       backlog
          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=#


  was:

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=#



> Unexpected internal error when truncate and alter in a transaction
> ------------------------------------------------------------------
>
>                 Key: HAWQ-1639
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1639
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 2.3.0.0-incubating
>            Reporter: TaoJIn
>            Assignee: Radar Lei
>            Priority: Major
>             Fix For: backlog
>
>
> 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=#



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to