Select label are not always read

[gadeyne.bram]

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.

[shawkins]

Is this JDBC or ODBC?

With JDBC in the metadata there is both a column name and a label.  The column name is supposed to match the non-aliased column. 

There's a useJDBC4ColumnNameAndLabelSemantics connection property that can be set to false if you want the label to be reported as the column name.