by@hakatashi
WA
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 != ''
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
Error: no such column: r