[teiid-issues] [JBoss JIRA] (TEIID-3944) Accumulo translator: rowid column is compared as string in WHERE clause

[RH Bugzilla Integration (JIRA)]

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

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

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1302977|https://bugzilla.redhat.com/show_bug.cgi?id=1302977] from NEW to MODIFIED

> Accumulo translator: rowid column is compared as string in WHERE clause
> -----------------------------------------------------------------------
>
>                 Key: TEIID-3944
>                 URL: https://issues.jboss.org/browse/TEIID-3944
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.3
>            Reporter: Jan Stastny
>            Assignee: Ramesh Reddy
>             Fix For: 9.0, 8.12.5
>
>
> When in SOURCE model user specifies the required rowid column as integer:
> {code:xml}
> CREATE FOREIGN TABLE "SmallA" (
>   rowid integer OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'),
> .
> .
> .
> {code}
> and performs similar query:
> {code:sql}
> Select rowid, StringKey From accumulo.SmallA WHERE rowid >= 15 ORDER BY rowid
> {code}
> following results are returned:
> || rowid | StringKey ||
> || 2 | 2 ||
> || 3 | 3 ||
> || 4 | 4 ||
> || 5 | 5 ||
> || 6 | 6 ||
> || 7 | 7 ||
> || 8 | 8 ||
> || 9 | 9 ||
> || 15 | 15 ||
> || ... | ... ||
> and given the fact, that rowid is modelled as integer, values 2,3,4,5,6,7,8,9 shouldn't appear in the result set. Interesting to note is that the resultset is then ordered by rowid, but this time correctly as expected.
> Other integer columns, mapped from accumulo's Column Family: Column Qualifier pairs works as expected and are being compared as corresponding types.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)