[ https://issues.apache.org/jira/browse/TRAFODION-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15355181#comment-15355181 ]
liu ming commented on TRAFODION-1731: ------------------------------------- Is it possible to add the DDL of PartDPartE, PartDPartEPartC and PartDPartEPartD? Otherwise it is not easy to reproduce it. > Compiler asserts in preCodeGen phase when compile a UPSERT stmt > --------------------------------------------------------------- > > Key: TRAFODION-1731 > URL: https://issues.apache.org/jira/browse/TRAFODION-1731 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Qifan Chen > Assignee: liu ming > > Compiler asserts in preCodeGen phase with the following message. > *** ERROR[7000] An internal error occurred in the code generator in file > ../generator/GenPreCode.cpp at line 1313: > valuesToBeBound.isEmpty(). > The query involved is as follows. > >>prepare xx from > +>UPSERT INTO PartDPartE (ID, dataPartEPartCID, valuePartDID) VALUES > +>(NVL( > +>(select a.id from PartDPartE a where a.dataPartEPartCID = (select b.id from > PartDPartEPartC b where b > .codeValue = '/literal1[itemID]') and a.valuePartDID = (select c.id from > ValuePartD c where c.dataType = > 'array' and c.partF is null and c.xxlength is null and c.zzlength is null and > c.xxItems is null and c.zzItems > is null ) ), DEFAULT), > +>(select d.id from PartDPartEPartC d where d.codeValue = > '/literal1[itemID]'), > +>(select e.id from ValuePartD e where e.dataType = 'array' and e.partF is > null and e.xxlength is null and e.m > axlength is null and e.xxItems is null and e.zzItems is null ) > +>) ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)