gluesql / gluesql / 16739679624

99%

push

github

Add HEX function (#1694)

Implements the SQL standard HEX function to convert numbers and strings to hexadecimal representation, enhancing compatibility with standard SQL queries.

Numbers: HEX(228) → "E4" (number to hex)
Strings: HEX("228") → "323238" (each character to hex)
Negative Numbers: HEX(-123) → "FFFFFFFFFFFFFF85" (64-bit 2's complement)
Zero: HEX(0) → "0"
Empty String: HEX("") → ""

e.g.
-- String conversion: each character to hex
SELECT HEX('GlueSQL');     -- '476C756553514C'
SELECT HEX('ABC');         -- '414243'
SELECT HEX('');            -- ''

-- Numeric conversion: number to hex
SELECT HEX(255);           -- 'FF'
SELECT HEX(123);           -- '7B'
SELECT HEX(0);             -- '0'
SELECT HEX(-123);          -- 'FFFFFFFFFFFFFF85'

-- Error cases
SELECT HEX();              -- Error: requires exactly 1 argument
SELECT HEX('test', 'extra'); -- Error: requires exactly 1 argument
SELECT HEX(3.14);          -- Error: float not supported

56 of 56 new or added lines in 6 files covered. (100.0%)

39728 of 40585 relevant lines covered (97.89%)

60566.9 hits per line