Quoted column name bug?
bluesgtrst Feb 6, 2012 4:32 PMI had a problem with this on Teiid 7.3 that I was hoping 7.6 would resolve.
But unfortunately it did not Anyone have a suggested workaround or quick fix ?
Teiid query:
select "__objecttype__" from SECCM.CMCOMMONVIEW LIMIT 10
Error Code:0 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:0 Message:SECCM: Error Code:0 Message:'Lexical error: Lexical error at line 1, column 12. Encountered: "_" (95), after : ""' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.__objecttype__ AS c_0 FROM ( select "__objecttype__", evttypecode, evtversion , evtcatcode , evtsysid , evtsysplex , evtutctod , evtsystod ,
Note that teiid view is defined with column as “__objecttype__” .
Ex.
<models>
<model name="SECCM">
<view name="CMCOMMONVIEW">
<definition>
select datamart_name, "__objecttype__", evttypecode, evtversion , evtcatcode , evtsysid , evtsysplex , evtutctod , evtsystod ,
evtesmcode , evtpuuid , evtuserid , evtusername, evtjobname , evtsource , admtarget , Commandstr, oprcode ,
vio1code , vio2code , evttypedesc , evtcatdesc
FROM (
#foreach($t in $db.query("select DATAMART_NAME, MODEL_NAME from security_db.config WHERE TYPE = 'DM'"))
select u.datamart_name, u."__objecttype__", u.evttypecode, u.evtversion , u.evtcatcode , u.evtsysid , u.evtsysplex , u.evtutctod , u.evtsystod ,
u.evtesmcode , u.evtpuuid , u.evtuserid , u.evtusername, u.evtjobname , u.evtsource , u.admtarget , u.Commandstr, u.oprcode ,
u.vio1code , u.vio2code , tp.evttypedesc , ct.evtcatdesc
FROM (
select '${t.DATAMART_NAME}' as DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' as "__objecttype__", a.evttypecode , a.evtversion , a.evtcatcode , a.evtsysid ,
a.evtsysplex , a.evtutctod , a.evtsystod , a.evtesmcode , a.evtpuuid , a.evtuserid , a.evtusername, a.evtjobname ,
a.evtsource , a.admtarget , a.admacctstr as Commandstr, a.oprcode , a.vio1code , a.vio2code
from ${t.MODEL_NAME}.ADMACCOUNT a
Please see attached for showplan output.
Thanks,
Jeff
...
-
Teiid_objecttype_bug.txt.zip 3.5 KB