<div dir="ltr">Look at the test that is failing, it has nothing to do w/ selectivity:<div><br></div><div><div>-- #3399</div></div><div><div>WITH g as (</div><div>select 'POLYGON((1 0, 0 1, 1 2, 2 1, 1 0))'::geometry as geom</div><div>),</div><div>n as (</div><div>select n from unnest(ARRAY[-1,0,1,10,100,1000]) n</div><div>),</div><div>pts as (</div><div>  select n,(st_dump(st_generatepoints(geom, n))).geom from g,n</div><div>)</div><div>select '#3399' as t, n, count(*) from</div><div>g, pts</div><div>where st_contains(g.geom, pts.geom)</div><div>group by n</div><div>ORDER BY n;</div></div><div><br></div><div>(Incidentally, works fine on OSX)</div><div><br>P<br><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, May 26, 2017 at 10:35 AM, Regina Obe <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_2980397968323439519WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I beat you to it </span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d">J</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://trac.osgeo.org/postgis/ticket/3764" target="_blank">https://trac.osgeo.org/<wbr>postgis/ticket/3764</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I'll try to fix when I get the chance.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">BTW: For this error, are you seeing this one?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://trac.osgeo.org/postgis/ticket/3759" target="_blank">https://trac.osgeo.org/<wbr>postgis/ticket/3759</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">/tmp/2.4.0dev_pg10_geos3.7.<wbr>0dev_gdal2.1.3w64/test_89_<wbr>diff)<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">------------------------------<wbr>------------------------------<wbr>-----------------<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">--- tickets_expected   2016-09-26 01:59:38 -0400<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">+++ /projects/postgis/tmp/2.4.<wbr>0dev_pg10_geos3.7.0dev_gdal2.<wbr>1.3w64/test_89_out        2017-05-25 15:15:09 -0400<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">@@ -285,7 +285,7 @@<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> #3375|GEOMETRYCOLLECTION(<wbr>POINT(0 -7))<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> #3399|1|1<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> #3399|10|10<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">-#3399|100|100<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">+#3399|100|99<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> #3399|1000|1000<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> ERROR:  invalid KML representation<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> #3437a|5<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">------------------------------<wbr>------------------------------<wbr>-----------------<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Do we go with float or float4.  If float4, I think you need to change the regression and also the pre-10 code.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p>the geometry regression in tickets caused by this change <u></u><u></u></p><pre> nd_stats = palloc(sizeof(float) * sslot.nnumbers);<u></u><u></u></pre><pre> memcpy(nd_stats, sslot.numbers, sizeof(float) * sslot.nnumbers);<u></u><u></u></pre><p>To: <u></u><u></u></p><pre> nd_stats = palloc(sizeof(float4) * sslot.nnumbers);<u></u><u></u></pre><pre> memcpy(nd_stats, sslot.numbers, sizeof(float4) * sslot.nnumbers);<u></u><u></u></pre><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> postgis-devel [mailto:<a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@<wbr>lists.osgeo.org</a>] <b>On Behalf Of </b>Paul Ramsey<br><b>Sent:</b> Friday, May 26, 2017 11:13 AM<br><b>To:</b> PostGIS Development Discussion <<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><wbr>><br><b>Subject:</b> [postgis-devel] topology pgsql 10 regression failures<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:.5in">Several failures for me (Darwin Kernel Version 15.6.0) right now in topology, for example, <u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">regress/st_simplify .. failed (diff expected obtained: /tmp/pgis_reg/test_26_diff)<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">This "invalid geometry type" shows up in a few of the other failures further down. Anyone seeing similar things w/ pgsql 10? <u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><div><p class="MsoNormal" style="margin-left:.5in">--- regress/st_simplify_expected    2014-12-01 12:28:41.000000000 -0800<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">+++ /tmp/pgis_reg/test_26_out   2017-05-26 08:02:22.000000000 -0700<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">@@ -1,9 +1,8 @@<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"> t<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"> L1<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">-N2<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">-S1|f|t<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">-S2|f|t<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">+ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring, expected LINESTRING<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">+N1<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">+S1|f|<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">+S2|f|<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"> L2<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">-HS1|f|t<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">-HS2|f|t<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"> f<u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></div></div></div></div></div></div><br>______________________________<wbr>_________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-devel</a><br></blockquote></div><br></div>