下面的这个语句在执行报表预览时报错,现在确定是因为数据的问题才报错的。
1、请帮助说明一下下面语句的意思
2、如何解决这种没有数据就报错的问题,是不是涉及到除 0 的问题了。
执行数据失败: Related Dashboard: '预览: 财务案例20220123085042-87' Related Query: '同比环比计算数据集' Related Element: '总负债环比' Run user: 'admin'
Caused by: java.sql.SQLException 执行SQL失败:“VooltDB exception, code: 62, host: 127.0.0.1, port: 8749; DB::Exception: Syntax error: failed at position 64 ('(') (line 2, col 16): ("liabilities_total") AS "LONG_COL_0"
FROM "default"."qry_Dbde37349__6ae907b6.同比环比计算数据集"
WHERE ( "FirstClassCompanyName" = '善' ). Expected one of: end of query, INTO OUTFILE, FORMAT, SETTINGS, UNION, FINAL, SAMPLE, LEFT ARRAY JOIN, INNER, ARRAY JOIN, JOIN, table, table function, subquery or list of joined tables, array join, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, SETTINGS, OFFSET (version 21.3.5.42)
”
|