Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#3503 closed defect (fixed)

ST_ColorMap regress failing on PostgreSQL 9.6 debbie

Reported by: robe Owned by: robe
Priority: critical Milestone: PostGIS PostgreSQL
Component: raster Version: master
Keywords: Cc:

Description

I suspect this is a similar issue to #3502 that something changed in the planner in PostgreSQL 9.6 so the order of returned items is not the same as it used to be. 

 rt_colormap .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_70_diff)
-----------------------------------------------------------------------------
--- rt_colormap_expected	2015-11-28 06:43:34.770196254 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_70_out	2016-03-12 20:02:32.996801052 +0000
@@ -7,30 +7,108 @@
 NOTICE:  Method INTERPOLATE requires at least two non-NODATA colormap entries. Using NEAREST instead
 NOTICE:  Method INTERPOLATE requires at least two non-NODATA colormap entries. Using NEAREST instead
 1|1|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|1|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|1|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|1|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
+1|1|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
 1|1|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|1|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|1|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+1|2|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|2|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
 1|2|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|2|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
 1|2|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|2|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|2|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|2|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+1|3|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
 1|3|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|3|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|3|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
+1|3|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|3|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
 1|3|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|3|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+1|4|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|4|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
+1|4|{{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255},{0,0,32,64,96,128,159,191,223,255}}
 1|4|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
+1|4|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|4|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
+1|4|{{0,0,3,5,8,10,13,16,18,21},{23,26,29,31,34,36,39,42,44,47},{49,52,55,57,60,62,65,68,70,73},{75,78,81,83,86,88,91,94,96,99},{101,104,107,109,112,114,117,120,122,125},{128,130,133,135,138,141,143,146,148,151},{154,156,159,161,164,167,169,172,174,177},{180,182,185,187,190,193,195,198,200,203},{206,208,211,213,216,219,221,224,226,229},{232,234,237,239,242,245,247,250,252,255}}
 1|4|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
 2|1|{{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255}}
+2|1|{{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255}}
+2|1|{{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255}}
+2|1|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
 2|1|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,130,135,140,145,151},{156,161,166,171,177,182,187,192,198,203},{208,213,218,224,229,234,239,245,250,255}}
+2|1|{{0,0,5,10,16,21,26,31,36,41},{47,52,57,62,67,73,78,83,88,93},{98,104,109,114,119,124,124,119,114,109},{104,98,93,88,83,78,73,67,62,57},{52,47,41,36,31,26,21,16,10,5},{0,10,21,31,42,52,62,73,83,94},{104,114,125,135,146,156,167,177,187,198},{208,219,229,239,250,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|1|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,132,137,143,148,153,158,164,169,174},{179,184,190,195,200,205,211,216,221,226},{231,237,242,247,252,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|1|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|2|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,130,135,140,145,151},{156,161,166,171,177,182,187,192,198,203},{208,213,218,224,229,234,239,245,250,255}}
 2|2|{{0,0,5,10,16,21,26,31,36,41},{47,52,57,62,67,73,78,83,88,93},{98,104,109,114,119,124,124,119,114,109},{104,98,93,88,83,78,73,67,62,57},{52,47,41,36,31,26,21,16,10,5},{0,10,21,31,42,52,62,73,83,94},{104,114,125,135,146,156,167,177,187,198},{208,219,229,239,250,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|2|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,132,137,143,148,153,158,164,169,174},{179,184,190,195,200,205,211,216,221,226},{231,237,242,247,252,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|2|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|2|{{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255}}
 2|2|{{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255}}
+2|2|{{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255}}
+2|2|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
+2|3|{{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255}}
+2|3|{{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255}}
 2|3|{{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255}}
+2|3|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
+2|3|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,130,135,140,145,151},{156,161,166,171,177,182,187,192,198,203},{208,213,218,224,229,234,239,245,250,255}}
+2|3|{{0,0,5,10,16,21,26,31,36,41},{47,52,57,62,67,73,78,83,88,93},{98,104,109,114,119,124,124,119,114,109},{104,98,93,88,83,78,73,67,62,57},{52,47,41,36,31,26,21,16,10,5},{0,10,21,31,42,52,62,73,83,94},{104,114,125,135,146,156,167,177,187,198},{208,219,229,239,250,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
 2|3|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,132,137,143,148,153,158,164,169,174},{179,184,190,195,200,205,211,216,221,226},{231,237,242,247,252,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|3|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|4|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,130,135,140,145,151},{156,161,166,171,177,182,187,192,198,203},{208,213,218,224,229,234,239,245,250,255}}
