[jira] [Created] (TRAFODION-362) LP Bug: 1328250 - SQL Compiler hits assert(FALSE) in Native Exprs code when query uses an MBIGS constant.

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-362:
------------------------------------

             Summary: LP Bug: 1328250 - SQL Compiler hits assert(FALSE) in Native Exprs code when query uses an MBIGS constant.
                 Key: TRAFODION-362
                 URL: https://issues.apache.org/jira/browse/TRAFODION-362
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Apache Trafodion
            Assignee: Apache Trafodion


DESCRIPTION:  SQL Compiler hits 'assert(FALSE)' at the end of PCodeCfg::getIntConstValue (...) [i.e. about line 1861 in ExpPCodeOptsConstProp.cpp  because the query generates a PCODE operand that is of type PCIT::MBIGS and is a constant.  The Native Expressions code does not currently support MBIGS type constants.

HOW-TO-REPRODUCE:  Run this test case:
CREATE TABLE news_item ( ni_id  NUMERIC(11)   UNSIGNED  NO DEFAULT NOT NULL PRIMARY KEY
,ni_headline CHAR(80)                   NO DEFAULT NOT NULL
,ni_summary       CHAR(255)                      NO DEFAULT NOT NULL
,ni_item     NUMERIC(11)   UNSIGNED NO DEFAULT NOT NULL
,ni_dts        TIMESTAMP(0)                       NO DEFAULT NOT NULL
,ni_source           CHAR(30)                          NO DEFAULT NOT NULL
,ni_author           CHAR(30)
);

CREATE TABLE news_xref (
nx_ni_id              NUMERIC(11)   UNSIGNED            NO DEFAULT NOT NULL
,nx_co_id            NUMERIC(11)   UNSIGNED            NO DEFAULT NOT NULL
,PRIMARY KEY (nx_ni_id ASC, nx_co_id ASC)
);

prepare s from update NEWS_ITEM
set NI_DTS = NI_DTS + interval '1' day
where NI_ID = (  select NX_NI_ID from NEWS_XREF where NX_CO_ID = ?) ;

NOTE: Fix is in
Assigned to LaunchPad User James Capps



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)