Package org.codehaus.jparsec.examples.sql.ast

Examples of org.codehaus.jparsec.examples.sql.ast.UnionRelation

108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
  }
 
  public void testUnion() {
    Parser<Relation> parser = RelationParser.union(TABLE);
    assertParser(parser, "a", table("a"));
    assertParser(parser, "a union b", new UnionRelation(table("a"), false, table("b")));
    assertParser(parser, "a union all b union (c)",
        new UnionRelation(
            new UnionRelation(table("a"), true, table("b")),
            false, table("c")
        )
    );
    assertParser(parser, "a union all (b union (c))",
        new UnionRelation(
            table("a"),
            true,
            new UnionRelation(table("b"), false, table("c"))
        )
    );
  }
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
        new Select(false,
            Arrays.asList(new Projection(number(1), null)),
            Arrays.asList(table("t")),
            null, null, null));
    assertParser(parser, "select 1 from a union select distinct 2 from b",
        new UnionRelation(
            new Select(false,
                Arrays.asList(new Projection(number(1), null)),
                Arrays.asList(table("a")),
                null, null, null),
            false,
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
  @Test
  public void testUnion() {
    Parser<Relation> parser = RelationParser.union(TABLE);
    assertParser(parser, "a", table("a"));
    assertParser(parser, "a union b", new UnionRelation(table("a"), false, table("b")));
    assertParser(parser, "a union all b union (c)",
        new UnionRelation(
            new UnionRelation(table("a"), true, table("b")),
            false, table("c")
        )
    );
    assertParser(parser, "a union all (b union (c))",
        new UnionRelation(
            table("a"),
            true,
            new UnionRelation(table("b"), false, table("c"))
        )
    );
  }
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
        new Select(false,
            Arrays.asList(new Projection(number(1), null)),
            Arrays.asList(table("t")),
            null, null, null));
    assertParser(parser, "select 1 from a union select distinct 2 from b",
        new UnionRelation(
            new Select(false,
                Arrays.asList(new Projection(number(1), null)),
                Arrays.asList(table("a")),
                null, null, null),
            false,
View Full Code Here
TOP

Related Classes of org.codehaus.jparsec.examples.sql.ast.UnionRelation

  • org.codehaus.jparsec.examples.sql.parser.RelationParserTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.