[
https://issues.apache.org/jira/browse/CALCITE-6926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939774#comment-17939774
]
Mihai Budiu commented on CALCITE-6926:
--------------------------------------
I am not sure how this function getCastSpec is supposed to be used.
If it converts from the Calcite dialect to the clickhouse dialect, then maybe
the function was correct.
If it converts from the Clickhouse dialect to the Calcite dialect, this change
may be warranted.
> ClickHouse Float type should not be converted to Double type
> ------------------------------------------------------------
>
> Key: CALCITE-6926
> URL: https://issues.apache.org/jira/browse/CALCITE-6926
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.39.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.40.0
>
>
> In ClickHouse float should to be Float32, double to be Float64, this can
> refer to document:
> [https://clickhouse.com/docs/sql-reference/data-types/float]
>
> The equivalent types in ClickHouse and in C are given below:
> * {{Float32}} — {{{}float{}}}.
> * {{Float64}} — {{{}double{}}}.
>
> Float types in ClickHouse have the following aliases:
> * {{Float32}} — {{{}FLOAT{}}}, {{{}REAL{}}}, {{{}SINGLE{}}}.
> * {{Float64}} — {{{}DOUBLE{}}}, {{{}DOUBLE PRECISION{}}}.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
