[CalendarServer-changes] [15172] CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/ oracle-dialect/upgrade_from_47_to_48.sql

[source_changes at macosforge.org]

Revision: 15172
          http://trac.calendarserver.org//changeset/15172
Author:   dre at apple.com
Date:     2015-10-07 17:20:46 -0700 (Wed, 07 Oct 2015)
Log Message:
-----------
Oracle schema update clause needs to be 'is null' instead of = ''

Modified Paths:
--------------
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql	2015-10-07 19:37:53 UTC (rev 15171)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql	2015-10-08 00:20:46 UTC (rev 15172)
@@ -21,7 +21,7 @@
 
 
 -- Add pkey to PERUSER and remove old index
-update PERUSER set USER_ID = '.' where USER_ID = '';
+update PERUSER set USER_ID = '.' where USER_ID is null;
 alter table PERUSER add primary key (TIME_RANGE_INSTANCE_ID, USER_ID);
 drop index PERUSER_TIME_RANGE_IN_5468a226;
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20151007/b367dc91/attachment.html>