Examples of toExplainPlanString()

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

390
391
392
393
394
395
396
397
398
399
400
        } else {
            assertEquals(1, pns.size());
            apn = pns.get(0).getChild(0);
        }

        assertTrue(apn.toExplainPlanString().toLowerCase().contains("partial"));
    }

    public void testPartialSerialAggregateOnJoin() {
        String sql;
        sql = "SELECT G.G_D1, RF.F_D2, COUNT(*) " +
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

561
562
563
564
565
566
567
568
569
570
571
        assertTrue(p instanceof AbstractScanPlanNode);
        assertNotNull(p.getInlinePlanNode(PlanNodeType.HASHAGGREGATE));

        pns = compileToFragments("SELECT F_D1, count(*) as tag FROM RF group by F_D1 order by tag");
        p = pns.get(0).getChild(0);
        /*/ to debug */ System.out.println("DEBUG: " + p.toExplainPlanString());
        assertTrue(p instanceof ProjectionPlanNode);
        assertTrue(p.getChild(0) instanceof OrderByPlanNode);
        p = p.getChild(0).getChild(0);
        assertTrue(p instanceof IndexScanPlanNode);
        assertNotNull(p.getInlinePlanNode(PlanNodeType.AGGREGATE));
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

570
571
572
573
574
575
576
577
578
579
580
        assertTrue(p instanceof IndexScanPlanNode);
        assertNotNull(p.getInlinePlanNode(PlanNodeType.AGGREGATE));

        pns = compileToFragments("SELECT F_D1, count(*) FROM RF group by F_D1 order by 2");
        p = pns.get(0).getChild(0);
        /*/ to debug */ System.out.println("DEBUG: " + p.toExplainPlanString());
        assertTrue(p instanceof ProjectionPlanNode);
        //assertTrue(p.getChild(0) instanceof LimitPlanNode);
        assertTrue(p.getChild(0) instanceof OrderByPlanNode);
        p = p.getChild(0).getChild(0);
        assertTrue(p instanceof IndexScanPlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
        pn = pn.getChild(0);
        assertTrue(pn instanceof ProjectionPlanNode);

        pn = compile("SELECT -8, T2.C FROM (select * from R1) T1, R1 T2 WHERE (T2.C + 5 ) > 44");
        pn = pn.getChild(0);
        System.out.println(pn.toExplainPlanString());
        assertTrue(pn instanceof ProjectionPlanNode);
    }

    public void testJoinsSimple() {
        AbstractPlanNode pn;
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

41
42
43
44
45
46
47
48
49
50
51
        AbstractPlanNode n;
        AbstractPlanNode pn;

        pns = compileToFragments("UPDATE R1 SET C = 1 WHERE C = 0");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        n = pn.getChild(0).getChild(0);
        assertTrue(n instanceof ReceivePlanNode);
        pn = pns.get(1);
        n = pn.getChild(0);
        assertTrue(n instanceof UpdatePlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

50
51
52
53
54
55
56
57
58
59
60
        n = pn.getChild(0);
        assertTrue(n instanceof UpdatePlanNode);

        pns = compileToFragments("DELETE FROM R1 WHERE C = 0");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        n = pn.getChild(0).getChild(0);
        assertTrue(n instanceof ReceivePlanNode);
        pn = pns.get(1);
        n = pn.getChild(0);
        assertTrue(n instanceof DeletePlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

59
60
61
62
63
64
65
66
67
68
69
        n = pn.getChild(0);
        assertTrue(n instanceof DeletePlanNode);

        pns = compileToFragments("INSERT INTO R1 VALUES (1, 2, 3)");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        n = pn.getChild(0).getChild(0);
        assertTrue(n instanceof ReceivePlanNode);
        pn = pns.get(1);
        n = pn.getChild(0);
        assertTrue(n instanceof InsertPlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

68
69
70
71
72
73
74
75
76
77
78
        n = pn.getChild(0);
        assertTrue(n instanceof InsertPlanNode);

        pns = compileToFragments("UPDATE P1 SET C = 1 WHERE C = 0");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        n = pn.getChild(0).getChild(0);
        assertTrue(n instanceof ReceivePlanNode);
        pn = pns.get(1);
        n = pn.getChild(0);
        assertTrue(n instanceof UpdatePlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

77
78
79
80
81
82
83
84
85
86
87
        n = pn.getChild(0);
        assertTrue(n instanceof UpdatePlanNode);

        pns = compileToFragments("DELETE FROM P1 WHERE C = 0");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        n = pn.getChild(0).getChild(0);
        assertTrue(n instanceof ReceivePlanNode);
        pn = pns.get(1);
        n = pn.getChild(0);
        assertTrue(n instanceof DeletePlanNode);
View Full Code Here

Examples of org.voltdb.plannodes.AbstractPlanNode.toExplainPlanString()

86
87
88
89
90
91
92
93
94
95
96
        n = pn.getChild(0);
        assertTrue(n instanceof DeletePlanNode);

        pns = compileToFragments("UPDATE P1 SET C = 1 WHERE A = 0");
        pn = pns.get(0);
        System.out.println(pn.toExplainPlanString());
        //n = pn.getChild(0);
        assertTrue(pn instanceof UpdatePlanNode);

        pns = compileToFragments("DELETE FROM P1 WHERE A = 0");
        pn = pns.get(0);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.