Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1639

Unexpected internal error when truncate and alter in a transaction

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.0.0-incubating
    • Fix Version/s: backlog
    • Component/s: Core
    • Labels:
      None

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

        Attachments

          Activity

            People

            • Assignee:
              rlei Radar Lei
              Reporter:
              tonytao0505 TaoJIn
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: