doris create row policy未生效，哪位大神能帮忙看看，谢谢。

Viewed 40
2.0

doris使用了create row policy策略，发现策略未生效,哪位大神能帮忙看看，谢谢。

版本号：oris-2.0.1.1-ea0bfb2

策略：CREATE ROW POLICY test_row_policy_1 ON Test.city_code
AS RESTRICTIVE TO 'mytest'@'%' USING (city_code = 'BER');

测试结果无效：
MySQL [(none)]> select *from Test.city_code;
+-----------+-----------------+------+
| city_code | city_name | id |
+-----------+-----------------+------+
| BER | 柏林 | 18 |
| BFS | 贝尔法斯特 | 53 |
| BGY | 米兰 | 57 |
| BHD | 贝尔法斯特 | 52 |
......................

cmingyong.chen11
4 Answers

用了高版本的验证没问题，应该是低版本不支持吧

cmingyong.chen11

explain 查看改写后的 SQL，然后你现在这个版本比较老了，有规划升级到2.0的最新版本吗？更稳定

徐振超@SelectDB5016

官网文档说是 1.2+就支持该功能了， 但我这个2.0.1.1版本测试没什么效果,是版本的原因吗？

另外，explain 也看不到改写后的sql:
MySQL [(none)]> explain select *from Test.city_code ;
+-------------------------------------------------------------------------------------------------------------+
| Explain String |
+-------------------------------------------------------------------------------------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS: |
| city_code[#5] |
| city_name[#6] |
| id[#7] |
| PARTITION: UNPARTITIONED |
| |
| VRESULT SINK |
| |
| 1:VEXCHANGE |
| offset: 0 |
| |
| PLAN FRAGMENT 1 |
| |
| PARTITION: HASH_PARTITIONED: city_code[#0] |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 01 |
| UNPARTITIONED |
| |
| 0:VOlapScanNode |
| TABLE: default_cluster:Test.city_code(city_code), PREAGGREGATION: ON |
| PREDICATES: DORIS_DELETE_SIGN[#3] = 0 |
| partitions=1/1, tablets=1/1, tabletList=13264635 |
| cardinality=71, avgRowSize=212.11267, numNodes=3 |
| pushAggOp=NONE |
| projections: city_code[#0], city_name[#1], id[#2] |
| project output tuple id: 1 |
+-------------------------------------------------------------------------------------------------------------+
28 rows in set (0.01 sec)

cmingyong.chen11

2.0.1.1上看起来用的是新优化器？旧优化器有问题么

zhangdong76