Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-894

Add implicit conversion of NULL to correct datatype in transformation validator

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.4
    • 6.0.0
    • Validation
    • None

    Description

      When using NULL value as a column (ie, NULL as columnName), it is only implicitly converted to a string. When trying to use the NULL as a column of type date, integer, float, etc., the validator throws a warning that the transformation is not valid. If you wrap the NULL in a convert to the correct column datatype (ie, "convert(NULL,date)"), the transformation can be validated successfully.

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-mshirley Marc Shirley (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: