[teiid-issues] [JBoss JIRA] (TEIID-3662) SPATIAL_REF_SYS query returns wrong number of rows
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)