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 FROM cnt01100100 00011001 00000110 10100101 00010101 00011100 00001100 00110111 00001111 10011100 01101001 00001010 10001100 00000000 01101001 11100111 10011001 10010101 11000011 01111000 11111101 00000011 00100000 00111110 00010101 11100010 01011011 00110000 11001100 11110001 10100110 01010001 11111010 00010111 00000001 10110000 11010010 01010011 00101101 00100100 01110001 01001110 01000010 10101011 01111011 10111110 11011011 00100001 10010111 10001000
Error: no such table: cnt