Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
5.5.2
-
2021-7
Description
This ticket is for 5.6.1 only. Testing in 6.1.1 will need to wait until MCOL-4612 is MERGED into develop branch
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); |
SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; |
+-----------------------+
|
| a |
|
+-----------------------+
|
| 9999999999999999.9 |
|
| -844674407370955162.6 |
|
+-----------------------+
|
Looks wrong.
Note, the problem cannot be repeated in 6.x because of MCOL-4612
But perhaps it still exists. MCOL-4612 needs to be fixed first to verify it further in 6.x.
Attachments
Issue Links
- is blocked by
-
MCOL-4612 A subquery with a union for DECIMAL and BIGINT returns zeros
-
- Closed
-
- relates to
-
MCOL-4361 Replace pow(10.0, (double)scale) expressions with a static dictionary lookup.
-
- Closed
-
-
MCOL-641 Full DECIMAL support in ColumnStore
-
- Closed
-
-
MCOL-4700 Wrong result of a UNION for INT and INT UNSIGNED
-
- Closed
-
- split to
-
MCOL-4705 Retest MCOL-4613 in 6.1.1 given that the blocking fix for MCOL-4612 is merged into develop branch
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 5.6 because of |
Summary | Wrong result of a union between huge narrow DECIMAL and BIGINT | Garbage result of a union between huge narrow DECIMAL and BIGINT |
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 5.6 because of |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 5.6 because of |
Priority | Major [ 3 ] | Blocker [ 1 ] |
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 5.6 because of |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of |
Affects Version/s | 5.6.1 [ 25031 ] | |
Affects Version/s | 5.5.1 [ 25030 ] |
Fix Version/s | 5.6.1 [ 25031 ] | |
Fix Version/s | 5.5.2 [ 25601 ] |
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of But perhaps it still exists. |
Assignee | Gagan Goel [ tntnatbry ] |
Assignee | Gagan Goel [ tntnatbry ] | Alexander Barkov [ bar ] |
Assignee | Alexander Barkov [ bar ] | Gagan Goel [ tntnatbry ] |
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of But perhaps it still exists. |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of But perhaps it still exists. |
Rank | Ranked higher |
Rank | Ranked higher |
Rank | Ranked higher |
Rank | Ranked higher |
Sprint | 2021-7 [ 514 ] |
Rank | Ranked lower |
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Gagan Goel [ tntnatbry ] | Alexander Barkov [ bar ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Alexander Barkov [ bar ] | Gagan Goel [ tntnatbry ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | In Testing [ 10301 ] |
Assignee | Gagan Goel [ tntnatbry ] | Daniel Lee [ dleeyh ] |
Resolution | Fixed [ 1 ] | |
Status | In Testing [ 10301 ] | Closed [ 6 ] |
Affects Version/s | 5.5.2 [ 25601 ] | |
Affects Version/s | All [ 25803 ] | |
Affects Version/s | 5.6.1 [ 25031 ] |
Labels | tech_debt |
Description |
{code:sql}
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of But perhaps it still exists. |
*This ticket is for 5.6.1 only. Testing in 6.1.1 will need to wait until {code:sql} DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; {code} {noformat} +-----------------------+ | a | +-----------------------+ | 9999999999999999.9 | | -844674407370955162.6 | +-----------------------+ {noformat} Looks wrong. Note, the problem cannot be repeated in 6.x because of But perhaps it still exists. |
Rank | Ranked higher |
Affects Version/s | All [ 25803 ] |