wangbo opened a new pull request, #22828:
URL: https://github.com/apache/doris/pull/22828
## Proposed changes
```
drop TABLE if exists test1;
CREATE TABLE test1 (
dt1 date NOT NULL,
dt2 date NOT NULL,
id varchar(256) NULL,
type smallint(6) MAX NULL,
id_bitmap bitmap BITMAP_UNION NULL
) ENGINE = OLAP AGGREGATE KEY(dt1, dt2, id) PARTITION BY RANGE(dt1) (
PARTITION p20230725
VALUES
[('2023-07-25'), ('2023-07-26')))
DISTRIBUTED BY HASH(dt1, dt2) BUCKETS 1 properties("replication_num"="1");
insert into test1
select
str_to_date('2023-07-25','%Y-%m-%d') as dt1,
str_to_date('2023-07-25','%Y-%m-%d') as dt2,
'aaaaaaaaaa' as id,
1 as type,
BITMAP_HASH64('aaaaaaaaaa') as id_bitmap;
set experimental_enable_nereids_planner=false;
set experimental_enable_pipeline_engine = true;
select count(distinct id),
bitmap_count(orthogonal_bitmap_intersect(id_bitmap, type, 1)) as count2_bitmap
from test1;
```
Query will hang, because this sql contains two orthogonal_bitmap_intersect,
this is not correct usage.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
