On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,534 Users
  • 2,269,755 Discussions
  • 7,916,775 Comments

Discussions

wrong output returned by where clause in timesten

PACHAURI ABHISHEK
PACHAURI ABHISHEK Member Posts: 80
edited May 19, 2016 12:47AM in TimesTen In-Memory Database

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.

Answers

This discussion has been closed.