[Bug] SQL execution failed with Unexpected exception: Index: 0, Size: 0

[genezx]

Search before asking

• I had searched in the issues and found no similar issues.

Version

1.2.6 && 2.0.1

What's Wrong?

SQL ERROR [1105] [HY000]: errCode = 2, detailMessage = Unexpected exception: Index: 0, Size: 0

What You Expected?

Query succeeds.

How to Reproduce?

CREATE TABLE `test1` (
  `order_sn` varchar(128) NOT NULL
) ENGINE=OLAP
UNIQUE KEY(`order_sn`)
DISTRIBUTED BY HASH(`order_sn`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"in_memory" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"disable_auto_compaction" = "false"
);

select 1
 from test1 t 
 left join test1 t2 on t.order_sn = t2.order_sn
 where 
  t.order_sn >= '1'
  and t.order_sn <= '0'
  or t2.order_sn >= '1' 
  and t2.order_sn <= '0'
;

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct