12c: 2+2=3

[oracle@stormking cdb12102 partition]$ sqlplus /nolog @ conn.u.sql

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 1 00:18:26 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected.
SQL> host cat results4.sql
drop table t ;
create table t (
        p number,
        i number
)
partition by list (p) (
        partition p3 values (3),
        partition p4 values (4)
);

insert into t ( p, i) values ( 3, 3 );
insert into t ( p, i) values ( 4, 4 );

select distinct p "2+2=" from t where i = ( select min(i) from t where p = 2 + 2);

create index i on t (i);

select distinct p "2+2=" from t where i = ( select min(i) from t where p = 2 + 2);

SQL> @ results4.sql

Table dropped.


Table created.


1 row created.


1 row created.


      2+2=
----------
         4


Index created.


      2+2=
----------
         3