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.
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.
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.