bug: Hash table capacity overflow

[hanyisong]

Search before asking

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

Version

8.0.26-v0.8.23-nightly-cbaedce-simd(rust-1.64.0-nightly-2022-09-02T16:39:41.032000394Z)

What's Wrong?

Code: 1104, displayText = Hash table capacity overflow.

How to Reproduce?

DROP DATABASE IF EXISTS databend14;
CREATE DATABASE databend14;
USE databend14;
CREATE TABLE t0(c0VARCHAR VARCHAR NULL, c1VARCHAR VARCHAR NULL DEFAULT(''));
CREATE TABLE t1(c0FLOAT DOUBLE NULL DEFAULT(0.35153302550315857));
INSERT INTO t0(c1varchar, c0varchar) VALUES ('', '7812'), ('4724475', '4');
INSERT INTO t1(c0float) VALUES (0.8140779137611389);
INSERT INTO t1(c0float) VALUES (0.4561707079410553), (0.4561707079410553), (0.7349682450294495);
INSERT INTO t0(c0varchar, c1varchar) VALUES ('', '3569'), ('21', '44965');
INSERT INTO t1(c0float) VALUES (0.45393189787864685);

MySQL [databend14]> select * from t0 inner join t1 ON (true IN ((('88')LIKE('87')), ('' BETWEEN '031' AND '0'), true, (NULL NOT IN (NULL, NULL, NULL)), ('098' BETWEEN '53' AND '941'))) where false;

ERROR 1105 (HY000): Code: 1104, displayText = Hash table capacity overflow.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[hanyisong]

@BohuTANG @sundy-li

[sundy-li]

Simple reproduce case:

SELECT *                                                                                                                                    
FROM                                                                                                                                        
    system.one a                                                                                                                                     
    INNER JOIN  system.one b ON 1 IN ( 1, NULL ) 
WHERE                                                                                                                                       
    FALSE;