Re: Inconsistent Query Results

True about the nulls.

I could not re-produce your error:

SQL>drop index tcomputer_os_name
  2 /

Index dropped.

SQL>select * from ttcno_compliance tc
  2 where exists (
  3 select * from tcomputer
  4 where computer_sys_id = tc.computer_sys_id   5 and os_name = 'SunOS')
  6 /

TCNO_ENTRY_ID COMPUTER_SYS S
------------- ------------ -

            1 2159101373   X
           61 2159101373   X
          101 2159101373   X
          121 2159101373   X
          201 2159101373   X
            1 2159101490   X
           61 2159101490   X
          101 2159101490   X
          121 2159101490   X
          201 2159101490   X
          230 2159101490   X
          230 2159101373   X

12 rows selected.

SQL>create index tcomputer_os_name on tcomputer(os_name)   2 /

Index created.

SQL>analyze table tcomputer compute statistics   2 /

Table analyzed.

SQL>select * from ttcno_compliance tc
  2 where exists (
  3 select * from tcomputer
  4 where computer_sys_id = tc.computer_sys_id   5 and os_name = 'SunOS')
  6 /

TCNO_ENTRY_ID COMPUTER_SYS S
------------- ------------ -

            1 2159101373   X
           61 2159101373   X
          101 2159101373   X
          121 2159101373   X
          201 2159101373   X
            1 2159101490   X
           61 2159101490   X
          101 2159101490   X
          121 2159101490   X
          201 2159101490   X
          230 2159101490   X
          230 2159101373   X

12 rows selected.

SQL>

--
Posted via http://dbforums.com