Jan 10 2012, 07:07 AM
we have a strange symptom in a database Oracle 18.104.22.168 EE.
Following question comes from our application developers and I have no idea at the moment what is the reason for this problem ?!
The following SQL statement:
FROM cities cf,
WHERE cf.city_code = v.o_city_f
AND ct.city_code = v.o_city_t
AND k.status_ind = 'A'
AND k.nebv_hauv_kons_nr in ('122000200530775', '122000200637687', '122000200912502', '122000201499087', '122000201699090') AND v.kred_nr = k.kred_nr AND v.reporting_month >= k.valid_from AND v.reporting_month <= date_value(k.valid_until) AND v.reporting_month >= '01.04.2011'
AND v.reporting_month <= '30.09.2011'
AND 68861168 = 68861168
gives different result when we exchange the index ksr_valid_until_i on table kreditkarten_sets_rs. For some reasons we changed the index from bitmap to normal and are getting different results. Switchting back gives us the same results as before. When we avoid the usage of this index in the statement than we are getting the same results as when we are using the normal index.
Any ideas ?
Jan 10 2012, 11:30 AM
>> For some reasons we changed the index from bitmap to normal and are getting different results.Definitely a bug!
How many distinct values were in the index?
>> Select statement gives different results using bitmap or normal indexWow! Great catch!Inconsistent (incorrect) results are ALWAYS an Oracle bug!
See bug 889611 and 9495697 . . . .
You need tio start by looking on the Oracle bugs database:http://support.oracle.com
Please let us know the bug number, so we can warn others . . .
Jan 12 2012, 06:36 AM
thank you for your fast answer.
Will have a look in the Oracle bug database.
If I'll found some informations I'll post it asap.
Jan 12 2012, 12:03 PM
there are several bugs but the one that looks the most likely is 10067750, fixed in 22.214.171.124.
further investigations ongoing ....
With Best Regards
Jan 12 2012, 01:22 PM
>> bug 10067750, fixed in 126.96.36.199.
Thanks for the tip!
Oracke will tell you to upgrade, but if you cannot, you can write-up a "business case" and they may write you a one-off patch for your current release!
Getting "wrong" results is a serious issue, thanks for sharing it with our other readers!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here