CODEWITHSUNDEEP
sqloracle-database
Juanmi Ortega Cortizas
Juanmi Ortega Cortizas

Reputation: 5

Oracle 9i index error

I have the following query:

select *
from gps_servicio ser
where ser.id in (select idserv from gps_agentes where idagen = 8073061);

This query works perfectly until I make an index in the table gps_agentes, on the field idserv (asc one). If I do that, the query brokes and I get no results from it. Is this a bug? Both gps_servicio.id and gps_agentes.idserv are number(10,0) fields, and I have a FK on gps_agentes.idserv that points to gps_servicio.id.

Thx for your time!

Upvotes: 0

Views: 55

Answers (1)

Justin Cave
Justin Cave

Reputation: 231651

If the results of a query change when you create an index, that indicates a bug, yes. If you are encountering a bug, you would need to report that to Oracle Support to determine whether the bug you are encountering is already fixed by an existing patch or whether it is a new bug that no one has encountered before.

However, given that you say that you are using 9i, a version of the database that is at least 5 major releases old and has been out of primary support for many years, my wager is that you are running without a support contract and without access to Oracle Support. Are you at least running the latest patchset of whatever version of Oracle you are using ("9i" covers two major releases, 9.0.1 and 9.2)?

Upvotes: 2

Related Questions