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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.16.0, 1.17.0
• Fix Version/s: 1.18.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Vova Vysotskyi
• Reviewer: Vova Vysotskyi
• Created: 14/Feb/20 14:24
• Updated: 02/Mar/20 15:03
• Resolved: 02/Mar/20 15:03

Description

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:

set `planner.slice_target`=1;

2. Run query with VALUES clause which returns more rows than 1:

select id, name from (values(1234567890123456789, 'a'), (-1234567890123456789, 'z')) t(id, name);

Expected result

+----------------------+------+
|          id          | name |
+----------------------+------+
| 1234567890123456789  | a    |
| -1234567890123456789 | z    |
+----------------------+------+

Actual result

+----------------------+------+
|          id          | name |
+----------------------+------+
| 1234567890123456789  | a    |
| 1234567890123456789  | a    |
| -1234567890123456789 | z    |
| -1234567890123456789 | z    |
+----------------------+------+

Issue Links

• links to: GitHub Pull Request #2002