[teiid-issues] [JBoss JIRA] (TEIID-3662) SPATIAL_REF_SYS query returns wrong number of rows

[Tom Arnold (JIRA)]

Tom Arnold created TEIID-3662:
---------------------------------

             Summary: SPATIAL_REF_SYS query returns wrong number of rows
                 Key: TEIID-3662
                 URL: https://issues.jboss.org/browse/TEIID-3662
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.12
            Reporter: Tom Arnold
            Assignee: Steven Hawkins


Seeing strange behavior when doing a simple select from {{SPATIAL_REF_SYS}}.

This works as expected:
{code}
select srid, proj4text from spatial_ref_sys where srid in (3875,4326);
 srid |                                                   proj4text                                                    
------+----------------------------------------------------------------------------------------------------------------
 3875 | +proj=tmerc +lat_0=0 +lon_0=21 +k=1 +x_0=21500000 +y_0=0 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs
 4326 | +proj=longlat +datum=WGS84 +no_defs
(2 rows)
{code}

Swapping the values in the IN causes only one row to be returned.
{code}
select srid, proj4text from spatial_ref_sys where srid in (4326,3875);
 srid |              proj4text              
------+-------------------------------------
 4326 | +proj=longlat +datum=WGS84 +no_defs
(1 row)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)