[
https://issues.apache.org/jira/browse/DRILL-7587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7587:
------------------------------------
Reviewer: Vova Vysotskyi
> Query with VALUES clause returns the wrong result when planner.slice_target
> is small
> ------------------------------------------------------------------------------------
>
> Key: DRILL-7587
> URL: https://issues.apache.org/jira/browse/DRILL-7587
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.16.0, 1.17.0
> Reporter: Vova Vysotskyi
> Assignee: Arina Ielchiieva
> Priority: Critical
> Fix For: 1.18.0
>
>
> *Problem description*
> The query returns the wrong result when {{planner.slice_target}} is less
> than the rows count returned from {{VALUES}}.
> *Steps to reproduce*
> 1. Set {{planner.slice_target}} to 1:
> {code:sql}
> set `planner.slice_target`=1;
> {code}
> 2. Run query with {{VALUES}} clause which returns more rows than 1:
> {code:sql}
> select id, name from (values(1234567890123456789, 'a'),
> (-1234567890123456789, 'z')) t(id, name);
> {code}
> *Expected result*
> {noformat}
> +----------------------+------+
> | id | name |
> +----------------------+------+
> | 1234567890123456789 | a |
> | -1234567890123456789 | z |
> +----------------------+------+
> {noformat}
> *Actual result*
> {noformat}
> +----------------------+------+
> | id | name |
> +----------------------+------+
> | 1234567890123456789 | a |
> | 1234567890123456789 | a |
> | -1234567890123456789 | z |
> | -1234567890123456789 | z |
> +----------------------+------+
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
