Peculiar results from a simple looking query.

From: Steve H <netspam_at_shic.co.uk>
Date: 24 Feb 2005 09:45:47 -0800
Message-ID: <eb2f38f3.0502240945.2948946@posting.google.com>

I've stumbled upon a peculiar result when querying Oracle which I have not experienced with other DBMS. Consider this example:

create table atable(field varchar(20))
insert into atable values ('This is a test') select field from atable where cast(field as varchar(2))='Th'

Other DBMS return the single row:

This is a test

Oracle 9.2.10, however generates this result:

Is this a widely known issue with Oracle? Can I change Oracle's behaviour by tweaking configuration or applying a patch? Is this a bug? Received on Thu Feb 24 2005 - 11:45:47 CST