为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.1.2.192
【操作系统】:window
【CPU】:
【问题描述】*:
通过dm8驱动获取含有interval类型字段的元数据信息,发现scale值不正确;并使用dm7驱动做了对比,如下:
-- 创建表DDL
CREATE TABLE "TESTX"."TABLE_1"
(
"COLUMN_1" TIMESTAMP(6) WITH LOCAL TIME ZONE,
"COLUMN_2" TIME(6) WITH TIME ZONE,
"COLUMN_3" DATETIME(6) WITH TIME ZONE,
"COLUMN_4" DATETIME(6) WITH TIME ZONE,
"COLUMN_5" DATETIME(6) WITH TIME ZONE,
"COLUMN_6" INTERVAL YEAR(2) DEFAULT 0,
"COLUMN_7" INTERVAL YEAR(2) TO MONTH,
"COLUMN_8" INTERVAL MONTH(2),
"COLUMN_9" INTERVAL DAY(2),
"COLUMN_10" INTERVAL DAY(2) TO HOUR,
"COLUMN_11" INTERVAL DAY(2) TO MINUTE,
"COLUMN_12" INTERVAL DAY(2) TO SECOND(6),
"COLUMN_13" INTERVAL MINUTE(2),
"COLUMN_14" INTERVAL MINUTE(2) TO SECOND(5),
"COLUMN_15" INTERVAL SECOND(3, 5)) STORAGE(ON "MAIN", CLUSTERBTR) ;
DM8驱动返回结果(版本8.1.2.192)
COLUMN_1(26,6)
COLUMN_2(7,6)
COLUMN_3(10,6)
COLUMN_4(10,6)
COLUMN_5(10,6)
COLUMN_6(2,38)
COLUMN_7(2,294)
COLUMN_8(2,550)
COLUMN_9(2,806)
COLUMN_10(2,1062)
COLUMN_11(2,1318)
COLUMN_12(2,1574)
COLUMN_13(2,2598)
COLUMN_14(2,2853)
COLUMN_15(3,3125)
DM7驱动返回结果(版本4.0.7.1.6.48 (Build 2018.03.01))
COLUMN_1(26,6)
COLUMN_2(7,6)
COLUMN_3(10,6)
COLUMN_4(10,6)
COLUMN_5(10,6)
COLUMN_6(2,6)
COLUMN_7(2,6)
COLUMN_8(2,6)
COLUMN_9(2,6)
COLUMN_10(2,6)
COLUMN_11(2,6)
COLUMN_12(2,6)
COLUMN_13(2,6)
COLUMN_14(2,5)
COLUMN_15(3,5)
换这个驱动试试
dm8-15208-20230131-jdbc.zip