[
https://issues.apache.org/jira/browse/TRAFODION-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15900691#comment-15900691
]
ASF GitHub Bot commented on TRAFODION-2527:
-------------------------------------------
GitHub user sureshsubbiah opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1000
[TRAFODION-2527] process abend when updating primary key with TRAF_RE…
…LOAD_NATABLE_CACHE 'ON'
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sureshsubbiah/incubator-trafodion naTableTop
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1000.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1000
----
commit 90aec8038aa046d7d8bb65fbc63f399e9bd8f38e
Author: Suresh Subbiah <[email protected]>
Date: 2017-03-08T04:35:11Z
[TRAFODION-2527] process abend when updating primary key with
TRAF_RELOAD_NATABLE_CACHE 'ON'
----
> process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE 'ON'
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-2527
> URL: https://issues.apache.org/jira/browse/TRAFODION-2527
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Priority: Minor
> Fix For: 2.2-incubating
>
>
> Updating primary key of a table with the cqd TRAF_RELOAD_NATABLE_CACHE 'ON'
> causes master executor to abend.
> To reproduce
> create table test1 like "_PRIVMGR_MD_".OBJECT_PRIVILEGES ;
> UPDATE test1 SET grantor_id = 33333, grantor_name = 'DB__ROOT',
> privileges_bitmap = 3, grantable_bitmap = 0 WHERE object_uid =
> 6220152955843408334 AND grantor_id = 33333 AND grantee_id = 1000000 ;
> The problem is that we call getScanIndexDesc() in Inlining.cpp while
> transforming the tree during binding of update primary key. Now scanIndexDesc
> is NULL is GU natable is different from source table NATable for an update.
> This code is meant for triggers but the determination was incorrectly made
> using a pointer comparision. Now we compare using table names.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
