MySQL Forums :: Views :: VIEWSs with ALGORITHM=TEMPTABLE in query cache?

I have a view that's explicitly set to ALGORITHM=TEMPTABLE. As the underlying data in the base tables for that view is almost static, I hoped the result set returned by the view would be stored in the query cache. But actually this doesn't seem to be the case (from what I can tell from the performance at first sight, didn't run any real tests, yet).

The manual states: "In MySQL 5.0, queries generated by views are cached." (5.13.1. How the Query Cache Operates)

But could the word "generated" possibly mean that this applies only to queries generated by the MERGE algorithm? As with TEMPTABLE no query actually has to be "generated", as I understand it: The server can just run the stored query for the view and then independently query the resulting temporary table.

The manual further states: "A query also is not cached under these conditions: [...] It uses TEMPORARY tables."

Maybe this applies to VIEWs with ALGORITHM=TEMPTABLE?

Does anyone already have the answer? Just checking before I put this on my list of things I have to investigate...