StarRocks/starrocks

[BUG] 使用mysql jdbc catalog 查询mysql中的表的时候，提示JDBC result type is Integer, please set the type to one of tinyint,smallint,int,bigint: BE:10002

Open

#60,124 创建于 2025年6月20日

在 GitHub 查看
 (3 评论) (0 反应) (1 负责人)Java (5,717 star) (1,246 fork)batch import
good first issuetype/bug

描述

Steps to reproduce the behavior (Required)

catalog CREATE EXTERNAL CATALOGjdbc_catalog_uat_180 PROPERTIES ("driver_class" = "com.mysql.cj.jdbc.Driver", "checksum" = "95cde01c78e7b04e13305338d60e056a", "driver_url" = "https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar", "type" = "jdbc", "user" = "root", "jdbc_uri" = "jdbc:mysql://ip:3306" )

mysql这个字段的类型 tinyint(1) unsigned DEFAULT '0'

Expected behavior (Required)

希望可以正确查询出数据

Real behavior (Required)

查询报错 ，提示 SQL 错误 [1064] [42000]: Type mismatches on column[house_manager_bonus_is_capped], JDBC result type is Integer, please set the type to one of tinyint,smallint,int,bigint: BE:10002

Image

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()

Image

贡献者指南

技术栈
javamysql
领域
database
议题类型
bug
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
half day
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
active
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
StarRocks JDBC catalog knowledgeMySQL tinyint(1) behaviorJava type mapping
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
40
研究方向
Investigate the StarRocks JDBC catalog type mapping implementation, likely in `fe/fe core/src/main/java/com/starrocks/catalog/JDBCResource.java` or similar. The MySQL JDBC driver maps `tinyint(1)` to `java.lang.Integer`, while StarRocks expects a specific integer subtype. Check the mapping logic and add a case to handle `tinyint(1)` as `tinyint` or `smallint` accordingly. Review any existing PRs or comments for prior work.