Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.2.2
-
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)