Active Record query cache eating queries. Looks like BUG |
[eluser]mikerh[/eluser]
Query cache is eating complex sub queries in select(). Here is DB info. tableA Code: DROP TABLE IF EXISTS `tablea`; tableB Code: DROP TABLE IF EXISTS `tableb`; Here is the query in CI Code: $this->db->start_cache(); This is what is getting sent to MySQL Code: SELECT tableb.c_number,
[eluser]mikerh[/eluser]
[quote author="jmadsen" date="1353120345"]what is it exactly you are trying to point out?[/quote] Sorry...your blindness must be affecting you. Here is the query as I have it in CI. Code: $this->db->start_cache(); Here is the query that CI is sending to mysql Code: SELECT tableb.c_number, If I don't use query cache the query is fine. Really? You can't see what's in plain English there...did you even try to re-create the issue before replying?
[eluser]CroNiX[/eluser]
Your answer is in the user guide. Didn't you read it before posting? This has also been asked and answered many times on the forums. Did you try searching before posting? We can play that game too, but it won't help you get very far now will it...
[eluser]jmadsen[/eluser]
[quote author="mikerh" date="1353121995"]did you even try to re-create the issue before replying? [/quote] No, I didn't. I'm here as a volunteer. I have no interest in spending time trying to recreate an issue that the poster can't even explain clearly. Obviously there is some difference in your query - tell us what it is we should be looking for when you report the bug. And after acting like such a complete dickhead, don't expect anyone in these forums to make much effort helping you in the future.
[eluser]mikerh[/eluser]
Fixed https://github.com/EllisLab/CodeIgniter/issues/2004 https://github.com/EllisLab/CodeIgniter/...2dc8386ecf Nice turnaround. Thanks to those who actually looked into the issue...good thing it was "in the user guide" :roll: |
Welcome Guest, Not a member yet? Register Sign In |