Skip to content

Instantly share code, notes, and snippets.

@apstndb
Last active August 18, 2022 03:42
Show Gist options
  • Save apstndb/9eb2f2b78248505b8c1a9ea6a7596289 to your computer and use it in GitHub Desktop.
Save apstndb/9eb2f2b78248505b8c1a9ea6a7596289 to your computer and use it in GitHub Desktop.
SELECT SUBSTR(TO_HEX(x), 0, 8), SUBSTR(TO_HEX(x), 0, 16)
FROM(SELECT SHA256(CAST(FirstName AS BYTES)) @{DISABLE_INLINE=FALSE} AS x FROM Singers LIMIT 1)
SELECT SUBSTR(TO_HEX(x), 0, 8), SUBSTR(TO_HEX(x), 0, 16)
FROM(SELECT SHA256(CAST(FirstName AS BYTES)) @{DISABLE_INLINE=TRUE} AS x FROM Singers LIMIT 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment