Substr in a View on SQLite

Hi,
thanks for taking some time to look into my problem.
Here is the log when performing a sync : https://framabin.org/p/?481422f6b2449ddd#4+PE6lkyf57ubkpQ9aXWIPVBN9v+xoHEUN/R5pXAFRw=

Eventually, by moving the columns around in the View, and by adding another alias (the_column AS alias_name), it works. So it’s ok for me, but there’s something wrong somewhere.