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

Columnstore (&MDB) query returns incorrect value instead of expected out-of-range error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • None
    • N/A
    • PrimProc
    • None

    Description

      create schema coltest; use coltest;
      drop table if exists test_mult;
      create table test_mult (
      indemnity_paid int(11),
      n_clms DECIMAL UNSIGNED
      ) engine=columnstore;
      insert into test_mult (indemnity_paid, n_clms) values (-10, 1);
      select indemnity_paid, n_clms, indemnity_paid * n_clms from test_mult;
      ---------------------------------------------

      indemnity_paid n_clms indemnity_paid * n_clms

      ---------------------------------------------

      10 1 -10

      ---------------------------------------------
      The multiplication produces an incorrect value.
      For tinyint unsigned, the multiplication produces an expected out-of-range error:

      ERROR 1815 (HY000): Internal error: MCS-2061: BIGINT UNSIGNED value is out of range in '`unk`.`unk`.`unk` "*" `unk`.`unk`.`unk`'

      Same no error for FLOAT UNSIGNED and DOUBLE UNSIGNED.

      Attachments

        Activity

          People

            drrtuy Roman
            kirill.perov@mariadb.com Kirill Perov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.