PostGIS Classification works in 4.0.2 not in >= 4.2

[Daryl Herzmann]

Howdy,

I have a PostGIS layer (see below). With mapserver 4.0.2, the classication
works, Flash Flood Warnings (FFW) are colored green and so on.  With
4.2.2, the FFWs are coloured yellow (SVR) like Severe warnings.  Here is
an example plot with 4.2.2

http://mesonet.agron.iastate.edu/pickup/n0r_20040825_2225.png

and then the correct image five minutes later with 4.0.2

http://mesonet.agron.iastate.edu/pickup/n0r_20040825_2230.png

Notice the counties that turned green, like they should be! :)

What am I doing wrong?
  daryl


LAYER
  CONNECTIONTYPE postgis
  NAME warnings0_c
  CONNECTION "user=akrherz dbname=postgis host=10.10.10.10"
  DATA "geom from (select type as wtype, geom, oid from warnings WHERE
   gtype = 'C' and expire > CURRENT_TIMESTAMP ORDER by expire, type ASC)
     as foo"
  STATUS ON
  TYPE POLYGON
  PROJECTION
   "init=epsg:4326"
  END
  CLASSITEM wtype
  CLASS
    EXPRESSION 'TOR'
    COLOR -1 -1 -1
    OUTLINECOLOR 255 0 0
    SIZE 2
    SYMBOL 1
  END
  CLASS
    EXPRESSION 'SVR'
    COLOR -1 -1 -1
    OUTLINECOLOR 255 255 0
    SIZE 2
    SYMBOL 1
  END
  CLASS
    EXPRESSION 'FFW'
    COLOR -1 -1 -1
    OUTLINECOLOR 0 255 0
    SIZE 2
    SYMBOL 1
  END
END


--
/**
 * Daryl Herzmann (akrherz at iastate.edu)
 * Program Assistant -- Iowa Environmental Mesonet
 * http://mesonet.agron.iastate.edu
 */