[MCOL-4612] A subquery with a union for DECIMAL and BIGINT returns zeros - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 6.1.1
Fix Version/s: 6.1.1
Component/s: ExeMgr, PrimProc
Labels:
- transient_regression

Sprint:
2021-8

Description

The problem does not seem to be repeatable in 5.x.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (1, 1);

INSERT INTO t1 VALUES (9999999999999999, 99999999999999999);

SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu;

+------+

| a    |

+------+

|  0.0 |

|  0.0 |

|  0.0 |

+------+

SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT b FROM t1) tu;

+------+

| a    |

+------+

|  0.0 |

|  0.0 |

|  0.0 |

|  0.0 |

+------+

Note, without the subquery it works as expected:

SELECT a FROM t1 UNION SELECT b FROM t1;

+---------------------+

| a                   |

+---------------------+

|                 1.0 |

|  9999999999999999.0 |

| 99999999999999999.0 |

+---------------------+

SELECT a FROM t1 UNION ALL SELECT b FROM t1;

+---------------------+

| a                   |

+---------------------+

|                 1.0 |

|  9999999999999999.0 |

|                 1.0 |

| 99999999999999999.0 |

+---------------------+

Attachments

Issue Links

blocks

MCOL-4613 Garbage result of a union between huge narrow DECIMAL and BIGINT

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

Sub-Tasks

Additional test needed

Closed

Daniel Lee (Inactive)

Activity

Ascending order - Click to sort in descending order

Gagan Goel (Inactive) added a comment - 2021-04-29 12:22

For QA: Queries to confirm the issue and verify the fix works are in the issue description.

Gagan Goel (Inactive) added a comment - 2021-04-29 12:22 For QA: Queries to confirm the issue and verify the fix works are in the issue description.

Daniel Lee (Inactive) added a comment - 2021-05-24 15:27

Build verified: 6.1.1 (Drone #2394)

MariaDB [mytest]> SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu;

+---------------------+

| a                   |

+---------------------+

|                 1.0 |

| 99999999999999999.0 |

|  9999999999999999.0 |

+---------------------+

3 rows in set (0.096 sec)

MariaDB [mytest]> SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT b FROM t1) tu;

+---------------------+

| a                   |

+---------------------+

|                 1.0 |

| 99999999999999999.0 |

|                 1.0 |

|  9999999999999999.0 |

+---------------------+

4 rows in set (0.027 sec)

Daniel Lee (Inactive) added a comment - 2021-05-24 15:27 Build verified: 6.1.1 (Drone #2394) MariaDB [mytest]> SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; +---------------------+ | a | +---------------------+ | 1.0 | | 99999999999999999.0 | | 9999999999999999.0 | +---------------------+ 3 rows in set (0.096 sec) MariaDB [mytest]> SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT b FROM t1) tu; +---------------------+ | a | +---------------------+ | 1.0 | | 99999999999999999.0 | | 1.0 | | 9999999999999999.0 | +---------------------+ 4 rows in set (0.027 sec)

People

Assignee:: Daniel Lee (Inactive)

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2021-03-16 03:48

Updated:: 2021-05-24 15:27

Resolved:: 2021-05-24 15:27

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore