[
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)
