Repository navigation
runtime error: index out of range [0] with length 0 by RAND() #56270
Description
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)
Activity
suyZhong commentedon Sep 24, 2024
/label fuzz/sqlancer
planner: Fix predicate simplification panic caused by zero-argument e…
planner: Fix predicate simplification panic caused by zero-argument e…