[MapServer-users] Issue with line colors in mapserver 8.4.0

[Linsenmaier, Dierk]

Hello mapserver community,

Since we switched from mapserver version 7.6.4 to version 8.4.0, I have an issue with colors in line layers.
All dynamic color definitions (color is defined by a variable) are rendered with the same color. No matter if we use RGB- or HEX-Color values.
COLOR [VAR]

The values for the color  variable are defined by  an oracle SQL querry.


Example SQL:
DATA                    "geom FROM (SELECT id,status,zeitraum,   case   when Zeitraum in ( 2023) then '166 206 227'  when Zeitraum in ( 2024) then '31 120 180' when Zeitraum in ( 2025) then '227 26 28' when Zeitraum in ( 2026) the
n '255 127 0' when Zeitraum in ( 2027) then '253 191 111' when Zeitraum in ( 2028,2029,2030) then '251 154 153' when Zeitraum in ( 2031,2032,2033,2034,2035) then '51 160 44' when Zeitraum in ( 2036,2037,2038,2039,2040) then '178 223 138'
END  as color, geom,'Status: '||STATUS__LL||'</BR>Trassenlänge: '||trassenlaenge||'m' AS banner FROM my_oracle_table WHERE 1=1  ) USING UNIQUE ID SRID 25832 FILTER"


CLASS definition:
        CLASS
                NAME            "CLASS 1"
                EXPRESSION ("[STATUS]" IN "in_ausfuehrung")
                STYLE
                        OPACITY                 90
                        OUTLINECOLOR    255 255 255
                        WIDTH                   7
                        LINECAP butt
                END#STYLE
                STYLE
                        OPACITY                 100
                        COLOR                   [COLOR]#28 22 63
                        WIDTH                   4
                        LINECAP butt
                END #STYLE
        END #CLASS
        CLASS
                NAME            "CLASS 2"
                EXPRESSION ("[STATUS]" IN "geplant_genehm_gut")
                STYLE
                        OPACITY                 90
                        OUTLINECOLOR    255 255 255
                        WIDTH                   7
                        LINECAP butt
                END#STYLE
                STYLE
                        OPACITY                 100
                        PATTERN                   12 6 12 6 END
                        COLOR                   [COLOR]#28 22 63
                        WIDTH                   4
                        LINECAP butt
                END #STYLE
        END #CLASS

        CLASS
                NAME            "CLASS 3"
                EXPRESSION ("[STATUS]" IN "geplant_n_genehm")
                STYLE
                        OPACITY                 90
                        OUTLINECOLOR    255 255 255
                        WIDTH                   7
                        LINECAP butt
                END#STYLE
                STYLE
                        OPACITY                 100
                        PATTERN                   12 6 4 6 END
                        COLOR                   [COLOR]#28 22 63
                        WIDTH                   4
                        LINECAP butt
                END #STYLE
        END #CLASS


Is this a know issue or do you have any hint for me to solve it?


Mit freundlichen Grüßen
Dierk Linsenmaier

-- 

Dierk Linsenmaier

Team GIS
Informationstechnik

regioDATA
Tullastr. 61
79108 Freiburg i. Brsg.
Telefon  07621 91943-477
Telefax   07621 91943-465
dierk.linsenmaier at regiodata-gmbh.de
www.regiodata-gmbh.de

regioDATA GmbH
Sitz Lörrach, Amtsgericht Freiburg HRB 412719
Geschäftsführer: Michael Schade