Am I dreaming, or have I read somewhere that TVFs are stored as source code and expanded when the calling query is compiled ?

This fits well with your results :...