I could compile sqlite with CCC. Most of the SELECT, CREATE, UPDATE queries worked but joins seem to be stuck consuming a single core forever. GCC compiled binary just takes under 50ms for the same join query.

I didn't fully get where the problem is but so far my triage leads to an invalid instruction set. I'll update here if I get more details.

Anyone facing the same issue?