by@hakatashi
WA
WITH RECURSIVE lines(x, line, remain) AS (
SELECT 1, substr(v, 0, 8) AS line, substr(v, 9) AS remain FROM i
UNION ALL
SELECT x + 1, substr(remain, 0, 8) AS line, substr(remain, 9) AS remain
FROM lines
WHERE remain != ''
)
SELECT x, lines FROM cnt11111110 00001111 00111111 10001111 00001110 00101101 10011001 10000001 01011011 00010101 01101001 11110000 00000000 00111010 10000011 10001000 00101001 10101001 01000010 10010011 01111101 11111101 01111000 00000001 01001011 00111001 01111001 10111001 11010010 01101001 11000011 00100100 01000110 00000000 10010000 11100111 10100100 00000110 11110101 10111110 00001010 11011011 10101011 01000101 00110111 00000011 00011100 10011011 10010111 01001110
Error: no such table: cnt