[
https://issues.apache.org/jira/browse/TRAFODION-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming reassigned TRAFODION-1731:
-----------------------------------
Assignee: liu ming
> 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)
