Search before asking
Version
2.1.10
What's Wrong?
[INTERNAL_ERROR]VSlotRef customerId have invalid slot id: 338
What You Expected?
return sql result
How to Reproduce?
No response
Anything Else?
SELECT *
,GREATEST(LEAST(allMaxFinallyInterest - 0.5, after_irr, 2)) AS after_irr_f
,LEAST(300000, GREATEST(currAccountLimit + 10000, after_limit* 10000)) AS after_limit_m
FROM (
SELECT *,
ROUND(CAST((RAND() * (4.1 - 2.0) + 2.0) AS DECIMAL), 1) AS after_irr,
ROUND(CAST((RAND() * (30.0 - 16.0) + 16.0) AS DECIMAL), 1) AS after_limit
FROM rm_idt.myt_offline_zj_raw_20251030_veri_online_lx_pre
) AS a
limit 100;
Are you willing to submit PR?
Code of Conduct