[jira] [Created] (TRAFODION-999) LP Bug: 1420826 - Turning off nested_joins fails meta-data query compilation

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

Alice Chen created TRAFODION-999:
------------------------------------

             Summary: LP Bug: 1420826 - Turning off nested_joins fails meta-data query  compilation
                 Key: TRAFODION-999
                 URL: https://issues.apache.org/jira/browse/TRAFODION-999
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Qifan Chen
            Assignee: Qifan Chen
            Priority: Critical


Turning off NJs renders the failure of meta-data query compilation compilations. 

--- SQL operation complete.
>>
>>cqd nested_joins 'off';

--- SQL operation complete.
>>
>>prepare s1 from
+>SELECT /*+ PARALLEL(4) */  /* OSr lavanya.n@hp.com - adhoc */  unique
+>backlog_item.so_no, backlog_item.so_item_no, backlog_hdr.msm, backlog_hdr.customer_no, to_char(backlog_hdr.hp_receive_date, 'YYYY-MM-DD'), to_char(backlog_hdr.order_load_date, 'YYYY-MM-DD'),
+>to_char(backlog_item.clean_date, 'YYYY-MM-DD'), backlog_item.material_no, backlog_item.product_line, backlog_item.bundle_dlr_price, backlog_hdr.consolidated_stati, backlog_hdr.order_reason
+>FROM backlog_hdr, backlog_item
+>WHERE
+>    backlog_hdr.legacy_order_no=backlog_item.legacy_order_no
+>and (backlog_hdr.is_valid is null or backlog_hdr.is_valid = 'Y')
+>and  (backlog_item.is_valid is null or backlog_item.is_valid = 'Y')
+>and (
+>     backlog_hdr.distrib_channel in ('C1','C2','C4')
+>    and backlog_hdr.om_region = 'EMEA'
+>    and backlog_hdr.order_type_descr = 'Trade Order'
+>      and backlog_hdr.order_load_date between to_date('2014-04-01','yyyy-mm-dd') and to_date('2014-07-31','yyyy-mm-dd')
+>      --and backlog_item.clean_date between to_date('2014-07-26','yyyy-mm-dd') and to_date('2014-07-31', 'yyyy-mm-dd')
+>      --and (backlog_hdr.customer_name not like 'Best2Serve BV' or backlog_hdr.customer_name is NULL)
+>  and backlog_item.higher_level = '0'
+>  and backlog_item.clean_date is not NULL
+>);

*** ERROR[4082] Object TRAFODION.OSSDBA.BACKLOG_HDR does not exist or is inaccessible.

*** ERROR[8822] The statement was not prepared.



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