Skip to content

SQL with join failed to build executor #62212

Open
@joechenrh

Description

@joechenrh

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Found from instance plan cache test

drop table t1, t2 if exists;

create table t1 (c0 int, c1 int);

create table t2 (c0 int, c1 int);

select * from t1 join t2 on t1.c0 = t2.c0
	where t2.c1 = null or t2.c1 > 0 and t1.c1 > 0;

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

succeed

3. What did you see instead (Required)

ERROR 8118 (HY000): Failed to build executor   

4. What is your TiDB version? (Required)

15fe8f1

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions