[
https://issues.apache.org/jira/browse/FLINK-18365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325369#comment-17325369
]
Flink Jira Bot commented on FLINK-18365:
----------------------------------------
This issue is assigned but has not received an update in 7 days so it has been
labeled "stale-assigned". If you are still working on the issue, please give an
update and remove the label. If you are no longer working on the issue, please
unassign so someone else may work on it. In 7 days the issue will be
automatically unassigned.
> The same sql in a batch env and a streaming env has different value.
> --------------------------------------------------------------------
>
> Key: FLINK-18365
> URL: https://issues.apache.org/jira/browse/FLINK-18365
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.11.0
> Reporter: xiaojin.wy
> Assignee: Shuo Cheng
> Priority: Major
> Labels: stale-assigned
> Fix For: 1.14.0
>
>
> I use the sql-gateway to run this sql.
> *The input table is:*
> CREATE TABLE `scott_dept` (
> deptno INT,
> dname VARCHAR,
> loc VARCHAR
> ) WITH (
> 'format.field-delimiter'='|',
> 'connector.type'='filesystem',
> 'format.derive-schema'='true',
>
> 'connector.path'='/defender_test_data/daily_regression_stream_blink_sql_1.10/test_scalar/sources/scott_dept.csv',
> 'format.type'='csv'
> )
> *The input data is:*
> 10|ACCOUNTING|NEW YORK
> 20|RESEARCH|DALLAS
> 30|SALES|CHICAGO
> 40|OPERATIONS|BOSTON
> *The sql is :*
> select deptno, (select count(*) from scott_emp where 1 = 0) as x from
> scott_dept
> *The error:*
> In a batch environment, the result value is:10|0\n20|0\n30|0\n40|0
> In a streaming environment, the result value
> is:10|None\n20|None\n30|None\n40|None
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
