[jira] [Commented] (HAWQ-215) View gp_distributed_log and gp_distributed_xacts need to be removed if we don't want to support it anymore.

["Ming LI (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15150029#comment-15150029 ] 

Ming LI commented on HAWQ-215:
------------------------------

All of below functions are useless:
gp_distributed_xacts__
gp_max_distributed_xid
gp_distributed_xid
gp_transaction_log
gp_distributed_log
However, some of them may be referred by ORCA module, (i.e. orca/scripts/log_runner/installcheck-workload.sql). And also we need refactor the code about distribute transaction in the future. So I would like to postpone this task.

> View gp_distributed_log and gp_distributed_xacts need to be removed if we don't want to support it anymore.
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-215
>                 URL: https://issues.apache.org/jira/browse/HAWQ-215
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Catalog
>            Reporter: Dong Li
>            Assignee: Ming LI
>             Fix For: 2.0.0
>
>
> View gp_distributed_log   depends on built-in function gp_distributed_log(). 
> And  gp_distributed_log() just return null. So the view can't work at all.
> So do view gp_distributed_xacts.
> {code}
> e=# select * from gp_distributed_log;
> ERROR:  function returning set of rows cannot return null value
> e=# select * from gp_distributed_xacts;
> ERROR:  function returning set of rows cannot return null value
> {code}
> function gp_distributed_log is defined in gp_distributed_log.c :27
> function gp_distributed_xacts  is defined in cdbdistributedxacts.c:44



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