Examples of EquiJoinCondition

javax.jcr.query.qom.EquiJoinCondition
org.apache.jackrabbit.core.query.jsr283.qom.EquiJoinCondition
Tests whether the value of a property in a first selector is equal to the value of a property in a second selector.
A node-tuple satisfies the constraint only if:
- {@link #getSelector1Name selector1} has a property named{@link #getProperty1Name property1}, and
- {@link #getSelector2Name selector2} has a property named{@link #getProperty2Name property2}, and
- the value of {@link #getProperty1Name property1} equals the value of{@link #getProperty2Name property2}
The query is invalid if:
- {@link #getSelector1Name selector1} is not the name of a selector inthe query, or
- {@link #getSelector2Name selector2} is not the name of a selector inthe query, or
- {@link #getSelector1Name selector1} is the same as{@link #getSelector2Name selector2}, or
- {@link #getProperty1Name property1} is not a syntactically valid JCRname, or
- {@link #getProperty2Name property2} is not a syntactically valid JCRname, or
- the value of {@link #getProperty1Name property1} is not the sameproperty type as the name of {@link #getProperty2Name property2}, or
- {@link #getProperty1Name property1} is a multi-valued property, or
- {@link #getProperty2Name property2} is a multi-valued property, or
- {@link #getProperty1Name property1} is a BINARY property, or
- {@link #getProperty2Name property2} is a BINARY property.
@since JCR 2.0
org.apache.jackrabbit.spi.commons.query.jsr283.qom.EquiJoinCondition
Tests whether the value of a property in a first selector is equal to the value of a property in a second selector.
A node-tuple satisfies the constraint only if:
- {@link #getSelector1Name selector1} has a property named{@link #getProperty1Name property1}, and
- {@link #getSelector2Name selector2} has a property named{@link #getProperty2Name property2}, and
- the value of {@link #getProperty1Name property1} equals the value of{@link #getProperty2Name property2}
The query is invalid if:
- {@link #getSelector1Name selector1} is not the name of a selector inthe query, or
- {@link #getSelector2Name selector2} is not the name of a selector inthe query, or
- {@link #getSelector1Name selector1} is the same as{@link #getSelector2Name selector2}, or
- {@link #getProperty1Name property1} is not a syntactically valid JCRname, or
- {@link #getProperty2Name property2} is not a syntactically valid JCRname, or
- the value of {@link #getProperty1Name property1} is not the sameproperty type as the name of {@link #getProperty2Name property2}, or
- {@link #getProperty1Name property1} is a multi-valued property, or
- {@link #getProperty2Name property2} is a multi-valued property, or
- {@link #getProperty1Name property1} is a BINARY property, or
- {@link #getProperty2Name property2} is a BINARY property.
@since JCR 2.0
org.jboss.dna.graph.query.model.EquiJoinCondition
A join condition that tests whether a property on a node is equal to a property on another node. A node-tuple satisfies the constraint only if:
- the {@code selector1Name} node has a property named {@code property1Name}, and
- the {@code selector2Name} node has a property named {@code property2Name}, and
- the value of property {@code property1Name} is equal to the value of property {@code property2Name}
org.modeshape.jcr.query.model.EquiJoinCondition
A join condition that tests whether a property on a node is equal to a property on another node. A node-tuple satisfies the constraint only if:
- the {@code selector1Name} node has a property named {@code property1Name}, and
- the {@code selector2Name} node has a property named {@code property2Name}, and
- the value of property {@code property1Name} is equal to the value of property {@code property2Name}

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

    @Test
    public void shouldAddJoinConditionColumnOnBothSidesIfNotAlreadyUsed() {
        // Create a join ...
        PlanNode joinNode = new PlanNode(Type.JOIN);
        joinNode.setProperty(Property.JOIN_TYPE, JoinType.LEFT_OUTER);
        joinNode.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("left"), "c4", selector("right"), "d4"));
        PlanNode lhs = sourceNode(context, joinNode, "left", "c1", "c2", "c3");
        PlanNode rhs = sourceNode(context, joinNode, "right", "d1", "d2", "d3");


        // Execute the rule ...
        PlanNode result = rule.execute(context, joinNode, new LinkedList<OptimizerRule>());

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

    @Test
    public void shouldAddJoinConditionColumnOnBothSidesIfChildrenSwappedAndIfNotAlreadyUsed() {
        // Create a join ...
        PlanNode joinNode = new PlanNode(Type.JOIN);
        joinNode.setProperty(Property.JOIN_TYPE, JoinType.LEFT_OUTER);
        joinNode.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("right"), "d4", selector("left"), "c4"));
        PlanNode lhs = sourceNode(context, joinNode, "left", "c1", "c2", "c3");
        PlanNode rhs = sourceNode(context, joinNode, "right", "d1", "d2", "d3");


        // Execute the rule ...
        PlanNode result = rule.execute(context, joinNode, new LinkedList<OptimizerRule>());

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, selector("t2"), selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12"), column("t2", "c23")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12")));
        PlanNode leftSource = new PlanNode(Type.SOURCE, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

                            columns(column("type1", "a1", "a"), column("type1", "a2", "b"), column("type2", "a3", "c"),
                                    column("type2", "a4", "d")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("type1"), selector("type2"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("type1"), "a2", selector("type2"), "a3"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("type1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("type1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("type1", "a1"), column("type1", "a2")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("type1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, sort, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1"), column("t1", "c12")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1"), column("t1", "c12")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, sort, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1"), column("t1", "c12")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1"), column("t1", "c12")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, sort, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11", "c1")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, sort, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

Examples of org.modeshape.jcr.query.model.EquiJoinCondition

        PlanNode project = new PlanNode(Type.PROJECT, sort, selector("t1"));
        project.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12")));
        PlanNode join = new PlanNode(Type.JOIN, project, selector("t2"), selector("t1"));
        join.setProperty(Property.JOIN_ALGORITHM, JoinAlgorithm.NESTED_LOOP);
        join.setProperty(Property.JOIN_TYPE, JoinType.INNER);
        join.setProperty(Property.JOIN_CONDITION, new EquiJoinCondition(selector("t1"), "c11", selector("t2"), "c21"));


        PlanNode leftAccess = new PlanNode(Type.ACCESS, join, selector("t1"));
        PlanNode leftProject = new PlanNode(Type.PROJECT, leftAccess, selector("t1"));
        leftProject.setProperty(Property.PROJECT_COLUMNS, columns(column("t1", "c11"), column("t1", "c12")));
        PlanNode leftSelect1 = new PlanNode(Type.SELECT, leftProject, selector("t1"));

View Full Code Here

0 1 2 3 4 5

TOP

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.