Weird sql response, could not explain

From: dd yakkali <dd.yakkali@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 26 Jul 2010 16:12:09 -0700

Can someone help me explain this weird behaviour.

when a subquery has a syntactical error what happens to the parent query.



select job_id , job_run_id , job_run_status_id

from job_runs
where dataset_date = trunc(sysdate)
and job_id in

  ( select job_id from load_job_profiles where load_job_profile_id = 33244 )
and job_run_status_id <> 6
...
  1714260   77168858                11
   1714260   77168859                 7
   1714260   77168860                 7
   1714260   77168862                11
   1714260   77168863                 7
   1714260   77168865                 7
   1714260   77168868                11
   1714260   77168869                 7
.....
gives me bunch of results.


where as I run


select job_id from load_job_profiles where load_job_profile_id = 33244

ERROR at line 1:
ORA-00904: "JOB_ID": invalid identifier

Thanks
Deen

Follow-Ups:

Re: Weird sql response, could not explain
From: Daniel Fink

Weird sql response, could not explain

Other related posts: