[Bug] [nereids2.1.10] VSlotRef postLoanLevelF have invalid slot

[Toms1999]

Search before asking

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

Version

CREATE TABLE syq_dt_limitdown_25july_plf3n4_base (
customer_id varchar(65533) NULL,
ods_day date NULL,
product_code varchar(128) NULL,
did varchar(65533) NULL,
lcOwnership varchar(65533) NULL,
postloanAmountV2ModelPostLoan varchar(65533) NULL,
finalBaseLimitV3 varchar(65533) NULL,
ifMob6NewCust varchar(65533) NULL,
cjdjxjType varchar(65533) NULL,
applyWhiteListType2 varchar(65533) NULL,
isSupportDxmPriceAdjust varchar(65533) NULL,
ppsCustIsFgMode varchar(65533) NULL,
noAdjustCustGroupCodeSvc varchar(65533) NULL,
noAdjustTypeSvc varchar(65533) NULL,
ifStaff varchar(65533) NULL,
employedInd varchar(65533) NULL,
whiteListType varchar(65533) NULL,
customerlabels varchar(65533) NULL,
reLaJXJpoolHlgroup varchar(65533) NULL,
relaselfTag varchar(65533) NULL,
ifInterestfeeWhiteList varchar(65533) NULL,
userHandOutMode varchar(65533) NULL,
offlineAllCustTag varchar(65533) NULL,
adjustPolicyCode varchar(65533) NULL,
plmTransRiscode varchar(65533) NULL,
postLoanLevelF varchar(65533) NULL,
combinedB16S12ThickSeg varchar(65533) NULL,
limitDownCustLevel varchar(65533) NULL,
creditLimit varchar(65533) NULL,
cz3IncomeOri varchar(65533) NULL,
jxjUserLoseDays varchar(65533) NULL,
minigroupTag varchar(65533) NULL,
isSupportDxmQuotaAdjust varchar(65533) NULL,
isBusinessCust varchar(65533) NULL,
ifInAutiMoneyBackList varchar(65533) NULL,
ifCharityUser varchar(65533) NULL,
relcustomerLabelsXW varchar(65533) NULL,
negCustProtectDate varchar(65533) NULL,
reLaPassResultFxTime varchar(65533) NULL,
reLaXsGreenPassTime varchar(65533) NULL,
reLaMisPassTimeOfReoffer varchar(65533) NULL,
lastReduceJXJDate varchar(65533) NULL,
limitDownDateFinal varchar(65533) NULL,
lastgrantRiskLineJXJDate varchar(65533) NULL,
lastTransReduceLimitDate varchar(65533) NULL,
lastEnhanceJXJDate varchar(65533) NULL,
limitUpDate varchar(65533) NULL,
oldAdjustTime varchar(65533) NULL,
lastEnLimitTime varchar(65533) NULL,
dhLaBefAdjPriceDir varchar(65533) NULL,
dhLaBefAdjPriceTime varchar(65533) NULL,
lastAdjustPriceSucTime varchar(65533) NULL,
priceDownDate varchar(65533) NULL,
priceUpDateFinal varchar(65533) NULL,
prcidAllIfClear varchar(65533) NULL,
tempPriceEndDate varchar(65533) NULL,
tempMaxFinallyInterest varchar(65533) NULL,
allMaxFinallyInterest varchar(65533) NULL,
tempValidCreditLimitAll varchar(65533) NULL,
currAccountLimit varchar(65533) NULL,
cz4IncomeOri varchar(65533) NULL,
zx2LoanExceptPAmt2 varchar(65533) NULL,
assetTotalNetValue varchar(65533) NULL,
postloanAmountV4ModelAmount varchar(65533) NULL,
postLoanThin2LevelF varchar(65533) NULL,
prcidIfClearJXJ varchar(65533) NULL,
combinedB18S12ThickSegXf varchar(65533) NULL,
combinedB18S12ThinSegXf varchar(65533) NULL,
combinedB18S12MidSegXf varchar(65533) NULL,
validTextCouponTemplatesAndExpiryTimeNRT text NULL,
if_sanbao text NULL,
sb_expiry_date varchar(65533) NULL,
rn bigint NULL,
liushi_flag text NULL,
cur_limit_tag text NULL,
mix_now_price decimal(38,9) NULL,
limit_now_all decimal(43,13) NULL,
neg_cp_pass_flag tinyint NULL,
neg_zx_pass_flag tinyint NULL,
neg_xs_pass_flag tinyint NULL,
mis_pass_reoffer_flag tinyint NULL,
reduce_flag tinyint NULL,
enhance_flag tinyint NULL,
reduceprice_flag tinyint NULL,
increaseprice_flag tinyint NULL,
lx_plmtrans text NULL,
rl_avlb_str text NULL,
rl_bottom_aftervalue smallint NULL,
rl_entry_liushi_thin text NULL,
rl_entry_liushi_thick text NULL,
rd_rl_pre_entry double NULL
) ENGINE=OLAP
DUPLICATE KEY(customer_id)
DISTRIBUTED BY HASH(customer_id) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.group_hbb: 2, tag.location.group_hba: 2",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);

