[
https://issues.apache.org/jira/browse/FLINK-23290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caizhi Weng closed FLINK-23290.
-------------------------------
Fix Version/s: 1.14.0
Resolution: Fixed
> cast '(LZ *3' as boolean, get a null
> ------------------------------------
>
> Key: FLINK-23290
> URL: https://issues.apache.org/jira/browse/FLINK-23290
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Runtime
> Affects Versions: 1.14.0
> Reporter: xiaojin.wy
> Assignee: Caizhi Weng
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.14.0
>
>
> {code:sql}
> CREATE TABLE database5_t0(
> c0 VARCHAR , c1 BIGINT
> ) WITH (
> 'connector' = 'filesystem',
> 'path' = 'hdfs:///tmp/database5_t0.csv',
> 'format' = 'csv'
> );
> INSERT OVERWRITE database5_t0(c0, c1) VALUES('(LZ *3', 2135917226)
> SELECT database5_t0.c0 AS ref0 FROM database5_t0 WHERE CAST (database5_t0.c0
> AS BOOLEAN)
> {code}
> After excuting that, you will get the error:
> {code}
> Caused by: java.lang.NullPointerException
> at BatchExecCalc$20.processElement(Unknown Source)
> at
> org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:101)
> at
> org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:82)
> at
> org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39)
> at
> org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:56)
> at
> org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:29)
> at
> org.apache.flink.streaming.api.operators.StreamSourceContexts$ManualWatermarkContext.processAndCollect(StreamSourceContexts.java:319)
> at
> org.apache.flink.streaming.api.operators.StreamSourceContexts$WatermarkContext.collect(StreamSourceContexts.java:414)
> at
> org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:92)
> at
> org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:104)
> at
> org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:62)
> at
> org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:269)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
