Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3944

Accumulo translator: rowid column is compared as string in WHERE clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0, 8.12.5
    • 8.12.3
    • Misc. Connectors
    • None

    Description

      When in SOURCE model user specifies the required rowid column as integer:

      CREATE FOREIGN TABLE "SmallA" (
        rowid integer OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'),
      .
      .
      .
      

      and performs similar query:

      Select rowid, StringKey From accumulo.SmallA WHERE rowid >= 15 ORDER BY rowid
      

      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.

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-rareddy Ramesh Reddy
              jstastny@redhat.com Jan Stastny
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: