本文整理汇总了Java中com.facebook.presto.sql.tree.NaturalJoin类的典型用法代码示例。如果您正苦于以下问题:Java NaturalJoin类的具体用法?Java NaturalJoin怎么用?Java NaturalJoin使用的例子?那么, 这里精选的类代码示例或许可以为您提供帮助。
NaturalJoin类属于com.facebook.presto.sql.tree包,在下文中一共展示了NaturalJoin类的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: testJoinPrecedence
import com.facebook.presto.sql.tree.NaturalJoin; //导入依赖的package包/类
@Test
public void testJoinPrecedence()
{
assertStatement("SELECT * FROM a CROSS JOIN b LEFT JOIN c ON true",
simpleQuery(
selectList(new AllColumns()),
new Join(
Join.Type.LEFT,
new Join(
Join.Type.CROSS,
new Table(QualifiedName.of("a")),
new Table(QualifiedName.of("b")),
Optional.empty()
),
new Table(QualifiedName.of("c")),
Optional.of(new JoinOn(BooleanLiteral.TRUE_LITERAL)))));
assertStatement("SELECT * FROM a CROSS JOIN b NATURAL JOIN c CROSS JOIN d NATURAL JOIN e",
simpleQuery(
selectList(new AllColumns()),
new Join(
Join.Type.INNER,
new Join(
Join.Type.CROSS,
new Join(
Join.Type.INNER,
new Join(
Join.Type.CROSS,
new Table(QualifiedName.of("a")),
new Table(QualifiedName.of("b")),
Optional.empty()
),
new Table(QualifiedName.of("c")),
Optional.of(new NaturalJoin())),
new Table(QualifiedName.of("d")),
Optional.empty()
),
new Table(QualifiedName.of("e")),
Optional.of(new NaturalJoin()))));
}