You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Zhenglin Tao (Jira)" <ji...@apache.org> on 2022/04/20 09:06:00 UTC
[jira] [Updated] (HAWQ-1838) Fix attribute typmod for CREATE TABLE AS SELECT
[ https://issues.apache.org/jira/browse/HAWQ-1838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhenglin Tao updated HAWQ-1838:
-------------------------------
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) |
> Fix attribute typmod for CREATE TABLE AS SELECT
> -----------------------------------------------
>
> Key: HAWQ-1838
> URL: https://issues.apache.org/jira/browse/HAWQ-1838
> Project: Apache HAWQ
> Issue Type: Bug
> Components: DDL
> Reporter: Zhenglin Tao
> Assignee: Ruilong Huo
> Priority: Major
>
> 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) |
--
This message was sent by Atlassian Jira
(v8.20.7#820007)