Error in 3.4.2.sql

Bug #260330 reported by macrom
2
Affects Status Importance Assigned to Milestone
Network Administration Visualized
Fix Released
High
Stein Magnus Jodal
3.4
Fix Released
High
Stein Magnus Jodal

Bug Description

The upgrade-script for NAV-3.4.2 (doc/sql/upgrades/3.4.2.sql) contains a small bug :

In the "CREATE OR REPLACE RULE rrdfile_deleter" definition :
DO DELETE FROM rrd_file
   WHERE key='serviceid' AND value=old.serviceid;
   WHERE key='serviceid' AND value=old.serviceid::text;

The last two lines isnt suppose to be there?

Revision history for this message
Kristian Klette (klette) wrote :

«WHERE key='serviceid' AND value=old.serviceid;» should be removed

Changed in nav:
importance: Undecided → High
milestone: none → v3.4.3
Revision history for this message
Stein Magnus Jodal (jodal) wrote :

Fixed in revision 4233:fc9e43194705 of the default branch.

Changed in nav:
assignee: nobody → jodal
status: New → Fix Committed
Changed in nav:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.