Runtime error when using overflow integers

[suyZhong]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t0(c1 INT);
CREATE VIEW v0(c0) AS SELECT 142805906 FROM t0 ;

SELECT * FROM v0 WHERE (v0.c0 NOT IN (v0.c0, (CASE ((-9223372036854775808)+(-1582704113)) WHEN v0.c0 THEN v0.c0 END )));

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

No error

3. What did you see instead (Required)

ERROR 1105 (HY000): runtime error: invalid memory address or nil pointer dereference

server log:

github.com/pingcap/tidb/pkg/server.(*clientConn).Run.func1
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/conn.go:1024
runtime.gopanic
        /usr/local/go/src/runtime/panic.go:914
github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile.func1
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/executor/compiler.go:56
runtime.gopanic
        /usr/local/go/src/runtime/panic.go:914
runtime.panicmem
        /usr/local/go/src/runtime/panic.go:261
runtime.sigpanic
        /usr/local/go/src/runtime/signal_unix.go:861
github.com/pingcap/tidb/pkg/expression.inferCollation
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/expression/collation.go:372
github.com/pingcap/tidb/pkg/expression.CheckAndDeriveCollationFromExprs
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/expression/collation.go:304
github.com/pingcap/tidb/pkg/expression.ColumnSubstituteImpl
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/expression/util.go:492
github.com/pingcap/tidb/pkg/planner/core.(*LogicalProjection).PredicatePushDown
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/rule_predicate_push_down.go:531
github.com/pingcap/tidb/pkg/planner/core.(*LogicalSelection).PredicatePushDown
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/rule_predicate_push_down.go:109
github.com/pingcap/tidb/pkg/planner/core.(*baseLogicalPlan).PredicatePushDown
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/rule_predicate_push_down.go:82
github.com/pingcap/tidb/pkg/planner/core.(*LogicalProjection).PredicatePushDown
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/rule_predicate_push_down.go:538
github.com/pingcap/tidb/pkg/planner/core.(*ppdSolver).optimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/rule_predicate_push_down.go:47
github.com/pingcap/tidb/pkg/planner/core.logicalOptimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/optimizer.go:1169
github.com/pingcap/tidb/pkg/planner/core.doOptimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/optimizer.go:328
github.com/pingcap/tidb/pkg/planner/core.DoOptimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/core/optimizer.go:370
github.com/pingcap/tidb/pkg/planner.optimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/optimize.go:505
github.com/pingcap/tidb/pkg/planner.Optimize
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/planner/optimize.go:336
github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/executor/compiler.go:104
github.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/session/session.go:2185
github.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/driver_tidb.go:294
github.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/conn.go:2024
github.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/conn.go:1775
github.com/pingcap/tidb/pkg/server.(*clientConn).dispatch
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/conn.go:1349
github.com/pingcap/tidb/pkg/server.(*clientConn).Run
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/conn.go:1122
github.com/pingcap/tidb/pkg/server.(*Server).onConn
        /home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/pkg/server/server.go:713

4. What is your TiDB version? (Required)

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v8.0.0-alpha
Edition: Community
Git Commit Hash: 7801b91
Git Branch: heads/refs/tags/v8.0.0-alpha
UTC Build Time: 2024-01-16 14:30:54
GoVersion: go1.21.5
Race Enabled: false
Check Table Before Drop: false
Store: unistore |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[suyZhong]

/label fuzz/sqlancer

[kennedy8312]

Seeing the error on v5.4.0 with the same testcase as well.