使用NO_USE_HASH_AGGREGATION hint但是依然使用HASH算法

[小欧]

explain select /+NO_USE_HASH_AGGREGATION/ DISTINCT c1 from t1\G;
obclient [sjzt]> explain select /+NO_USE_HASH_AGGREGATION/ DISTINCT c1 from t1\G;
*************************** 1. row ***************************
Query Plan: ======================================
|ID|OPERATOR |NAME|EST. ROWS|COST|

|0 |HASH DISTINCT| |6 |4 | #虽然指定了NO_USE_HASH_AGGREGATION,但是还是使用了HASH算法。
|1 | TABLE SCAN |t1 |6 |2 | #可能是BUG;

Outputs & filters:

0 - output([t1.c1]), filter(nil), rowset=256,
distinct([t1.c1])
1 - output([t1.c1]), filter(nil), rowset=256,
access([t1.c1]), partitions(p0)

1 row in set (0.003 sec)

是否存在bug?

[xuyu]

请问使用的具体版本，另外看计划还是挺简单的，能把具体的schema和sql贴上，方便复现么

[mknull]

hint语法写错了吧，试试

explain select /*+ NO_USE_HASH_AGGREGATION */ DISTINCT c1 from t1\G;

[君野]

hint语法有误，参考：https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001581607