Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4705

Retest MCOL-4613 in 6.1.1 given that the blocking fix for MCOL-4612 is merged into develop branch

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 6.1.1
    • ExeMgr
    • 2021-8

    Description

      There seems to be no PR or merge into 6.1.1 as of now. We need to make sure this does not reappear when we make it.

      Attachments

        Issue Links

          split from

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4613 Garbage result of a union between huge narrow DECIMAL and BIGINT

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 6.1.1 (Drone #2394)

            Result now matches with Innodb.

            MariaDB [monty]> DROP TABLE IF EXISTS t1;
            		 
            Query OK, 0 rows affected, 1 warning (0.120 sec)
            		 
             
            		 
            MariaDB [monty]> CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore;
            		 
            Query OK, 0 rows affected (0.626 sec)
            		 
             
            		 
            MariaDB [monty]> INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999);
            		 
            Query OK, 1 row affected (0.276 sec)
            		 
             
            		 
            MariaDB [monty]> SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu;
            		 
            +----------------------+
            		 
            | a                    |
            		 
            +----------------------+
            		 
            | 999999999999999999.0 |
            		 
            |   9999999999999999.9 |
            		 
            +----------------------+
            		 
            2 rows in set (0.123 sec)

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 6.1.1 (Drone #2394) Result now matches with Innodb. MariaDB [monty]> DROP TABLE IF EXISTS t1; Query OK, 0 rows affected, 1 warning (0.120 sec)   MariaDB [monty]> CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore; Query OK, 0 rows affected (0.626 sec)   MariaDB [monty]> INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999); Query OK, 1 row affected (0.276 sec)   MariaDB [monty]> SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu; +----------------------+ | a | +----------------------+ | 999999999999999999.0 | | 9999999999999999.9 | +----------------------+ 2 rows in set (0.123 sec)

            People

              dleeyh Daniel Lee (Inactive)
              gdorman Gregory Dorman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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