David Wayne Birdsall created TRAFODION-2969:
-----------------------------------------------
Summary: Subquery with [first 1] in select list results in
Normalizer internal error
Key: TRAFODION-2969
URL: https://issues.apache.org/jira/browse/TRAFODION-2969
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.3
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
The following script illustrates the error:
?section setup
CREATE TABLE subquery_table
(
x int no default not null,
y int,
primary key (x)
);
CREATE TABLE main_table
(
a int no default not null,
b int,
primary key (a)
);
?section testit
prepare s1 from
select
(select [FIRST 1] y aa from subquery_table b where b.x = a.b) as company_id
from main_table a;
?section testit2
prepare s1 from
select
(select y aa from subquery_table b where b.x = a.b) as company_id
from main_table a;
If we run section setup to create the tables, then run section testit, the
prepare fails with this error:
*** ERROR[2006] Internal error: assertion failure
(CmpCommon::getDefault(COMP_BOOL_137) == DF_ON) in file
../optimizer/NormItemExpr.cpp at line 6028.
The second query, in section testit2, on the other hand compiles and executes
just fine.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
