phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4201) Remove usage of SCN from QueryDatabaseMetadataIT
Date Tue, 12 Sep 2017 22:05:00 GMT

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

James Taylor commented on PHOENIX-4201:
---------------------------------------

Thanks for fixing, [~samarthjain]. FYI, an empty string is null in Phoenix, so a clause such
as {{TABLE_SCHEM = ''}} will never match anything (since null = <anything> is always
false). So this query could simply be:
{code}
DELETE FROM SYSTEM.CATALOG WHERE TABLE_SCHEM IS NULL OR TABLE_SCHEM != 'SYSTEM'
{code}

> Remove usage of SCN from QueryDatabaseMetadataIT
> ------------------------------------------------
>
>                 Key: PHOENIX-4201
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4201
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>         Attachments: PHOENIX-4201_addendum.patch, PHOENIX-4201.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message