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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 5.4.3
    • None

    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

              dleeyh Daniel Lee (Inactive)
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.