[IGNITE-7370] Drop test tables in each test case in H2DynamicTableSelfTest

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 2.4
• Component/s: sql
• Assignee: Unassigned
• Reporter: Kirill Shirokov
• Created: 10/Jan/18 09:44
• Updated: 14/Feb/19 08:55
• Resolved: 14/Feb/19 08:55

Description

Failing test cases are leaving tables they've created which in turn causes subsequent test cases to report false failures, e.g. when the latter test case tries to create a table with the same name.

It would be great for such tables tables to run down curtain and join the choir invisible in finally clause; an example:

    public void testInternalCreateExistingTable() throws Exception {
+               try {
                    execute("CREATE TABLE \"Person\" (\"id\" int, \"city\" varchar," +
                        " \"name\" varchar, \"surname\" varchar, \"age\" int, PRIMARY KEY (\"id\", \"city\")) " +
                        "template=\"cache\"");

                    GridTestUtils.assertThrows(null, new Callable<Object>() {
                        @Override public Object call() throws Exception {
                            execute("CREATE TABLE \"Person\" (\"id\" int, \"city\" varchar" +
                                ", \"name\" varchar, \"surname\" varchar, \"age\" int, PRIMARY KEY (\"id\", \"city\")) " +
                                "template=\"cache\"");

                            return null;
                        }
                    }, IgniteSQLException.class, "Table already exists: Person");
+               }
+               finally {
+                   execute("DROP TABLE \"Person\"");
+               }
...