[jira] [Created] (CALCITE-6426) When performing starrocks dialect conversion for cast (xxx as int) and cast (xxx as bigint), it defaults to using MySQL dialect

[fanluo (Jira)]

fanluo created CALCITE-6426:
-------------------------------

             Summary: When performing starrocks dialect conversion for cast 
(xxx as int) and cast (xxx as bigint), it defaults to using MySQL dialect
                 Key: CALCITE-6426
                 URL: https://issues.apache.org/jira/browse/CALCITE-6426
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.37.0
            Reporter: fanluo
         Attachments: image-2024-06-03-19-55-59-034.png, 
image-2024-06-03-19-57-22-686.png

When performing starrocks dialect conversion for cast (xxx as int) and cast 
(xxx as bigint), it defaults to using MySQL dialect，like this:

!image-2024-06-03-19-57-22-686.png|width=839,height=123!

while starlocks does not explicitly declare support for the signed data type. 
If conversion is performed according to the MySQL dialect by default, the 
execution result will exceed expectations when the data value exceeds the range 
[-21474836482147483647]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)