Re: COALESCE does short circuit - NOT
- From: rjamya <rjamya@xxxxxxxxx>
- To: uwe@xxxxxxxxxxxx, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2012 10:57:50 -0500
I am guessing that happens because seq_test.nextval is treated like a
function whose value is unknown, so it must be evaluated before null
check can be performed.
like I said, I am just guessing, this is probably true with any non
constant value, although I have not tested it.
Raj
2012/1/19 "Uwe Küchler" <uwe@xxxxxxxxxxxx>:
> "Short Circuit" means, the database evaluates each expr value and
> determines whether it is NULL, rather than evaluating all of the expr
> values before determining whether any of them is NULL.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
