Re: 8.1.5 primary key and like% goofiness

A copy of this was sent to khs_rider.x.mapson_at_geocities.com (Darren Mallette) (if that email address didn't require changing) On Wed, 26 May 1999 18:07:20 GMT, you wrote:

>>You need to post a tiny bit more information. For example -- here is an example
>>showing a query against a primary key using LIKE and it returns data:
>>when you say "we can't do a query ..." what exactly do you mean?
>
>We can run the query, it just doesn't return any rows when there are
>rows in the table that match the wildcard. This database was recently
>upgraded from 8.0.5 where the like% operator worked properly.
>
>Thanks again
>-Darren

Again -- please post a tiny bit more information:

• the describe of the table
• indexes on the table
• is it analyzed or not
• which optimizer are you using
• the text of the query which should return data but does not
• a query with some results showing the data you are querying does in fact exist so we can see what it looks like.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu May 27 1999 - 07:08:05 CDT