|
For QA:
Steps to reproduce and ensure the bug is fixed:
MariaDB [test]> drop table if exists global_cust_ra_clm_cs;
|
Query OK, 0 rows affected, 1 warning (0.079 sec)
|
|
MariaDB [test]> drop table if exists global_cust_ra_clm;
|
Query OK, 0 rows affected, 1 warning (0.031 sec)
|
|
MariaDB [test]>
|
MariaDB [test]> CREATE TABLE `global_cust_ra_clm_cs` (
|
-> `GLOBAL_CUST_KEY` varchar(240) COLLATE utf8mb4_bin NOT NULL,
|
-> `GLOBAL_IDENT_NUM` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `ASOF_DT` datetime NOT NULL,
|
-> `REL_GRP_KEY` varchar(120) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CUST_OWNR_KEY` varchar(80) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `IDENT_NUM_TYP` varchar(120) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CUST_NM` varchar(800) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `MAS_INDUSTRY_CD` varchar(80) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `MAS_INDUSTRY_DESC` varchar(320) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CNTRY_NM_OF_REGISTRATION` varchar(176) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `DT_OF_REGISTRATION` datetime DEFAULT NULL,
|
-> `LOCAL_RM_CD` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `LRM_NM` varchar(400) COLLATE utf8mb4_bin DEFAULT NULL
|
-> ) engine=columnstore DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
Query OK, 0 rows affected (0.674 sec)
|
|
MariaDB [test]>
|
MariaDB [test]> CREATE TABLE `global_cust_ra_clm` (
|
-> `GLOBAL_CUST_KEY` varchar(60) COLLATE utf8mb4_bin NOT NULL,
|
-> `GLOBAL_IDENT_NUM` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `ASOF_DT` datetime NOT NULL,
|
-> `REL_GRP_KEY` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CUST_OWNR_KEY` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `IDENT_NUM_TYP` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CUST_NM` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `MAS_INDUSTRY_CD` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `MAS_INDUSTRY_DESC` varchar(80) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `CNTRY_NM_OF_REGISTRATION` varchar(44) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `DT_OF_REGISTRATION` datetime DEFAULT NULL,
|
-> `LOCAL_RM_CD` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
|
-> `LRM_NM` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL
|
-> ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
Query OK, 0 rows affected (0.013 sec)
|
|
MariaDB [test]>
|
MariaDB [test]> INSERT INTO global_cust_ra_clm (GLOBAL_CUST_KEY,GLOBAL_IDENT_NUM,ASOF_DT,REL_GRP_KEY,CUST_OWNR_KEY,IDENT_NUM_TYP,CUST_NM,MAS_INDUSTRY_CD,MAS_INDUSTRY_DESC,CNTRY_NM_OF_REGISTRATION,DT_OF_REGISTRATION, LOCAL_RM_CD,LRM_NM) VALUES ('GC000012148420200823','GC0000121484','2020-08-23 00:00:00','DBSIDID30220090131',400120090131,'GCINC CUSTOMER','XXXXXXX XXXXX XXXX XXXX, XX',010101,'AGRICULTURAL & LIVESTOCK PRODUCTION','INDONESIA','1980-03-15 00:00:00','SAMUELYULIADY','SAMUELYULIADY');
|
Query OK, 1 row affected (0.002 sec)
|
|
MariaDB [test]>
|
MariaDB [test]> INSERT INTO global_cust_ra_clm_cs SELECT * FROM global_cust_ra_clm;
|
ERROR 9999 (HY000): Values saturated
|
MariaDB [test]> select * from global_cust_ra_clm_cs;
|
+----------------------+------------------+---------------------+-------------+---------------+---------------+---------+-----------------+-------------------+--------------------------+---------------------+-------------+--------+
|
| GLOBAL_CUST_KEY | GLOBAL_IDENT_NUM | ASOF_DT | REL_GRP_KEY | CUST_OWNR_KEY | IDENT_NUM_TYP | CUST_NM | MAS_INDUSTRY_CD | MAS_INDUSTRY_DESC | CNTRY_NM_OF_REGISTRATION | DT_OF_REGISTRATION | LOCAL_RM_CD | LRM_NM |
|
+----------------------+------------------+---------------------+-------------+---------------+---------------+---------+-----------------+-------------------+--------------------------+---------------------+-------------+--------+
|
| GC000012148420200823 | NULL | 0000-00-00 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0000-00-00 00:00:00 | NULL | NULL |
|
+----------------------+------------------+---------------------+-------------+---------------+---------------+---------+-----------------+-------------------+--------------------------+---------------------+-------------+--------+
|
1 row in set (0.103 sec)
|
|
|
Build verified: 5.5.1-1 (Drone #1036)
Reproduced the issue in release 5.4.1-1
MariaDB [mytest]> INSERT INTO global_cust_ra_clm (GLOBAL_CUST_KEY,GLOBAL_IDENT_NUM,ASOF_DT,REL_GRP_KEY,CUST_OWNR_KEY,IDENT_NUM_TYP,CUST_NM,MAS_INDUSTRY_CD,MAS_INDUSTRY_DESC,CNTRY_NM_OF_REGISTRATION,DT_OF_REGISTRATION, LOCAL_RM_CD,LRM_NM) VALUES ('GC000012148420200823','GC0000121484','2020-08-23 00:00:00','DBSIDID30220090131',400120090131,'GCINC CUSTOMER','XXXXXXX XXXXX XXXX XXXX, XX',010101,'AGRICULTURAL & LIVESTOCK PRODUCTION','INDONESIA','1980-03-15 00:00:00','SAMUELYULIADY','SAMUELYULIADY');
Query OK, 1 row affected (0.004 sec)
MariaDB [mytest]> INSERT INTO global_cust_ra_clm_cs SELECT * FROM global_cust_ra_clm;
ERROR 9999 (HY000): Values saturated
Verified fix in 5.5.1-1
MariaDB [mytest]> INSERT INTO global_cust_ra_clm (GLOBAL_CUST_KEY,GLOBAL_IDENT_NUM,ASOF_DT,REL_GRP_KEY,CUST_OWNR_KEY,IDENT_NUM_TYP,CUST_NM,MAS_INDUSTRY_CD,MAS_INDUSTRY_DESC,CNTRY_NM_OF_REGISTRATION,DT_OF_REGISTRATION, LOCAL_RM_CD,LRM_NM) VALUES ('GC000012148420200823','GC0000121484','2020-08-23 00:00:00','DBSIDID30220090131',400120090131,'GCINC CUSTOMER','XXXXXXX XXXXX XXXX XXXX, XX',010101,'AGRICULTURAL & LIVESTOCK PRODUCTION','INDONESIA','1980-03-15 00:00:00','SAMUELYULIADY','SAMUELYULIADY');
Query OK, 1 row affected (0.003 sec)
MariaDB [mytest]> INSERT INTO global_cust_ra_clm_cs SELECT * FROM global_cust_ra_clm;
Query OK, 1 row affected (1.275 sec)
Records: 1 Duplicates: 0 Warnings: 0
|