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

Unexpected exception for correct SQL query

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7
    • Misc. Connectors
    • None
    • Hide

      How reproducible:
      Source databse - MariaDB 5.5
      VDB view model - BQT1
      tables: smalla -
      `INTKEY` integer primary key,
      `STRINGKEY` varing(10),
      `INTNUM` integer,
      `STRINGNUM` varing(10),
      `FLOATNUM` real,
      `LONGNUM` bigint,
      `DOUBLENUM` double,
      `BYTENUM` smallint,
      `DATEVALUE` date,
      `TIMEVALUE` time,
      `TIMESTAMPVALUE` timestamp,
      `BOOLEANVALUE` boolean,
      `CHARVALUE` character(1),
      `SHORTVALUE` smallint,
      `BIGINTEGERVALUE` bigint,
      `BIGDECIMALVALUE` decimal(10,0),
      `OBJECTVALUE` bytea

      SQL qeuery - SELECT A.INTKEY, A.TIMESTAMPVALUE, A.FLOATNUM, (SELECT MIN(TIMESTAMPVALUE) FROM BQT1.SMALLA AS B WHERE (FLOATNUM >= 9) AND (B.INTKEY = A.INTKEY)) FROM BQT1.SMALLA AS A ORDER BY A.INTKEY

      Show
      How reproducible: Source databse - MariaDB 5.5 VDB view model - BQT1 tables: smalla - `INTKEY` integer primary key, `STRINGKEY` varing(10), `INTNUM` integer, `STRINGNUM` varing(10), `FLOATNUM` real, `LONGNUM` bigint, `DOUBLENUM` double, `BYTENUM` smallint, `DATEVALUE` date, `TIMEVALUE` time, `TIMESTAMPVALUE` timestamp, `BOOLEANVALUE` boolean, `CHARVALUE` character(1), `SHORTVALUE` smallint, `BIGINTEGERVALUE` bigint, `BIGDECIMALVALUE` decimal(10,0), `OBJECTVALUE` bytea SQL qeuery - SELECT A.INTKEY, A.TIMESTAMPVALUE, A.FLOATNUM, (SELECT MIN(TIMESTAMPVALUE) FROM BQT1.SMALLA AS B WHERE (FLOATNUM >= 9) AND (B.INTKEY = A.INTKEY)) FROM BQT1.SMALLA AS A ORDER BY A.INTKEY

      Description of problem:
      Query ends with exception. Same query for MariaDB database returns correct result but Teiid throws an exception.

      Actual results:
      Query ends with exception - TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: Unexpected exception while translating results: Error

      Expected results:
      No exception

      Additional info:
      excption stack trace and server log in attachment

        1. exception-stack-trace
          5 kB
        2. full-server.log
          2.46 MB
        3. server.log
          19 kB

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

              Created:
              Updated:
              Resolved: