bitmap_intersect Cannot return expected results[Bug]

[cnmrzhou]

Search before asking

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

Version

Take an extreme example:
select bitmap_to_string(bitmap_intersect(a.user_id)) from (select 'tag' as tag, bitmap_union(user_id) user_id from membership_tag_bitmap where tag = 'one_year_gross_profit' and value between '0.1' and '0.11' group by tag union all select 'tag' as tag, bitmap_union(user_id) user_id from membership_tag_bitmap where tag = 'one_year_gross_profit' and value between '0.1' and '0.11' group by tag) a

data:Hundreds of thousands of bits

Two copies of the same data.

But it's not just the same data

but,but:
select bitmap_intersect(a.user_id) from (select bitmap_from_string('1,2,3,4') user_id union all select bitmap_from_string('1,2,6,7')) a；
can return right result;

What's Wrong?

return null

What You Expected?

return right result

How to Reproduce?

No response

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