You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Qifan Chen (JIRA)" <ji...@apache.org> on 2015/12/31 14:48:49 UTC
[jira] [Created] (TRAFODION-1731) Compiler asserts in preCodeGen
phase when compile a UPSERT stmt
Qifan Chen created TRAFODION-1731:
-------------------------------------
Summary: 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
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)