Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Change #7463

Category None
Changed by Mike Rylander <mrylanderohnoyoudont@gmail.com>
Changed at Thu 22 Oct 2020 15:51:40
Repository git://git.evergreen-ils.org/Evergreen.git
Project Evergreen
Branch master
Revision 36f7b88e4dbafad0df9b2599e5658f0ecce128f1


LP#1893463: Protect against null emails
Unique indexes on nullable columns will allow multiple conceptually
unique rows if the nullable columns are, in fact, NULL because NULL does
not equal itself.  This commit uses COALESCE to make sure that the
nullable email column in the reporter.schedule table gets a value of the
empty string for the purposes of the unique index.  The upgrade script
now also takes this into account and ignores the email column.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>

Changed files