[Bug] [跨表准确性检查] 表别名超过数据库限制

[anan0120]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

测试数据源：oracle
跨表准确性检查
1、当Oracle表名太长，再拼数据库+表名+数字，表名超过数据库限制
SELECT '1' AS id FROM dual database_F_1111111_11111111_RECORD_1
报错内容：SQL 错误 [972] [42000]: ORA-00972: 标识符过长
2、当比较字段是数字类型使时，用coalesce准换报错
SELECT * FROM (SELECT 1 AS id1,2 AS id2 FROM dual) WHERE coalesce(id1, '')=coalesce(id2, '')
报错内容：ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 CHAR

    3、希望支持自定义SQL，这样两个表对比会更灵活

DataVines Version

datavines-release-1.0.0-rc

DataVines Config

详情见：what happened.

Running Command

详情见：what happened.

Error Exception

详情见：what happened.

Engine Type

No response

Java Version

No response

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!