Public signup for this instance is disabled. Go to our Self serve sign up page to request an account.
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