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

is distinct from results in TEIID30167 could not find symbol

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 12.3, 12.1.2, 12.2.2
    • 12.2.1
    • Query Engine
    • None

    Description

      An error "Could not find symbol: n.hospadmissiontime" occurs when executing the statement below. I'll add a full sql script because this is executed in a procedure. Running this outside of a procedure does not seem to result in an issue.

      SELECT n.*
      FROM #tmp_admission_to_update tu
      join tmp_newvals n on n.admissionid = tu.patientid
      join tmp_oldvals o on o.admissionid = tu.patientid
      where tu.in_tbl and
      (
      n.hospadmissiontime is distinct from o.hospadmissiontime or
      n.origin is distinct from o.origin or
      n.hospital is distinct from o.hospital or
      n.gender is distinct from o.gender or
      n.nationality is distinct from o.nationality or
      n.postalcode is distinct from o.postalcode or
      n.country is distinct from o.country or
      n.hospitaldischargetime is distinct from o.hospitaldischargetime or
      n.destination is distinct from o.destination or
      n.warddischarge is distinct from o.warddischarge or
      (n.foto is null and o.foto is not null)
      )

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            gadeynebram Bram Gadeyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: