Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.5.3
-
None
-
2020-7
Description
Consider the following:
select IF(r_regionkey >= 0x40000000, r_regionkey+10, r_regionkey) page from region cc order by 1 ; |
This returns r_regionkey+10, even though all r_regionkey are < 5.
Replacing 0x40000000 with it's base 10 equivalent (1073741824) does not exhibit the bug.
Debugging shows that the constant column is malformed when it reaches the IF function.
This is a regression in 1.5. columnstore 1.4.4 returns the correct response, and debugging shows the constant column is correct.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Consider the following:
{code:java} select IF(r_regionkey >= 0x40000000, r_regionkey+10, r_regionkey) page from region cc order by 1 ; {code} This returns r_regionkey+10, even though all r_regionkey are < 5. Debugging shows that the constant column is malformed when it reaches the IF function. This is a regression in 1.5. columnstore 1.4.4 returns the correct response, and debugging shows the constant column is correct. |
Consider the following:
{code:java} select IF(r_regionkey >= 0x40000000, r_regionkey+10, r_regionkey) page from region cc order by 1 ; {code} This returns r_regionkey+10, even though all r_regionkey are < 5. Replacing 0x40000000 with it's base 10 equivalent (1073741824) does not show the bug. Debugging shows that the constant column is malformed when it reaches the IF function. This is a regression in 1.5. columnstore 1.4.4 returns the correct response, and debugging shows the constant column is correct. |
| Description |
Consider the following:
{code:java} select IF(r_regionkey >= 0x40000000, r_regionkey+10, r_regionkey) page from region cc order by 1 ; {code} This returns r_regionkey+10, even though all r_regionkey are < 5. Replacing 0x40000000 with it's base 10 equivalent (1073741824) does not show the bug. Debugging shows that the constant column is malformed when it reaches the IF function. This is a regression in 1.5. columnstore 1.4.4 returns the correct response, and debugging shows the constant column is correct. |
Consider the following:
{code:java} select IF(r_regionkey >= 0x40000000, r_regionkey+10, r_regionkey) page from region cc order by 1 ; {code} This returns r_regionkey+10, even though all r_regionkey are < 5. Replacing 0x40000000 with it's base 10 equivalent (1073741824) does not exhibit the bug. Debugging shows that the constant column is malformed when it reaches the IF function. This is a regression in 1.5. columnstore 1.4.4 returns the correct response, and debugging shows the constant column is correct. |
| Assignee | David Hall [ david.hall ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | David Hall [ david.hall ] | Roman [ drrtuy ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Sprint | 2020-7 [ 410 ] |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Rank | Ranked higher |
| Fix Version/s | 1.5.0 [ 24513 ] | |
| Fix Version/s | 1.5 [ 22800 ] |
| Affects Version/s | 1.5.3 [ 24412 ] | |
| Affects Version/s | 1.5 [ 22800 ] |
| Fix Version/s | 1.5.1 [ 24514 ] | |
| Fix Version/s | 1.5.0 [ 24513 ] |