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

Update on numeric column using decimal values would set values to NULL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.0
    • 1.4.1
    • DMLProc
    • None
    • 2019-06

    Description

      Build tested: 14.0-1

      engine commit:
      1f47534

      test case: autopilot.systemTest.datatypes

      MariaDB [mytest]> create table t1 (snDECIMAL4_2 DECIMAL(4,2), unDECIMAL4_2 DECIMAL(4,2) unsigned) engine=columnstore;
      Query OK, 0 rows affected (0.433 sec)
       
      MariaDB [mytest]> desc t1;
      +--------------+-----------------------+------+-----+---------+-------+
      | Field        | Type                  | Null | Key | Default | Extra |
      +--------------+-----------------------+------+-----+---------+-------+
      | snDECIMAL4_2 | decimal(4,2)          | YES  |     | NULL    |       |
      | unDECIMAL4_2 | decimal(4,2) unsigned | YES  |     | NULL    |       |
      +--------------+-----------------------+------+-----+---------+-------+
      2 rows in set (0.001 sec)
       
      MariaDB [mytest]> insert t1 values (10.55, 12.89);
      Query OK, 1 row affected (0.295 sec)
       
      MariaDB [mytest]> select * from t1;
      +--------------+--------------+
      | snDECIMAL4_2 | unDECIMAL4_2 |
      +--------------+--------------+
      |        10.55 |        12.89 |
      +--------------+--------------+
      1 row in set (0.094 sec)
       
      MariaDB [mytest]> update t1 set snDECIMAL4_2 = 11.99, unDECIMAL4_2 = 17.99;
      Query OK, 0 rows affected (0.322 sec)
      Rows matched: 0  Changed: 0  Warnings: 0
       
      MariaDB [mytest]> select * from t1;
      +--------------+--------------+
      | snDECIMAL4_2 | unDECIMAL4_2 |
      +--------------+--------------+
      |         NULL |         NULL |
      +--------------+--------------+
      1 row in set (0.010 sec)
       
      MariaDB [mytest]> update t1 set snDECIMAL4_2 = 11, unDECIMAL4_2 = 17;
      Query OK, 0 rows affected (0.162 sec)
      Rows matched: 0  Changed: 0  Warnings: 0
       
      MariaDB [mytest]> select * from t1;
      +--------------+--------------+
      | snDECIMAL4_2 | unDECIMAL4_2 |
      +--------------+--------------+
      |        11.00 |        17.00 |
      +--------------+--------------+
      1 row in set (0.042 sec)
      
      

      Attachments

        Activity

          People

            bharath.bokka Bharath Bokka (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.