@Test
  public void testCreateFunctionCaseInsensitive() throws Exception {
    Function function = testFunctions[0];

    function.setFunctionName("Test_Upper_Case_Func_Name");
    client.createFunction(function);

    String storedName = client.getFunction(function.getDbName(),
        function.getFunctionName()).getFunctionName();
    Assert.assertEquals(function.getFunctionName().toLowerCase(), storedName);
  }
This test creates and queries a function and then drops it. Good for testing the happy path.
standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/client/TestFunctions.java