https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23982
Nick Clemens <n...@bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #95545|0 |1
is obsolete| |
--- Comment #8 from Nick Clemens <n...@bywatersolutions.com> ---
Created attachment 95548
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=95548&action=edit
Bug 23982: (bug 23624 follow-up) Handle SQL error caused by derived table
Caused by
commit bca4453c50d8b5b1d3c7029ded2b522a9a2bf868
Bug 23624: (QA follow-up) Optimize even more
A report like:
SELECT * FROM issues JOIN borrowers USING (borrowernumber)
will have two borrowernumber columns - SQL will give us there rsults,
but if we try to wrap them in a SELECT COUNT(*) FROM (report) it throws
a duplicated column error.
This patch suggests to execute the query the old way if the derived
table optimization failed.
Signed-off-by: Martin Renvoize <martin.renvo...@ptfs-europe.com>
Signed-off-by: Nick Clemens <n...@bywatersolutions.com>
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
