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

INSERT..SELECT doesn't work from InnoDB table to Columnstore table on 5.4.1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.4.3
    • Component/s: None
    • Labels:

      Description

      INSERT..SELECT doesn't work from InnoDB table to Columnstore table on 1.5.4
      It gives below error.

      MariaDB [test]> insert into global_cust select * from global_cust_test111 where global_ident_num='12345';
      ERROR 9999 (HY000): Values saturated
      MariaDB [test]>

      and I was able to reproduce the same with MariaDB 10.5.5

      version 10.5.5-MariaDB
      version_comment MariaDB Server
      version_compile_machine x86_64
      version_compile_os Linux
      Columnstore_version 1.5.4

      Even I've tried to increase size of VARCHAR columns to 4x for Columnstore table but still getting the same error that value is saturated. Though, direct insert to this table with the
      the same value works.

      Test case is included in the ticket's internal note.
      https://cloud.mariadb.com/case.do?id=CS0121756

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: