Created
October 14, 2021 10:11
-
-
Save tfidfwastaken/ced71a34ce8f42ff032e3b1675a0d55d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Complex Query used in "Enhancing Cache Reuse in Gandiva with Literal Parameterization" | |
SELECT alpha_key_code from data | |
where | |
(case | |
when alpha_key_code > ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then iota_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + | |
(case | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when beta_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
else cbrt(?) | |
end) | |
when alpha_key_code < ? then alpha_key_code / | |
(case | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
else cbrt(?) | |
end) + ? | |
when alpha_key_code < (case | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
else cbrt(?) | |
end) then alpha_key_code/? + ? | |
when alpha_key_code < ? then | |
(case | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
else cbrt(?) | |
end) | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
when alpha_key_code < ? then alpha_key_code/? + ? | |
else ? | |
end) < ? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment