sql - 查询适用于 Oracle 10g 但不适用于 11g？

Question

DECLARE
  trn  VARCHAR2(2) := 'DD';
  cur  SYS_REFCURSOR;
BEGIN
  OPEN cur FOR
    SELECT
      TRUNC(some_date, trn),
      NULL AS dummy_2,
      COUNT( DISTINCT dummy_1 )
    FROM
      (SELECT SYSDATE AS some_date, ROWNUM AS dummy_1 FROM dual)
    GROUP BY
      TRUNC(some_date, trn);
END;

这适用于 Oracle 10，但适用于 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production结果是:

ORA-00979: not a GROUP BY expression
ORA-06512: at line 5

任何人都可以重现/解释这一点吗？谢谢!

Answer 1

如果您有权获得支持，它看起来像 Bug 9478304: LOOP FAILING WITH ORA-00979: NOT A GROUP BY EXPRESSION .这似乎只影响 11.2.0.1。