[Koha-bugs] [Bug 22368] Table suggestions lacks foreign key constraints

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Feb 22 17:52:47 CET 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22368

--- Comment #26 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
(In reply to Jonathan Druart from comment #23)
> NOT IN could (must?) be replaced with LEFT JOIN table SET attr_a = NULL
> WHERE attr_b IS NULL

Personally, I always find the NOT IN clearer than a LEFT JOIN.. and I thought
the performance was pretty much the same as the mysql optimiser accounts for
it.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list