+2|4|{{0,0,5,10,16,21,26,31,36,41},{47,52,57,62,67,73,78,83,88,93},{98,104,109,114,119,124,124,119,114,109},{104,98,93,88,83,78,73,67,62,57},{52,47,41,36,31,26,21,16,10,5},{0,10,21,31,42,52,62,73,83,94},{104,114,125,135,146,156,167,177,187,198},{208,219,229,239,250,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|4|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,3,8,13,18},{23,29,34,39,44,49,54,60,65,70},{75,80,86,91,96,101,106,111,117,122},{127,132,137,143,148,153,158,164,169,174},{179,184,190,195,200,205,211,216,221,226},{231,237,242,247,252,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
 2|4|{{0,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+2|4|{{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255},{0,0,0,0,64,127,127,127,191,255}}
+2|4|{{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255},{0,0,64,127,64,0,128,255,255,255}}
+2|4|{{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255},{0,0,0,0,64,127,191,255,255,255}}
 2|4|{{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255},{0,255,255,255,255,255,255,255,255,255}}
 3|1|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|1|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|1|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|1|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
 3|1|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|1|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|1|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|1|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|2|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
 3|2|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|2|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|2|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|2|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
 3|2|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|2|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|2|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|3|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|3|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
 3|3|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|3|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|3|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|3|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
 3|3|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
+3|3|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|4|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|4|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|4|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
 3|4|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
+3|4|{{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1},{1,1,1,1,1,1,1,1,1,1}}
+3|4|{{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127},{127,127,127,127,127,127,127,127,127,127}}
+3|4|{{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}}
 3|4|{{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255},{255,255,255,255,255,255,255,255,255,255}}
 4|1|{{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0}}
+4|1|{{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0}}
+4|1|{{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255}}
+4|2|{{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0}}
 4|2|{{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0}}
+4|2|{{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255}}
+4|3|{{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0},{255,191,128,64,0,0,0,0,0,0}}
+4|3|{{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0},{0,64,128,191,255,255,191,128,64,0}}
 4|3|{{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255},{0,0,0,0,0,0,64,128,191,255}}
 5|1|{{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0},{255,254,222,191,159,127,95,64,32,0}}
-----------------------------------------------------------------------------

The regress I assume probably just needs and ORDER BY in it.

Change History (10)

comment:1 by robe, 8 years ago

Looking at the last couple of committs from PostgreSQL folks, It might be this commit the screwed up the order of ST_GeneratePoints and ST_ColorMap. 

Commit 9118d03a8cca3d97327c56bf89a72e328e454e63 by Tom Lane

When appropriate, postpone SELECT output expressions till after ORDER
BY.
It is frequently useful for volatile, set-returning, or expensive
functions in a SELECT's targetlist to be postponed till after ORDER BY
and LIMIT are done.  Otherwise, the functions might be executed for
every row of the table despite the presence of LIMIT, and/or be executed
in an unexpected order.  For example, in
SELECT x, nextval('seq') FROM tab ORDER BY x LIMIT 10; it's probably
desirable that the nextval() values are ordered the same as x, and that
nextval() is not run more than 10 times.
In the past, Postgres was inconsistent in this area: you would get the 
desirable behavior if the ordering were performed via an indexscan, but 
not if it had to be done by an explicit sort step.  Getting the desired 
behavior reliably required contortions like
SELECT x, nextval('seq')
  FROM (SELECT x FROM tab ORDER BY x) ss LIMIT 10;
This patch conditionally postpones evaluation of pure-output target 
expressions (that is, those that are not used as DISTINCT, ORDER BY, or 
GROUP BY columns) so that they effectively occur after sorting, even if
an explicit sort step is necessary.  Volatile expressions and
set-returning expressions are always postponed, so as to provide
consistent semantics. Expensive expressions (costing more than 10 times
typical operator cost, which by default would include any user-defined
function) are postponed if there is a LIMIT or if there are expressions
that must be postponed.
We could be more aggressive and postpone any nontrivial expression, but 
there are costs associated with doing so: it requires an extra Result
plan node which adds some overhead, and postponement changes the volume
of data going through the sort step, perhaps for the worse.  Since we
tend not to have very good estimates of the output width of nontrivial
expressions, it's hard to have much confidence in our ability to predict
whether postponement would increase or decrease the cost of the sort;
therefore this patch doesn't attempt to make decisions conditionally on
that. Between these factors and a general desire not to change query
behavior when there's not a demonstrable benefit, it seems best to be
conservative about applying postponement.  We might tweak the decision
rules in the future, though.
Konstantin Knizhnik, heavily rewritten by me

Anyrate like I said, means we need to force the output of the set returning funcs now more than ever:

comment:2 by robe, 8 years ago

(In [14793]) Force sorting in ST_ColorMap test references #3503

comment:3 by robe, 8 years ago

Resolution: → fixed
Status: new → closed

(In [14794]) Force sorting in ST_ColorMap test (fix aliasing issue rid was aliased as testid) closes #3503

comment:4 by robe, 8 years ago

Resolution: fixed
Status: closed → reopened

drats that didn't fix it.

comment:5 by robe, 8 years ago

I just took out 9.6 from debbie's 2.3 run for now until I can nail down the issue here.

comment:6 by robe, 8 years ago

okay this is not just a sorting issue. It seem the multiple calls of the function triggered by: 

	(ST_DumpValues(rast)).*

is actually creating duplicate records (one for each column). Even though people aren't supposed to do that because it does call the function for each column output by the (.*), I suspect this was an unintentional change in behavior in PostgreSQL 9.6.

I could just change the tests to pass, but instead I'll complain upstream first to confirm they did intend this behavior change.

comment:7 by robe, 8 years ago

Okay I reported upstream

​http://www.postgresql.org/message-id/flat/30200.1458772448@sss.pgh.pa.us#30200.1458772448@sss.pgh.pa.us

Long story short - consensus is old behavior was a bug, but a bug they understand people considered a feature. So there is debate whether to support the old buggy behavior, throw an error, or just give the optimal response even though it would result in people's old code giving unexpected buggy answers.

I'll wait till whatever they have decided on is committed and either rewrite the test using the recommended syntax or just turn 9.6 testing back on if they emulate old behavior.

I should add this surprising behavior only happens in case where you order by or group by a value in the SRF 

SELECT (ST_DumpValues(rast)).*
FROM rtable
ORDER BY nband;

and not 

SELECT (ST_DumpValues(rast)).*
FROM rtable;
Last edited 8 years ago by robe (previous) (diff)

comment:8 by robe, 8 years ago

Owner: changed from Bborie Park to robe
Status: reopened → new

comment:9 by robe, 8 years ago

Milestone: PostGIS 2.3.0 → PostGIS PostgreSQL
Resolution: → fixed
Status: new → closed

I forgot I still have the git postgresql 9.6 tests running after each 9.6 commit, and this test seems to be passing now, but now it's topology failing. So I'll close this one and open one for topology.

comment:10 by robe, 8 years ago

For completeness, here is Tom's committ that fixed the issue: 

    Don't split up SRFs when choosing to postpone SELECT output expressions. (details)

Commit d543170f2fdd6d9845aaf91dc0f6be7a2bf0d9e7 by Tom Lane

Don't split up SRFs when choosing to postpone SELECT output expressions.
In commit 9118d03a8cca3d97 we taught the planner to postpone evaluation
of set-returning functions in a SELECT's targetlist until after any sort
done to satisfy ORDER BY.  However, if we postpone some SRFs this way
while others do not get postponed (because they're sort or group key
columns) we will break the traditional behavior by which all SRFs in the
tlist run in-step during ExecTargetList(), so that you get the least
common multiple of their periods not the product.  Fix
make_sort_input_target() so it will not split up SRF evaluation in such
cases.
There is still a hazard of similar odd behavior if there's a SRF in a 
grouping column and another one that isn't, but that was true before and
we're just trying to preserve bug-compatibility with the traditional 
behavior.  This whole area is overdue to be rethought and reimplemented, 
but we'll try to avoid changing behavior until then.
Per report from Regina Obe.
Note: See TracTickets for help on using tickets.