NVL error in query Oracle

Question

After updating the oracle the query below starts returning strange results, it should returns column with some values but returns null, after some twiching with the query, found that if I change t.event_id = d.event_id with t.event_id = 125162 query start working like before. Any advice?

SELECT LEAST (
          MAX (
             d.event_step
             - (CASE WHEN d.status IN (51, 52, 53) THEN 0 ELSE 2 END)),
          3)
          AS nextStep
  FROM x_events_step d
 WHERE d.event_id = 125162 AND d.state = 1
       AND d.event_step_id >
              NVL ( (SELECT MAX (t.event_step_id)
                       FROM x_events_step t
                      WHERE t.event_id = d.event_id AND t.state = 2),
                   0);

The 6th line is ok, found solution for the problem, upgrade oracle from 11.2.0.2 to 11.2.0.3 fixed. — Georgi Filipov, Dec 09 '11 at 23:07
Could you post your answer and then accept it as a solution in case anybody else comes across this in the future? — Peter, Dec 09 '11 at 23:27

score 1 · Accepted Answer · answered Dec 10 '11 at 08:19

1

After upgrade from Oracle 11.2.0.2 to 11.2.0.3 the problem was resolved.

answered Dec 10 '11 at 08:19

Georgi Filipov

332
2
18

NVL error in query Oracle

1 Answers1