[jira] [Created] (DRILL-7587) Query with VALUES clause returns the wrong result when planner.slice_target is small

["Vova Vysotskyi (Jira)" <ji...@apache.org>]

Vova Vysotskyi created DRILL-7587:
-------------------------------------

             Summary: 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.17.0, 1.16.0
            Reporter: Vova Vysotskyi
             Fix For: Future


*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)