[jira] [Created] (TRAFODION-2969) Subquery with [first 1] in select list results in Normalizer internal error

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

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)