标题: 为什么这个报告通过永洪云分享,双击笔刷联动会报错? [打印本页] 作者: songwanyu 时间: 2023-5-10 17:11 标题: 为什么这个报告通过永洪云分享,双击笔刷联动会报错? 执行数据失败:Related Dashboard: '【年审看板】20230510170907-1397' Related Query: '年审明细' Related Element: '图表1' Run user: '15346_SaaS'
Caused by: java.sql.SQLException 执行SQL失败:“VooltDB exception, code: 386, host: 10.0.16.6, port: 18233; Code: 386. DB::Exception: There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not: while executing 'FUNCTION equals(年检剩余月份 : 0, 6. : 1) -> equals(年检剩余月份, 6.) Nullable(UInt8) : 2'. (NO_COMMON_TYPE) (version 22.3.2.1)(in query:SELECT "车牌号" AS "LONG_COL_0", "机动车状态" AS "LONG_COL_1", COUNT("序号") AS "LONG_COL_2" FROM "default"."qry_D6febdb22__4e9b8aa.年审明细" WHERE ( "年检剩余月份" = 6.0 ) AND ( ( "城市" = '深圳' ) AND ( "区域" = '华南' )) GROUP BY "LONG_COL_0", "LONG_COL_1" ORDER BY "LONG_COL_0" ASC COLLATE 'zh', "LONG_COL_1" ASC COLLATE 'zh' LIMIT 5000000 FORMAT TabSeparatedWithNamesAndTypes;)..
”