Bram Gadeyne created TEIID-5804: ----------------------------------- Summary: is distinct from results in TEIID30167 could not find symbol Key: TEIID-5804 URL: https://issues.jboss.org/browse/TEIID-5804 Project: Teiid Issue Type: Bug Affects Versions: 12.2.1 Reporter: Bram Gadeyne Assignee: Steven Hawkins Attachments: not_working.sql, working.sql 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) ) -- This message was sent by Atlassian Jira (v7.12.1#712002)