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)