-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.17.0
-
Component/s: None
-
Labels:None
CaseShuttle may make the optimization but the functions return value doesn't depend on that.
For the following query the =1 is not pushed into the case.
select empno from emp where case when sal > 1000 then empno else sal end = 1
- links to