SQL拼接in条件

mysql> select distinct `_string_1` as `attr_value` from  event_789 where 1=1  and  event_id in ( 24832,24831 ) limit 20;
Empty set (0.06 sec)

mysql> select distinct `_string_1` as `attr_value` from  event_789 where 1=1  and  event_id in ( 24832 ) limit 20;
+------------+
| attr_value |
+------------+
| 广硕       |
+------------+
1 row in set (0.06 sec)

in条件拼接一个有结果,拼接2个反而没结果了,event_id数据类型是int
执行计划如下:


starrocks版本:1.16.0

麻烦发下profile。建议升级到最新版本,您这个版本太老了