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)
