Result

WA

Code [DL]

WITH RECURSIVE m(x,l,r,p) AS (
SELECT 1, '' AS l, v AS r, substr(r,1,8) AS p FROM i
UNION ALL
SELECT x + 1, CASE WHEN p='00000000' or p='00000001' or p='00000011' or p='00000110' or p='00001010' or p='00001111' or p='00010101' or p='00011100' or p='00100100' or p='00101101' or p='00110111' or p='01000010' or p='01001110' or p='01011011' or p='01101001' or p='01111000' or p='10001000' or p='10011001' or p='10101011' or p='10111110' or p='11010010' or p='11100111' or p='11111101' THEN 1 ELSE 0 END AS l, substr(r, 10) AS r, substr(r,1,8) AS p
FROM m
WHERE r != ''
)
SELECT l FROM m WHERE l != ''

stdin

10001010
00111100
11001110
11010010
10110011
00101101
01101001
01011011
00110001
00010111
00010101
01100001
00110111
01001110
00001111
00110111
00000000
01101000
10001000
01100000
00000011
11000100
10001110
00011100
10101011
11011110
11111010
11011010
00100011
11000111
10000010
11111101
11100111
00000110
01000010
00100111
00011000
01111000
00000111
11010010
11101111
00000001
01001001
10011001
00111111
10111101
11101001
00100100
00001010
10111110

stdout

stderr

Error: no such column: r

strace