Result

WA

Code [DL]

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

stdin

10111110
10111101
01101100
01010010
00000011
00100100
00000000
11101001
01101001
01000111
10001000
11100111
01111101
00001001
11011111
10011001
11010010
00110111
00011100
01001110
00010001
00010111
11000010
10000010
00001110
10101011
10101011
01011011
00001010
01111100
11011110
10111110
00010101
00011101
01000010
00101101
00001111
01011000
11111101
11101110
00111011
00010110
11110001
01001001
00000110
00001100
01111000
11110101
00000001
11100010

stdout

stderr

Error: no such column: t

strace