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

Bad result of query with GROUB BY clause (underlying sybase15 datasource)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7.1
    • None
    • None

      Description:
      There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
      I am trying to run query against VDB:
      SELECT
      INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
      FROM
      BQT1.SMALLA
      GROUP BY
      INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE

      Result is table which misses some values (the other values are OK):
      FloatNum: always 0
      ByteNum: always 0
      DateValue: always 1900-01-01
      TimeValue: always 00:00:00
      BooleanValue: always 'false'
      CharValue: always empty character
      ShortValue: always 0
      BigIntegerValue: always 0
      BigDecimalValue: always 0

      After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).

      ///////////////////
      Table definition
      ///////////////////
      SmallA (sybase) has these columns (name:type):
      IntKey:int -> PRIMARY KEY, HAS INDEX
      StringKey:varchar -> HAS INDEX
      IntNum:int
      StringNum:varchar
      FloatNum:float
      LongNum:numeric
      DoubleNum:float
      ByteNum:real
      DateValue:datetime
      TimeValue:datetime
      TimestampValue:datetime
      BooleanValue:tinyint
      CharValue:char
      ShortValue:numeric
      BigIntegerValue:numeric
      BigDecimalValue:numeric
      ObjectValue:text

      SmallA (VDB) has these columns (name:type):
      IntKey:integer
      StringKey:string
      IntNum:integer
      StringNum:string
      FloatNum:float
      LongNum:long
      DoubleNum:double
      ByteNum:byte
      DateValue:date
      TimeValue:time
      TimestampValue:timestamp
      BooleanValue:boolean
      CharValue:char
      ShortValue:short
      BigIntegerValue:biginteger
      BigDecimalValue:bigdecimal
      ObjectValue:object

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj DurĂ¡ni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: