Skip to content

Instantly share code, notes, and snippets.

💭
👨‍💻

Michael Mior michaelmior

💭
👨‍💻
Block or report user

Report or block michaelmior

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View calcite-rewrites.txt
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
View gist:da292dc3b9c9f105bc37e18265453871
Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm
View resume.json
{
"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",
You can’t perform that action at this time.