- 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
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.