-
Incident report
-
Resolution: Cannot Reproduce
-
Minor
-
None
-
2.0.0, 2.0.3
-
Zabbix 1.8.15, Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
2.0 DB upgrade script for Oracle contains:
ALTER TABLE triggers MODIFY templateid DEFAULT NULL;
ALTER TABLE triggers MODIFY templateid NULL;
It generates an error during upgrade:
ALTER TABLE triggers MODIFY templateid NULL
*
ERROR at line 1:
ORA-01451: column to be modified to NULL cannot be modified to NULL
Looks like second line is redundant and should be removed.