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

Infinispan-dsl-cache translator: Comparison operators don't work for char column

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • 8.7.1
    • Misc. Connectors
    • None

      Comparison operators returns wrong result for column of type Character.

      Sample queries:

      SELECT CharValue FROM SmallA WHERE SmallA.CharValue < '1'
SELECT CharValue FROM SmallA WHERE SmallA.CharValue = '1'

      These queries return no row even though they should have returned more than 20 rows.

        1. serverLog.txt
          18 kB

            [TEIID-3571] Infinispan-dsl-cache translator: Comparison operators don't work for char column

            Steven Hawkins added a comment -

            It looks like no fix is needed here. Is there a doc note needed somewhere to say that char is not a supported source type?

            Steven Hawkins added a comment - It looks like no fix is needed here. Is there a doc note needed somewhere to say that char is not a supported source type?

            RH Bugzilla Integration added a comment -

            David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment - David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment -

            Filip Elias <felias@redhat.com> changed the Status of bug 1242945 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment - Filip Elias <felias@redhat.com> changed the Status of bug 1242945 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment -

            David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment - David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment -

            David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment - David Le Sage <dlesage@redhat.com> changed the Status of bug 1242945 from ASSIGNED to MODIFIED

            Van Halbert (Inactive) added a comment -

            Because protobuf's don't support a char data type, one should use a String type. And then use a teiid view on top of the source table to limit the size.

            Another possible option, would be handle the transition in the protobuf marshaller. However, the searching isn't controlled thru the marshaling, and there appears to be another issue somewhere as the searching that still doesn't work. So more research into what's possible still needs to be done here.

            Van Halbert (Inactive) added a comment - Because protobuf's don't support a char data type, one should use a String type. And then use a teiid view on top of the source table to limit the size. Another possible option, would be handle the transition in the protobuf marshaller. However, the searching isn't controlled thru the marshaling, and there appears to be another issue somewhere as the searching that still doesn't work. So more research into what's possible still needs to be done here.

            RH Bugzilla Integration added a comment -

            Van Halbert <vhalbert@redhat.com> changed the Status of bug 1242945 from NEW to ASSIGNED

            RH Bugzilla Integration added a comment - Van Halbert <vhalbert@redhat.com> changed the Status of bug 1242945 from NEW to ASSIGNED

            Filip Elias (Inactive) added a comment -

            Server log

            Filip Elias (Inactive) added a comment - Server log

              van.halbert Van Halbert (Inactive)
              felias_jira Filip Elias (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: