[sqlite] SELECT 0 gives TEXT instead of INTEGER

[Cecil Westerhof]

I have the following:
WITH RECURSIVE
expansion(byte) AS (
    SELECT 0
    UNION  ALL
    SELECT byte + 1 FROM expansion
    LIMIT  10
)
SELECT hex(byte)
FROM   expansion
;

?I would expect to get 00-09, but I get 30-39. 30 is the hex-value of the
ASCII 0. How would I get what I want. I could subtract 48, but that is not
my preferred solution.?

-- 
Cecil Westerhof