PREHOOK: query: DESCRIBE FUNCTION hex PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION hex POSTHOOK: type: DESCFUNCTION hex(n, bin, or str) - Convert the argument to hexadecimal PREHOOK: query: DESCRIBE FUNCTION EXTENDED hex PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hex POSTHOOK: type: DESCFUNCTION hex(n, bin, or str) - Convert the argument to hexadecimal If the argument is a string, returns two hex digits for each character in the string. If the argument is a number or binary, returns the hexadecimal representation. Example: > SELECT hex(17) FROM src LIMIT 1; 'H1' > SELECT hex('Facebook') FROM src LIMIT 1; '46616365626F6F6B' PREHOOK: query: -- If the argument is a string, hex should return a string containing two hex -- digits for every character in the input. SELECT hex('Facebook'), hex('\0'), hex('qwertyuiopasdfghjkl') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- If the argument is a string, hex should return a string containing two hex -- digits for every character in the input. SELECT hex('Facebook'), hex('\0'), hex('qwertyuiopasdfghjkl') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 46616365626F6F6B 00 71776572747975696F706173646667686A6B6C PREHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal. SELECT hex(1), hex(0), hex(4207849477) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal. SELECT hex(1), hex(0), hex(4207849477) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 1 0 FACEB005 PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit). SELECT hex(-5) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit). SELECT hex(-5) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### FFFFFFFFFFFFFFFB