Zhong Yanghong created KYLIN-2600: ------------------------------------- Summary: Incorrectly set the range start when filtering by the minimum value Key: KYLIN-2600 URL: https://issues.apache.org/jira/browse/KYLIN-2600 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Zhong Yanghong Assignee: Zhong Yanghong
Before defining a range of a scan, the range start may be not correct in the following case: {code} OR [ AND [ a <= 2, b = 2 ], AND [ a = 0, (note that 0 is the minimum of a) b = 1 ] ] {code} In this case, kylin will generate two ranges: {code} [null,2] - [2, 1] [0,1] - [0,1] {code} There's a rule when merging ranges. If the range start is null, it will be ordered before others whose range start is not null. Then the merged range of these two ranges will be \[null,2\] - \[2, 1\]. Replacing null with 0, the range sent to coprocessor will be \[0,2\] - \[2, 1\]. However, it should be \[0,1\] - \[2, 1\] and the rule should be refined. -- This message was sent by Atlassian JIRA (v6.3.15#6346)