Error 1105 (HY000): interface conversion: expression.Expression is *expression.Constant, not *expression.ScalarFunction

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table lrr( `COL1` varchar(10) NOT NULL,`COL2` char(10) NOT NULL,PRIMARY KEY (`COL1`(5),`COL2`) /*T![clustered_index] CLUSTERED */);
insert into lrr values("","a");
insert into lrr values("test","b");
prepare stmt from 'SELECT * FROM lrr t1 JOIN lrr t2 ON t1.col1 <=> t2.col1 WHERE t1.col1 <=> NULL AND t2.col1 = ?;';
set @a=NULL;
execute stmt using @a;

2. What did you expect to see? (Required)

execute success

3. What did you see instead (Required)

ERROR 1105 (HY000): interface conversion: expression.Expression is *expression.Constant, not *expression.ScalarFunction

mysql execute success

4. What is your TiDB version? (Required)

Release Version: v8.4.0
Edition: Community
Git Commit Hash: 2205f33
Git Branch: HEAD
UTC Build Time: 2024-10-17 07:36:44
GoVersion: go1.23.2
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[apollodafoni]

/severity moderate

[apollodafoni]

/component parser

[apollodafoni]

/assign @hawkingrei
/label affects-8.4