[
https://issues.apache.org/jira/browse/TRAFODION-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2983.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.3
> Query fails with an internal error in the generator
> ---------------------------------------------------
>
> Key: TRAFODION-2983
> URL: https://issues.apache.org/jira/browse/TRAFODION-2983
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Major
> Fix For: 2.3
>
>
> The following script reproduces the problem:
> {quote}?section setup
> drop table if exists t1;
> drop table if exists t2;
> drop table if exists t3;
> create table t1
> (
> id1 varchar(50 bytes) no default not null not droppable not serialized
> , yn varchar(1 byte) default null not serialized
> )
> attributes aligned format
> ;
> create unique index t1pk ON t1
> (
> id1 asc
> )
> attributes aligned format
> ;
> create table t2
> (
> id1 varchar(50 bytes) no default not null not droppable not serialized
> , id3 varchar(50 bytes) no default not null not droppable not serialized
> , id2 varchar(4 bytes) default null not serialized
> , c1 varchar(50 bytes) default null not serialized
> )
> attributes aligned format
> ;
> create unique index t2pk ON t2
> (
> id1 asc
> , id3 asc
> )
> attributes aligned format
> ;
>
> create table t3
> (
> id2 varchar(50 bytes) no default not null not droppable not serialized
> , nm varchar(100 bytes) no default not null not droppable not serialized
> )
> attributes aligned format
> ;
> ?section s1
> -- reproduces the error
> prepare s1 from
> select t1.id1,
> t2.c1,
> decode(t1.yn, 'Y', (select t3.nm
> from t3
> where t3.id2 = t2.id2),
> 'N') yn
> from t1
> left outer join t2
> on t2.id1 = t1.id1
> where t1.id1 = 'this is a dummy ID string';
> {quote}
> When run, the PREPARE fails with an internal error in the generator, 7000.
> (On debug builds, it fails with a core.)
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
