by@hakatashi
WA
WITH RECURSIVE lines(x, line, remain) AS ( SELECT 1, CASE WHEN substr(v,1,8) = '00000000' THEN 1 ELSE 0 END AS line, substr(v, 10) AS remain FROM i UNION ALL SELECT x + 1, CASE WHEN substr(v,1,8) = '00000000' THEN 1 ELSE 0 END AS line, substr(remain, 10) AS remain FROM lines WHERE remain != '' ) SELECT line FROM lines
00101101 10101011 00001111 10011100 01000010 10011001 11001101 00000110 01011011 01101001 00001110 01100000 00010101 11010101 11100111 00000000 00100111 00000001 11111101 01110111 11110001 00110100 11011110 01011011 00100100 00001010 10111110 10111000 00101011 11010010 11000001 10110001 10000000 00011100 00110111 10101100 01111000 00010001 01101001 01001110 00111001 00101100 11011100 00000011 10110100 01001000 01000101 10001110 01010101 10001000
Error: no such column: v