[jira] [Created] (FLINK-27368) CAST(' 1 ' as BIGINT) reutrns wrong result

["Jark Wu (Jira)" <ji...@apache.org>]

Jark Wu created FLINK-27368:
-------------------------------

             Summary: CAST(' 1 ' as BIGINT) reutrns wrong result
                 Key: FLINK-27368
                 URL: https://issues.apache.org/jira/browse/FLINK-27368
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner, Table SQL / Runtime
    Affects Versions: 1.15.0
            Reporter: Jark Wu
             Fix For: 1.15.0


{code:sql}
select
                    cast(' 1 ' as tinyint),
                    cast(' 1 ' as smallint),
                    cast(' 1 ' as int),
                    cast(' 1 ' as bigint),
                    cast(' 1 ' as float),
                    cast(' 1 ' as double);
{code}

The above query should return {{[1, 1, 1, 1, 1.0, 1.0]}} , but is {{[null, null, null, null, 1.0, 1.0]}}. 

In Postgres:
{code}
postgres=# select cast(' 1 ' as int), cast(' 1 ' as bigint), cast(' 1 ' as float);
 int4 | int8 | float8
------+------+--------
    1 |    1 |      1
(1 row)
{code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)