Dear listers,
is this a known bug (version is 12.2.0.1) ?
SQL> create table t as (select date'2021-12-30' d from dual union all select date'2021-12-31' from dual);
Tabelle wurde erstellt.
SQL> select extract(year from d), count(*) from t group by extract(year from d);
EXTRACT(YEARFROMD) COUNT(*)
------------------ ----------
2021 2
SQL> alter table t add primary key(d);
Tabelle wurde geõndert.
SQL> select extract(year from d), count(*) from t group by extract(year from d);
EXTRACT(YEARFROMD) COUNT(*)
------------------ ----------
2021 1
2021 1
Thanks and a Happy New Year !
Matthias
--
//www.freelists.org/webpage/oracle-l