[teiid-issues] [JBoss JIRA] (TEIID-3662) IN predicate against a materialized/temp table index without an order by returns wrong results

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13182533#comment-13182533 ] 

RH Bugzilla Integration commented on TEIID-3662:
------------------------------------------------

Debi Rieden <drieden at redhat.com> changed the Status of [bug 1257964|https://bugzilla.redhat.com/show_bug.cgi?id=1257964] from VERIFIED to CLOSED

> IN predicate against a materialized/temp table index without an order by returns wrong results
> ----------------------------------------------------------------------------------------------
>
>                 Key: TEIID-3662
>                 URL: https://issues.jboss.org/browse/TEIID-3662
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 8.7.1.6_2, 8.12, 8.11.3, 8.7.5
>
>
> 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.4.11#64026)