wrong output returned by where clause in timesten

PACHAURI ABHISHEK

Dear All,

I have created a view OIB_VIEW in timesten which uses UNION, CASE statement and NVL function. There is a column OIB_USER_ID in the view. I am doing below select queries.

select distinct OIB_USER_ID from OIB_VIEW; -- which gives two IDs '7' and '17' .

select * from OIB_VIEW; -- which gives 43 rows, It is correct.

select * from OIB_VIEW where OIB_USER_ID=17 -- which gives 24 rows but there are 38 rows in actual.

select * from OIB_VIEW where OIB_USER_ID=7 -- which gives 1 row but there are 5 rows in actual.

when I am using "where condition = value" it is giving wrong output. however if I use "where condition like value"  It gives correct output. For eg if I use

select * from OIB_VIEW where OIB_USER_ID like '17' -- it gives 38 rows which is correct.

Plz help why timesten and oracle behave differently.

ChrisJenkins-Oracle

The may be a bug. What is the exact TimesTen version that you are using (output of ttVersion command)?

Thanks,  Chris

PACHAURI ABHISHEK

Dear Chris,

TimesTen Release 11.2.2.8.0 (64 bit Linux/x86_64) (TT_NOMDEMO:53396) 2015-01-20T08:36:31Z

ChrisJenkins-Oracle

Can you please try with the latest release (11.2.2.8.12). If you get incorrect results with that then please log an SR with Oracle support so that this can be investigated.

Thanks,

Chris

PACHAURI ABHISHEK

Ok. Thanks Chris.