You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/03/08 04:37:38 UTC
[jira] [Commented] (TRAFODION-2527) process abend when updating
primary key with TRAF_RELOAD_NATABLE_CACHE 'ON'
[ 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 <su...@apache.org>
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)