[jira] [Commented] (PHOENIX-4201) Remove usage of SCN from QueryDatabaseMetadataIT

["James Taylor (JIRA)" <ji...@apache.org>]

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

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

[~samarthjain] - it'd be best to clear the client side and server side cache after deleting the metadata here, as soon we'll rely on the cache sometimes when we service these metadata API calls.
{code}
+    @Before
+    // We need to clean up phoenix metadata to ensure tests don't step on each other
+    public void deleteMetadata() throws Exception {
+        try (Connection conn = DriverManager.getConnection(getUrl())) {
+            String delete =
+                    "DELETE FROM SYSTEM.CATALOG WHERE TABLE_SCHEM IS NULL OR TABLE_SCHEM = '' OR TABLE_SCHEM != 'SYSTEM'";
+            conn.createStatement().executeUpdate(delete);
+            conn.commit();
+            delete = "DELETE FROM \"SYSTEM\".\"SEQUENCE\"";
+            conn.createStatement().executeUpdate(delete);
+            conn.commit();
+        }
+    }
{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.patch
>
>




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