[
https://issues.apache.org/jira/browse/HAWQ-1836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenglin Tao updated HAWQ-1836:
-------------------------------
Description: (was: 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) |)
> Failed to parse standby state when database is not accessible
> -------------------------------------------------------------
>
> Key: HAWQ-1836
> URL: https://issues.apache.org/jira/browse/HAWQ-1836
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Standby master
> Affects Versions: 3.0.0.0
> Reporter: Zhenglin Tao
> Assignee: Zhenglin Tao
> Priority: Major
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)