What's Wrong?

ERROR 1105 (HY000): errCode = 2, detailMessage = (10.72.121.11)[INTERNAL_ERROR]VSlotRef postLoanLevelF have invalid slot id: 92, desc: tuple_desc_map: [Tuple(id=0 slots=[Slot(id=0 type=VARCHAR col=-1, colname=customer_id, nullable=1)] has_varlen_slots=1)] tuple_id_map: [0] tuple_is_nullable: [0] , slot_desc: Slot(id=92 type=VARCHAR col=-1, colname=postLoanLevelF, nullable=1), desc_tbl: tuples:
Tuple(id=11 slots=[Slot(id=290 type=VARCHAR col=-1, colname=postLoanLevelF, nullable=1), Slot(id=291 type=STRING col=-1, colname=rl_en

What You Expected?

run

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[Toms1999]

WITH base1 as (
select
*,
case
when rd_rl_pre_entry <= 0.27 then RANDOM()
else -9999
end as rd_rl_exp
from rm_idt.syq_dt_limitdown_25july_plf3n4_base
),
base as (
select
*,
case
when rd_rl_exp<0 then ''
when rd_rl_exp<=0.2 then '0.'
when rd_rl_exp<=0.4 then '1.%'
when rd_rl_exp<=0.6 then '2.%'
when rd_rl_exp<=0.8 then '3.%'
else '4.降幅80%'
end as exp_tag,
case
when rd_rl_exp<0 then ''
when rd_rl_exp<=0.2 then (CAST(currAccountLimit AS DECIMAL) / 100)
when rd_rl_exp<=0.4 then greatest((CAST(currAccountLimit AS DECIMAL) / 100)*0.8, cast(rl_bottom_aftervalue as DECIMAL))
when rd_rl_exp<=0.6 then greatest((CAST(currAccountLimit AS DECIMAL) / 100)*0.6, cast(rl_bottom_aftervalue as DECIMAL))
when rd_rl_exp<=0.8 then greatest((CAST(currAccountLimit AS DECIMAL) / 100)*0.4, cast(rl_bottom_aftervalue as DECIMAL))
else greatest((CAST(currAccountLimit AS DECIMAL) / 100)*0.2, cast(rl_bottom_aftervalue as DECIMAL))
end as after_value_moni
from base1
)

SELECT
postLoanLevelF,
rl_entry_liushi_thick,
rl_entry_liushi_thin,
postLoanThin2LevelF,
exp_tag,
CASE
when rd_rl_exp<0 then ''
when rd_rl_exp<=0.2 then '0.'
when rd_rl_exp>0.2 and (CAST(currAccountLimit AS DECIMAL) / 100) <= cast(after_value_moni as DECIMAL) then ''
else ''
end as if_rl_available,
count(customer_id) as cnt,
sum(cast(limit_now_all AS DECIMAL)) as limit_now_all,
sum(cast(after_value_moni as DECIMAL)) as after_value,
sum(mix_now_price) as mix_now_price

FROM base
GROUP BY 1,2,3,4,5,6;

[924060929]

the shortest sql which can reproduce this bug:

set disable_nereids_rules='PRUNE_EMPTY_PARTITION';
select
  case
    when rd_rl_exp<=0.2 then 1
    when rd_rl_exp<=0.8 then 1
    else 1
  end as after_value_moni
from
(
    select
      random() rd_rl_exp
      from syq_dt_limitdown_25july_plf3n4_base
)a;

[yujun777]

fix pr: #40176