Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.6
-
None
-
debian9
-
2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7
Description
IN() clause does not evaluate properly on some columns with a window function
in the example below, the column r is computed with the function DENSE_RANK in a subselect, and there is a where r in (...). The where clause does not filter rows as expected.
Note that rows are properly filtered if the where clause is rewritten as (r=1 or r=2)
create table t(a int, b int) engine=ColumnStore;
insert into t(a,b) values(1,4),(2,3),(3,2),(4,1);
select
a,
r
from (
select
a,
DENSE_RANK() OVER `w_0` as `r`
from t
WINDOW `w_0` as ( ORDER BY `b` DESC)
) t0
where r in (1,2)
=> returns
1,1
2,2
3,3
4,4
instead of just the first 2 rows
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 1.2.4 [ 23254 ] |
| Fix Version/s | 1.2 [ 22554 ] | |
| Fix Version/s | 1.2.4 [ 23254 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Assignee | Jose Rojas [ jrojas ] |
| Sprint | 2020-2 [ 382 ] |
| Story Points | 2 |
| Fix Version/s | 1.4.4 [ 24039 ] | |
| Fix Version/s | 1.2 [ 22554 ] |
| Sprint | 2020-2 [ 382 ] | 2020-2, 2020-3 [ 382, 383 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Sprint | 2020-2, 2020-3 [ 382, 383 ] | 2020-2, 2020-3, 2020-4 [ 382, 383, 392 ] |
| Team | ColumnStore Team |
| Assignee | Jose Rojas [ jrojas ] | Roman [ drrtuy ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Sprint | 2020-2, 2020-3, 2020-4 [ 382, 383, 392 ] | 2020-2, 2020-3, 2020-4, 2020-5 [ 382, 383, 392, 396 ] |
| Sprint | 2020-2, 2020-3, 2020-4, 2020-5 [ 382, 383, 392, 396 ] | 2020-2, 2020-3, 2020-4 [ 382, 383, 392 ] |
| Sprint | 2020-2, 2020-3, 2020-4 [ 382, 383, 392 ] | 2020-2, 2020-3, 2020-4, 2020-5 [ 382, 383, 392, 396 ] |
| Assignee | Roman [ drrtuy ] | Jose Rojas [ jrojas ] |
| Assignee | Jose Rojas [ jrojas ] | Roman [ drrtuy ] |
| Sprint | 2020-2, 2020-3, 2020-4, 2020-5 [ 382, 383, 392, 396 ] | 2020-2, 2020-3, 2020-4, 2020-5, 2020-6 [ 382, 383, 392, 396, 404 ] |
| Assignee | Roman [ drrtuy ] | Jose Rojas [ jrojas ] |
| Fix Version/s | 1.5 [ 22800 ] |
| Assignee | Jose Rojas [ jrojas ] | Roman [ drrtuy ] |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Assignee | Roman [ drrtuy ] | Daniel Lee [ dleeyh ] |
| Sprint | 2020-2, 2020-3, 2020-4, 2020-5, 2020-6 [ 382, 383, 392, 396, 404 ] | 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7 [ 382, 383, 392, 396, 404, 410 ] |
| Rank | Ranked higher |
| issue.field.resolutiondate | 2020-04-30 16:18:30.0 | 2020-04-30 16:18:30.979 |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 1.5.0 [ 24513 ] | |
| Fix Version/s | 1.5 [ 22800 ] |
| Fix Version/s | 1.5.1 [ 24514 ] | |
| Fix Version/s | 1.5.0 [ 24513 ] |