Doris2.1.5版本Catalog查询MySQL5.7 INT类型字段 null值查询结果是0

Viewed 22

MySQL端:
CREATE TABLE doris_test (
id int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
insert into doris_test VALUES(null);

Doris端:
CREATE CATALOG jdbc_mysql PROPERTIES (
"user" = "test",
"use_meta_cache" = "false",
"type" = "jdbc",
"password" = "XXXX",
"jdbc_url" = "jdbc:mysql://XXXX:3306/XXX?yearIsDateType=false&tinyInt1isBit=false&transformedBitIsBoolean=true&useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8",
"driver_url" = "mysql-connector-java-5.1.47.jar",
"driver_class" = "com.mysql.jdbc.Driver"
);

1 Answers