Active Record query cache eating queries. Looks like BUG - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Active Record query cache eating queries. Looks like BUG (/showthread.php?tid=55925) |
Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [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, Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [eluser]jmadsen[/eluser] what is it exactly you are trying to point out? Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [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? Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [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... Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [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. Active Record query cache eating queries. Looks like BUG - El Forum - 11-16-2012 [eluser]mikerh[/eluser] Fixed https://github.com/EllisLab/CodeIgniter/issues/2004 https://github.com/EllisLab/CodeIgniter/commit/eae17d19fa32847f2b5a0a1b195f912dc8386ecf Nice turnaround. Thanks to those who actually looked into the issue...good thing it was "in the user guide" :roll: |