Changes between Version 1 and Version 2 of Ticket #3765


Ignore:
Timestamp:
May 27, 2017, 10:04:33 AM (7 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3765 – Description

    v1 v2  
    3636}}}
    3737
     38
     39Problem query is:
     40
     41
     42{{{
     43-- #3399
     44
     45WITH g as (
     46
     47select 'POLYGON((1 0, 0 1, 1 2, 2 1, 1 0))'::geometry as geom
     48
     49),
     50
     51n as (
     52
     53select n from unnest(ARRAY[-1,0,1,10,100,1000]) n
     54
     55),
     56
     57pts as (
     58
     59  select n,(st_dump(st_generatepoints(geom, n))).geom from g,n
     60
     61)
     62
     63select '#3399' as t, n, count(*) from
     64g, pts
     65where st_contains(g.geom, pts.geom)
     66group by n
     67ORDER BY n;
     68}}}
     69
    3870Might be bot specific I guess but still concerning.
    3971
    40 Problem is intermittent.  I did a manual run and it passed.  So perhaps some dirty memory somewhere.
     72Problem is intermittent.  I did a manual run multiple times and it passed.  So perhaps some dirty memory somewhere or only happens if system is taxed.