I noticed an interesting Bug on MOS today. When running an Aggregation against an Expression that has a Function Based Index, results may be truncated. The bug notes that dumps and internal errors are also possible.
Here's a demo. (tested in 11.2.0.2)
Start with a table and an FBI
Here's a demo. (tested in 11.2.0.2)
Start with a table and an FBI
SQL> create table test_10013177 (col_1 number(6,4));
Table created.
SQL> insert into test_10013177 values (12.3456);
1 row created.
SQL> create index index_10013177 on test_10013177(col_1+1);
Index created.
SQL>
SQL> exec dbms_stats.gather_table_stats('','TEST_10013177');
PL/SQL procedure successfully completed.
SQL> select col_1+1 from test_10013177;
COL_1+1
----------
13.3456
SQL> select max(col_1+1) from test_10013177;
MAX(COL_1+1)
------------
13.3456
SQL> select /*+ full (t) */ max(col_1+1) from test_10013177 t;
MAX(COL_1+1)
------------
13
SQL>
Funnily, the results in the last query are truncated !.
.
.
No comments:
Post a Comment