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

Osisoft translator - MOD fails with non-integer arguments

    Details

      Description

      Query such as

      SELECT FloatNum, 11, MOD(FloatNum, 11) FROM BQT1.SmallA
      

      fails on the PI server with

      com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 1:34] [%] Overload resolution failed for (Single, Single) argument(s).
      

      Similarly for Double arguments. It appears that the modulo operator % is only defined when both arguments are integers (contrary to PI OLEDB Enterprise 2016 User Guide, which states that it is defined for all numeric data types)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                asmigala Andrej Šmigala
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: