You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@doris.apache.org by 18 <18...@qq.com.INVALID> on 2024/01/15 01:11:23 UTC

doris无法读取MySQL double unsigned类型

doris版本：1.2.4.1

catalog创建语句：

CREATE CATALOG test PROPERTIES (

    "type"="jdbc",

    "user"="a",

    "password"="b",

    "jdbc_url" = "jdbc:mysql:// 111.11.1.111:3307",

    "driver_url" = "mysql-connector-java-8.0.28.jar",

    "driver_class" = "com.mysql.cj.jdbc.Driver"

);

mysql创建语句：

CREATE TABLE `sdata_project` (

  `id` int unsigned NOT NULL AUTO_INCREMENT,

  `building_area` double(11,2) unsigned DEFAULT NULL COMMENT '建筑面积',

  `is_deleted` tinyint unsigned DEFAULT '0' COMMENT '是否删除：0未删除；2已删除',

  PRIMARY KEY (`id`),

) ENGINE=InnoDB AUTO_INCREMENT=2830 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='项目表';

示例数据：





报错：