[HAWQ-1838] Fix attribute typmod for CREATE TABLE AS SELECT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0.0
• Fix Version/s: 3.1.0.0
• Component/s: DDL
• Assignee: Zhenglin Tao
• Reporter: Zhenglin Tao
• Created: 20/Apr/22 09:04
• Updated: 06/May/22 09:42
• Resolved: 06/May/22 09:42

Description

The type modifier of CONST used to miss in optimized query plan.
    The following 2 schemas denote the fix before and after.

    create table test_create_as_select_const
        as select 2.333::decimal(10,2), 'haha'::char(5), 'hehe'::varchar(6);
    \d test_create_as_select_const

    Append-Only "public.test_create_as_select_const"
     Column  |       Type        | Modifiers
    -------{}++{}---------------{}{}---------
     numeric | numeric           |
     bpchar  | character(5)      |
     varchar | character varying |

    Append-Only "public.test_create_as_select_const"
     Column  |         Type         | Modifiers
    -------{}++{}------------------{}{}---------
     numeric | numeric(10,2)        |
     bpchar  | character(5)         |
     varchar | character varying(6) |