runtime error: index out of range [0] with length 0 by `RAND()`

[suyZhong]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE  TABLE  t0(c0 INTEGER); 
CREATE VIEW v0(c0) AS SELECT 'a' FROM t0 WHERE (CASE t0.c0 WHEN t0.c0 THEN false END );

SELECT t0.c0 FROM v0, t0 WHERE RAND();

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

No error.

3. What did you see instead (Required)

ERROR 1105 (HY000): runtime error: index out of range [0] with length 0

and server log:

pkg/server.(*clientConn).Run.func1
 /workspace/source/tidb/pkg/server/conn.go:1044
runtime.gopanic
 /usr/local/go/src/runtime/panic.go:914
github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile.func1
 /workspace/source/tidb/pkg/executor/compiler.go:58
runtime.gopanic
 /usr/local/go/src/runtime/panic.go:914
runtime.goPanicIndex
 /usr/local/go/src/runtime/panic.go:114
github.com/pingcap/tidb/pkg/planner/core.findPredicateType
 /workspace/source/tidb/pkg/planner/core/rule_predicate_simplification.go:44
github.com/pingcap/tidb/pkg/planner/core.applyPredicateSimplification
 /workspace/source/tidb/pkg/planner/core/rule_predicate_simplification.go:123
github.com/pingcap/tidb/pkg/planner/core.(*DataSource).PredicateSimplification /workspace/source/tidb/pkg/planner/core/logical_datasource.go:287
github.com/pingcap/tidb/pkg/planner/core/operator/logicalop.(*BaseLogicalPlan).PredicateSimplification
 /workspace/source/tidb/pkg/planner/core/operator/logicalop/base_logical_plan.go:178
github.com/pingcap/tidb/pkg/planner/core/operator/logicalop.(*BaseLogicalPlan).PredicateSimplification
 /workspace/source/tidb/pkg/planner/core/operator/logicalop/base_logical_plan.go:178
github.com/pingcap/tidb/pkg/planner/core/operator/logicalop.(*BaseLogicalPlan).PredicateSimplification
 /workspace/source/tidb/pkg/planner/core/operator/logicalop/base_logical_plan.go:178
github.com/pingcap/tidb/pkg/planner/core.(*PredicateSimplification).Optimize
 /workspace/source/tidb/pkg/planner/core/rule_predicate_simplification.go:71
github.com/pingcap/tidb/pkg/planner/core.logicalOptimize
 /workspace/source/tidb/pkg/planner/core/optimizer.go:978
github.com/pingcap/tidb/pkg/planner/core.doOptimize
 /workspace/source/tidb/pkg/planner/core/optimizer.go:259
github.com/pingcap/tidb/pkg/planner/core.DoOptimize
 /workspace/source/tidb/pkg/planner/core/optimizer.go:318
github.com/pingcap/tidb/pkg/planner.optimize
 /workspace/source/tidb/pkg/planner/optimize.go:529
github.com/pingcap/tidb/pkg/planner.Optimize
 /workspace/source/tidb/pkg/planner/optimize.go:360
github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile
 /workspace/source/tidb/pkg/executor/compiler.go:101
github.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt
 /workspace/source/tidb/pkg/session/session.go:2097
github.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt
 /workspace/source/tidb/pkg/server/driver_tidb.go:291
github.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt
 /workspace/source/tidb/pkg/server/conn.go:2026
github.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery
 /workspace/source/tidb/pkg/server/conn.go:1779
github.com/pingcap/tidb/pkg/server.(*clientConn).dispatch
 /workspace/source/tidb/pkg/server/conn.go:1378
github.com/pingcap/tidb/pkg/server.(*clientConn).Run
 /workspace/source/tidb/pkg/server/conn.go:1147
github.com/pingcap/tidb/pkg/server.(*Server).onConn
 /workspace/source/tidb/pkg/server/server.go:741

4. What is your TiDB version? (Required)

select tidb_version();
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id: 2097166
Current database: database1

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v8.4.0-alpha-231-gae95f2f
Edition: Community
Git Commit Hash: ae95f2f
Git Branch: HEAD
UTC Build Time: 2024-09-24 10:39:17
GoVersion: go1.21.13
Race Enabled: false
Check Table Before Drop: false
Store: unistore |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[suyZhong]

/label fuzz/sqlancer