[
https://issues.apache.org/jira/browse/FLINK-31906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-31906:
----------------------------
Component/s: Table SQL / API
> typeof should only return type exclude nullable
> ------------------------------------------------
>
> Key: FLINK-31906
> URL: https://issues.apache.org/jira/browse/FLINK-31906
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.18.0
> Reporter: jackylau
> Priority: Major
>
> nullable is table level constraint, which can only show by showing schema
>
> pg [https://www.postgresql.org/docs/9.3/functions-info.html]
> spark ：https://spark.apache.org/docs/latest/api/sql/index.html#typeof
> {code:java}
> // code placeholder
> select typeof(1Y), typeof(1S), typeof(1), typeof(1L)
> -- !query schema
> struct<typeof(1):string,typeof(1):string,typeof(1):string,typeof(1):string>
> -- !query output
> tinyint smallint int bigint
> -- !query
> select typeof(cast(1.0 as float)), typeof(1.0D), typeof(1.2)
> -- !query schema
> struct<typeof(CAST(1.0 AS
> FLOAT)):string,typeof(1.0):string,typeof(1.2):string>
> -- !query output
> float double decimal(2,1) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
