Skip to content

Instantly share code, notes, and snippets.

@apstndb
Last active August 18, 2022 03:42
Show Gist options
  • Select an option

  • Save apstndb/9eb2f2b78248505b8c1a9ea6a7596289 to your computer and use it in GitHub Desktop.

Select an option

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