Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
wrong output returned by where clause in timesten

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
-
ChrisJenkins-Oracle Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
The may be a bug. What is the exact TimesTen version that you are using (output of ttVersion command)?
Thanks, Chris
-
Dear Chris,
TimesTen Release 11.2.2.8.0 (64 bit Linux/x86_64) (TT_NOMDEMO:53396) 2015-01-20T08:36:31Z
-
ChrisJenkins-Oracle Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
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
-
Ok. Thanks Chris.