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

"Values Saturated" Error when using insert into.. select from.. from an Innodb int type to Columnstore mediumtext(8)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.2.2
    • 23.10.0
    • PrimProc
    • None

    Description

      CREATE DATABASE panel;
      USE panel;

      DROP TABLE if exists `cs_test`;

      CREATE TABLE `cs_test` (

      `ONE_ID` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
      `TWO_ID` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL
      )
      ENGINE=Columnstore;

      DROP TABLE if EXISTS `innodb_test`;
      CREATE TABLE `innodb_test` (

      `ONE_ID` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
      `TWO_ID` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL
      )
      ;

      DROP TABLE if EXISTS `cs_test_int`;
      CREATE TABLE `cs_test_int` (

      `ONE_ID` int UNSIGNED NULL DEFAULT NULL,
      `TWO_ID` int UNSIGNED NULL DEFAULT NULL
      )
      ;

      INSERT INTO `innodb_test` VALUES ( 1163, 1163);

      insert into panel.cs_test
      SELECT * FROM panel.innodb_test ;
      ERROR 9999 (HY000): Values saturated

      insert into panel.cs_test_int
      SELECT * FROM panel.innodb_test ;

      #select
      SELECT ONE_ID,TWO_ID FROM panel.cs_test;

      Result: 16777215,16777215
      Should be: 1163, 1163

      SELECT ONE_ID,TWO_ID FROM panel.cs_test_int;
      Gives correct result:1163,1163

      MariaDB [panel]> select @@version;
      -----------------------------

      @@version

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

      10.6.5-2-MariaDB-enterprise

      -----------------------------
      1 row in set (0.000 sec)


      MariaDB [panel]> select * from information_schema.plugins where plugin_name = 'Columnstore';
      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE PLUGIN_TYPE_VERSION PLUGIN_LIBRARY PLUGIN_LIBRARY_VERSION PLUGIN_AUTHOR PLUGIN_DESCRIPTION PLUGIN_LICENSE LOAD_OPTION PLUGIN_MATURITY PLUGIN_AUTH_VERSION

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

      Columnstore 6.2 ACTIVE STORAGE ENGINE 100605.0 ha_columnstore.so 1.14 MariaDB Corporation ColumnStore storage engine GPL ON Stable 6.2.2

      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 row in set (0.002 sec)


      Attachments

        Activity

          People

            drrtuy Roman
            mpflaum Maria M Pflaum
            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.