[MDEV-27023] Type difference when returning integer column value from JAVA in MariaDB 10.2 and MariaDB 10.5 Created: 2021-11-11  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.2.29, 10.5.12
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: 이종명 Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None
Environment:

[DB]
MariaDB 10.2.29
MariaDB 10.5.12

[Development]
JAVA 1.7
Mybatis
Framework spring
mysql-connector-java-5.1.43-bin.jar



 Description   

[Problem]
In JAVA, the BOX_CNT column of MariaDB 10.2.29 is returned as a long.
In JAVA, the BOX_CNT column of MariaDB 10.5.12 is returned as an integer.
Different versions have different return types, which causes casting problems.
What is causing the problem?

[DDL]
CREATE TABLE `tb_order_item_distbox` (
`ORDER_ITEM_SEQ` bigint(20) NOT NULL COMMENT '',
`BOX_SEQ` bigint(20) NOT NULL COMMENT '',
`ORDER_KG` double(11,2) NOT NULL COMMENT '',
`FIX_KG` double(11,2) DEFAULT NULL COMMENT '',
`BOX_CNT` int(11) DEFAULT 1 COMMENT '',
PRIMARY KEY (`ORDER_ITEM_SEQ`,`BOX_SEQ`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';

[Read Query]
SELECT A.order_item_seq
, A.box_seq
, ifnull(A.box_cnt, 0) box_cnt
FROM tb_order_item_distbox A


Generated at Thu Feb 08 09:49:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.