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