with transform1 as (
.....
),
transform2 as (
select
F_KS_SALEENTRYGUID,
product_code,
product_name,
product_desc,
before_material_code,
before_material_desc,
after_material_code,
after_material_desc,
sum(before_product_formula_weight) as before_product_formula_weight,
sum(after_product_formula_weight) as after_product_formula_weight
from transform1
group by
F_KS_SALEENTRYGUID,product_code,product_name,product_desc,before_material_code,before_material_desc,after_material_code,after_material_desc
)
SELECT
t1.F_KS_SALEENTRYGUID
FROM transform2 t1
问题：
在cte中使用group by后，只查询group by分组字段报错Could not find function eq, arg Int8 return
Nullable(UInt8)，
导致我在后续对transform1 进行链接查询时 无法join 分组键
left join product t3 on t3.F_ORA_TEXT = t1.F_KS_SALEENTRYGUID
会出现报错
使用
SELECT
t1.*
FROM transform2 t1
不报错
使用
SELECT
t1.F_KS_SALEENTRYGUID, t1.before_product_formula_weight
FROM transform2 t1
不报错
使用
SELECT
F_KS_SALEENTRYGUID,product_code,product_name,product_desc,before_material_code,before_material_desc,after_material_code,after_material_desc
FROM transform2 t1
报错Could not find function eq, arg Int8 return Nullable(UInt8)
FE报错内容：
[HY000][1105] errCode = 2, detailMessage =
(xxx.xxx.xxx.xxx)[INTERNAL_ERROR]Could not find function eq, arg Int8 return
Nullable(UInt8)
日志：
[query]
|Client=172.168.9.138:18945|User=user_102748|Ctl=internal|Db=|CommandType=Query|State=ERR|ErrorCode=1105|ErrorMessage=errCode
= 2, detailMessage = (192.168.1.59)[INTERNAL_ERROR]Could not find function eq,
arg Int8 return Nullable(UInt8)
|Time(ms)=77|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=2846829|QueryId=19743d799d814ac7-9781e78ee2f42355|IsQuery=true|IsNereids=true|FeIp=192.168.1.59|StmtType=SELECT|Stmt=/*
ApplicationName=PyCharm 2024.3.5 */ WITH\r\n relation1 AS (\r\n
SELECT\r\n t1.bomviewaltsuid bom_version,\r\n t1.BOMUSAGE
AS F_KS_SALEENTRYGUID,\r\n t3.itemid AS parent_material_id,\r\n
t3.itemcode AS parent_material_code,\r\n t3.itemname AS
parent_material_name,\r\n t3.itemdesc AS parent_material_desc,\r\n
t4.itemid AS child_material_id,\r\n t4.itemcode AS
child_material_code,\r\n t4.itemname AS child_material_name,\r\n
t4.itemdesc AS child_material_desc,\r\n t2.QTY AS qty,\r\n
t2.QTY_BASE AS qty_base,\r\n t2.BADRATE AS loss\r\n
FROM\r\n CPCBASE.CPCBOMD t2\r\n LEFT JOIN CPCBASE.CPCBOM
t1 ON t1.bomid = t2.bomid\r\n LEFT JOIN CPCBASE.CPCITEM t3 ON
t1.asmid = t3.itemid\r\n LEFT JOIN CPCBASE.CPCITEM t4 ON t2.itemid =
t4.itemid\r\n where\r\n t2.QTY_BASE != 0\r\n and
t2.BADRATE != 100\r\n ),\r\n bom_path as (\r\n SELECT\r\n
COALESCE(L6.bom_version, L5.bom_version, L4.bom_version, L3.bom_version,
L2.bom_version, L1.bom_version, L0.bom_version) AS bom_version,\r\n
COALESCE(\r\n L6.F_KS_SALEENTRYGUID,\r\n
L5.F_KS_SALEENTRYGUID,\r\n L4.F_KS_SALEENTRYGUID,\r\n
L3.F_KS_SALEENTRYGUID,\r\n L2.F_KS_SALEENTRYGUID,\r\n
L1.F_KS_SALEENTRYGUID,\r\n L0.F_KS_SALEENTRYGUID\r\n
) AS F_KS_SALEENTRYGUID,\r\n COALESCE(\r\n
L6.parent_material_id,\r\n L5.parent_material_id,\r\n
L4.parent_material_id,\r\n L3.parent_material_id,\r\n
L2.parent_material_id,\r\n L1.parent_material_id,\r\n
L0.parent_material_id\r\n ) AS parent_material_id,\r\n
COALESCE(\r\n L5.parent_material_code,\r\n
L4.parent_material_code,\r\n L3.parent_material_code,\r\n
L2.parent_material_code,\r\n
L1.parent_material_code,\r\n L0.parent_material_code\r\n
) AS parent_material_code,\r\n COALESCE(\r\n
L5.parent_material_name,\r\n L4.parent_material_name,\r\n
L3.parent_material_name,\r\n
L2.parent_material_name,\r\n L1.parent_material_name,\r\n
L0.parent_material_name\r\n ) AS parent_material_name,\r\n
COALESCE(\r\n L5.parent_material_desc,\r\n
L4.parent_material_desc,\r\n L3.parent_material_desc,\r\n
L2.parent_material_desc,\r\n
L1.parent_material_desc,\r\n L0.parent_material_desc\r\n
) AS parent_material_desc,\r\n COALESCE(\r\n
L5.child_material_id,\r\n L4.child_material_id,\r\n
L3.child_material_id,\r\n L2.child_material_id,\r\n
L1.child_material_id,\r\n L0.child_material_id\r\n
) AS child_material_id,\r\n L0.child_material_code AS
child_material_code,\r\n L0.child_material_name AS
child_material_name,\r\n L0.child_material_desc AS
child_material_desc,\r\n ifnull (L0.product_formula_weight, 1) *
ifnull (L1.product_formula_weight, 1) * ifnull (L2.product_formula_weight, 1) *
ifnull (L3.product_formula_weight, 1) * ifnull (L4.product_formula_weight, 1) *
ifnull (L5.product_formula_weight, 1) AS product_formula_weight,\r\n
COALESCE(L5.cj, L4.cj, L3.cj, L2.cj, L1.cj, L0.cj) AS cj\r\n FROM\r\n
(\r\n /* 第0层 - 基础层 */\r\n SELECT\r\n
bom_version,\r\n F_KS_SALEENTRYGUID,\r\n
parent_material_id,\r\n
parent_material_code,\r\n parent_material_name,\r\n
parent_material_desc,\r\n child_material_id,\r\n
child_material_code,\r\n
child_material_name,\r\n ... /* truncated
audit_plugin_max_sql_length=4096
*/|CpuTimeMS=0|ShuffleSendBytes=0|ShuffleSendRows=0|SqlHash=62503a731bd6a26c67efb6e5ab00a1bb|PeakMemoryBytes=1216|SqlDigest=|ComputeGroupName=UNKNOWN|WorkloadGroup=normal|FuzzyVariables=|ScanBytesFromLocalStorage=0|ScanBytesFromRemoteStorage=0
已尝试复现但未成功，全网找不到相关问题，期望得到回复解决
