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