[MCOL-4953] "Values Saturated" Error when using insert into.. select from.. from an Innodb int type to Columnstore mediumtext(8) Created: 2021-12-23  Updated: 2023-11-11  Resolved: 2023-11-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 6.2.2
Fix Version/s: 23.10.0

Type: Bug Priority: Major
Reporter: Maria M Pflaum Assignee: Roman
Resolution: Fixed Votes: 0
Labels: 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)
Generated at Thu Feb 08 02:54:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.