michaelmior

testReduceCompositeInSubQuery
select * from emp where (empno, deptno) in (   select empno, deptno from (     select empno, deptno     from emp     group by empno, deptno)) or deptno < 40 + 60
SELECT * FROM `CATALOG`.`SALES`.`EMP` WHERE (`EMPNO`, `DEPTNO`) IN (SELECT `EMPNO`, `DEPTNO` FROM `CATALOG`.`SALES`.`EMP` GROUP BY `EMPNO`, `DEPTNO`) OR `DEPTNO` < 100

testReduceNestedCaseWhen
select sal from emp where case when (sal = 1000) then (case when sal = 1000 then null else 1 end is null) else (case when sal = 2000 then null else 1 end is null) end is true
SELECT `SAL` FROM `CATALOG`.`SALES`.`EMP` WHERE CASE WHEN `SAL` = 1000 THEN `SAL` = 1000 ELSE `SAL` = 2000 END

testReduceOrCaseWhen
select sal from emp where case when sal = 1000 then null else 1 end is null OR case when sal = 2000 then null else 1 end is null

michaelmior

Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm

michaelmior

{

  "basics": {
    "name": "Michael Mior",
    "email": "mmior@cs.rit.edu",
    "phone": "(585) 475-5810",
    "website": "https://michael.mior.ca",
    "location": {
      "address": "102 Lomb Memorial Drive",
      "postalCode": "14623-5608",