by@hakatashi
WA
WITH RECURSIVE lines(x, line, remain) AS ( SELECT 1, CASE WHEN substr(v,1,8) = '00000000' THEN 1 ELSE 0 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 AS line, substr(remain, 10) AS remain FROM lines WHERE remain != '' ) SELECT line FROM lines
10111000 11101101 10101011 11001000 00001010 11000100 11101100 10001000 01011100 10111010 11100111 01110110 10101010 11010010 11011111 00000000 10010011 00000001 01100000 01111000 01000011 10111110 00101101 01111100 10011001 01001110 10100100 01100100 01101110 10000100 01111000 00100100 01000010 00101000 00001111 00011100 01011011 00110111 00010101 11100111 11111101 00000011 01101001 11001010 11000101 00000110 00001000 11110011 11110110 10110100
Error: near "AS": syntax error