Examples of SubQueryExpression

com.facebook.presto.sql.tree.SubqueryExpression
com.mysema.query.types.SubQueryExpression
SubQueryExpression represents a sub query. The actual construction of a subquery is done via an {@link Detachable} instance. @author tiwe @param < T> return type of subquery
org.datanucleus.query.expression.SubqueryExpression
Expression containing a subquery. A subquery is formed from a keyword and a variable expression representing the subquery, so something like
```
KEYWORD(subquery)
```
e.g
```
EXISTS (SELECT 1 FROM MYTABLE WHERE MYID = 4)
```
org.datanucleus.store.rdbms.sql.expression.SubqueryExpression
Expression containing a subquery.
org.jpox.store.mapped.expression.SubqueryExpression
An expression representing a subquery. @version $Revision: 1.6 $

Examples of com.facebook.presto.sql.tree.SubqueryExpression


        subPlan = appendProjections(subPlan, ImmutableList.of(inPredicate.getValue()));
        Symbol sourceJoinSymbol = subPlan.translate(inPredicate.getValue());


        Preconditions.checkState(inPredicate.getValueList() instanceof SubqueryExpression);
        SubqueryExpression subqueryExpression = (SubqueryExpression) inPredicate.getValueList();
        RelationPlanner relationPlanner = new RelationPlanner(analysis, symbolAllocator, idAllocator, metadata, session);
        RelationPlan valueListRelation = relationPlanner.process(subqueryExpression.getQuery(), null);
        Symbol filteringSourceJoinSymbol = Iterables.getOnlyElement(valueListRelation.getRoot().getOutputSymbols());


        Symbol semiJoinOutputSymbol = symbolAllocator.newSymbol("semijoinresult", Type.BOOLEAN);


        translations.put(inPredicate, semiJoinOutputSymbol);

View Full Code Here

Examples of com.facebook.presto.sql.tree.SubqueryExpression


        subPlan = appendProjections(subPlan, ImmutableList.of(inPredicate.getValue()));
        Symbol sourceJoinSymbol = subPlan.translate(inPredicate.getValue());


        Preconditions.checkState(inPredicate.getValueList() instanceof SubqueryExpression);
        SubqueryExpression subqueryExpression = (SubqueryExpression) inPredicate.getValueList();
        RelationPlanner relationPlanner = new RelationPlanner(analysis, symbolAllocator, idAllocator, metadata, session);
        RelationPlan valueListRelation = relationPlanner.process(subqueryExpression.getQuery(), null);
        Symbol filteringSourceJoinSymbol = Iterables.getOnlyElement(valueListRelation.getRoot().getOutputSymbols());


        Symbol semiJoinOutputSymbol = symbolAllocator.newSymbol("semijoinresult", Type.BOOLEAN);


        translations.put(inPredicate, semiJoinOutputSymbol);

View Full Code Here

Examples of com.mysema.query.types.SubQueryExpression


    } else if (operator.equals(Ops.NUMCAST)) {
      visitNumCast(args);


    } else if (operator.equals(Ops.EXISTS) && args.get(0) instanceof SubQueryExpression) {
      SubQueryExpression subQuery = (SubQueryExpression) args.get(0);
      append("exists (");
      serialize(subQuery.getMetadata(), false, templates.getExistsProjection());
      append(")");


    } else if (operator.equals(Ops.MATCHES) || operator.equals(Ops.MATCHES_IC)) {
      super.visitOperation(type, Ops.LIKE, Arrays.asList(args.get(0), ExpressionUtils.regexToLike((Expression<String>) args.get(1))));

View Full Code Here

Examples of org.datanucleus.query.expression.SubqueryExpression

            {
                SubqueryImpl sub = subqueryIter.next();
                org.datanucleus.query.expression.Expression subExpr = sub.getQueryExpression();
                if (subExpr instanceof SubqueryExpression)
                {
                    SubqueryExpression subqueryExpr = (SubqueryExpression) sub.getQueryExpression();
                    VariableExpression subqueryVar = (VariableExpression) subqueryExpr.getRight();
                    CriteriaQueryImpl<T> subDelegate = (CriteriaQueryImpl<T>) sub.getDelegate();
                    QueryCompilation subCompilation = subDelegate.getCompilation(mmgr, clr, compilation.getSymbolTable());
                    subCompilation.setQueryLanguage("JPQL");
                    compilation.addSubqueryCompilation(subqueryVar.getId(), subCompilation);
                }

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.expression.SubqueryExpression


        // Condition on key
        SQLExpression keyExpr = exprFactory.newExpression(subStmt, subStmt.getPrimaryTable(), keyMapping);
        subStmt.whereAnd(keyExpr.eq(keyValExpr), true);


        SubqueryExpression subExpr = new SubqueryExpression(stmt, subStmt);
        subExpr.setJavaTypeMapping(valMapping);
        return subExpr;
    }

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.expression.SubqueryExpression

        // Condition on key
        SQLExpression keyExpr = exprFactory.newExpression(subStmt, subStmt.getPrimaryTable(), indexMapping);
        subStmt.whereAnd(keyExpr.eq(idxExpr), true);


        // Create subquery, with mapping being of the element type (since "get" returns an element)
        SubqueryExpression subExpr = new SubqueryExpression(stmt, subStmt);
        subExpr.setJavaTypeMapping(elemMapping);
        return subExpr;
    }

View Full Code Here

Examples of org.jpox.store.mapped.expression.SubqueryExpression

            String inStr = p.parseIdentifier();
            if (query.hasSubqueryForVariable(inStr))
            {
                // IN (subquery)
                // Subqueries wont have brackets surrounding them - removed during JPQLSingleStringParser
                SubqueryExpression inExpr = (SubqueryExpression)compileSubqueryVariable(inStr);
                return inExpr.in(expr);
            }
            else
            {
                throw new QueryCompilerSyntaxException("Expected: '(' but got " + p.remaining(), 
                    p.getIndex(), p.getInput());

View Full Code Here

Examples of org.jpox.store.mapped.expression.SubqueryExpression

        QueryExpression subqueryExpr = (QueryExpression)subCompiler.compile(QueryCompiler.COMPILE_EXECUTION);


        // Make sure the result clause is added - this should be refactored into the Compiler from newROF()
        subCompiler.getCandidates().newResultObjectFactory(subqueryExpr, false, subCompiler.getResultClass(), true);


        ScalarExpression expr = new SubqueryExpression(qs, subqueryExpr);


        // Mark all subquery processed parameters as processed for this query too
        Set subProcessedParams = subCompiler.processedParameters;
        if (subProcessedParams != null)
        {

View Full Code Here

Examples of org.jpox.store.mapped.expression.SubqueryExpression

        QueryExpression subqueryExpr = (QueryExpression)subCompiler.compile(QueryCompiler.COMPILE_EXECUTION);


        // Make sure the result clause is added - this should be refactored into the Compiler from newROF()
        subCompiler.getCandidates().newResultObjectFactory(subqueryExpr, false, subCompiler.getResultClass(), true);


        ScalarExpression expr = new SubqueryExpression(qs, subqueryExpr);


        // Mark the variable as bound
        expressionsByVariableName.put(id, expr);


        return expr;

View Full Code Here

0 1 2

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.