Active record bug? Update() disregards limit(). The value set by limit() is then transfered to a next query in another p

[eluser]Maarten B[/eluser]
It gets even weirder.

The update() function of Active Record is used in one page (page A), the get() function in a consecutive page (B). The limit() part in page A is omitted in the query to the database, and on page B the limit() part is added by CI to the get() function in page B...

It looks like the query cache doesn't clean up the limit() part.

Is there a function in CI that clears the query cache, so you are absolutely sure no "rests" of a before query is silently added to a new query? I can't find it in the user guide.

Thanks in advance,


Maarten