1 Reply Latest reply on Sep 7, 2018 10:51 AM by Steven Hawkins

    Select label are not always read

    gadeyne.bram Master

      Hi,

       

      Has something changed in the JDBC driver?

       

      Since teiid 10.3 (I think) I something encounter problems with software not reading column labels where it used to do this in the past.

       

      e.g.

       

      select c.ICUSessionID, admw.wardname as AdmissionWard, disw.wardname as DischargeWard

      from #tmp_cohort c

      left join kd_matric.md_admissionwards admw on admw.wardid = pa.AdmissionWard

      left join kd_matric.md_dischargewards disw on disw.wardid = pa.DischargeWard;

       

      returns the columns ICUSessionID, wardname, wardname instead of the expected ICUSessionID, AdmissionWard, DischargeWard in Rstudio using RJDBC.

       

      I'm wondering if the is a change in Teiid or rather in RJDBC or some other software component.