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

SET double_col=decimal_col returns an error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.6.1, 6.1.1
    • Fix Version/s: 23.02
    • Component/s: PrimProc
    • Labels:
      None

      Description

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (i INT, d DOUBLE) ENGINE=ColumnStore;
      		 
      INSERT INTO t1 VALUES (0, 1.5);
      		 
      UPDATE t1 SET i=d;


      ERROR 1264 (22003): CAL0002: IDB-2025: Data truncated for column 'i'

      Looks wrong. It should round double to int without errors, like InnoDB does:

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (i INT, d DOUBLE) ENGINE=InnoDB;
      		 
      INSERT INTO t1 VALUES (0, 1.5);
      		 
      UPDATE t1 SET i=d;
      		 
      SELECT * FROM t1;


      +------+------+
      		 
      | i    | d    |
      		 
      +------+------+
      		 
      |    2 |  1.5 |
      		 
      +------+------+

      Note, the same problem is also repeatable for the FLOAT data type.

        Attachments

          Issue Links

          blocks

          Task - A task that needs to be done. MCOL-4755 Allow joins on all numeric data type pairs

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4622 Implicit FLOAT->INT and DOUBLE->INT conversion is not like in InnoDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4627 SET int_col=decimal_col returns an error

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MCOL-641 Full DECIMAL support in ColumnStore

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MCOL-4361 Replace pow(10.0, (double)scale) expressions with a static dictionary lookup.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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