Examples with ShowRoles com.facebook.presto.sql.tree.ShowRoles used on opensource projects

Example 1 with ShowRoles

use of com.facebook.presto.sql.tree.ShowRoles in project presto by prestodb.

the class TestSqlParser method testShowRoles.

@Test
public void testShowRoles() throws Exception {
    assertStatement("SHOW ROLES", new ShowRoles(Optional.empty(), false));
    assertStatement("SHOW ROLES FROM foo", new ShowRoles(Optional.of(new Identifier("foo")), false));
    assertStatement("SHOW ROLES IN foo", new ShowRoles(Optional.of(new Identifier("foo")), false));
    assertStatement("SHOW CURRENT ROLES", new ShowRoles(Optional.empty(), true));
    assertStatement("SHOW CURRENT ROLES FROM foo", new ShowRoles(Optional.of(new Identifier("foo")), true));
    assertStatement("SHOW CURRENT ROLES IN foo", new ShowRoles(Optional.of(new Identifier("foo")), true));
}