本文整理了Java中org.h2.command.dml.Query.setDistinct
方法的一些代码示例,展示了Query.setDistinct
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.setDistinct
方法的具体详情如下:
包路径:org.h2.command.dml.Query
类名称:Query
方法名:setDistinct
[英]Set the distinct flag.
[中]设置不同的标志。
代码示例来源:origin: com.h2database/h2
query.setSession(session);
if (!query.hasOrder()) {
query.setDistinct(true);
代码示例来源:origin: com.h2database/h2
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
case UNION:
case EXCEPT:
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
break;
break;
case INTERSECT:
left.setDistinct(true);
right.setDistinct(true);
break;
default:
代码示例来源:origin: com.h2database/com.springsource.org.h2
result.setSortOrder(sort);
if (distinct) {
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
case UNION:
case EXCEPT:
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
break;
break;
case INTERSECT:
left.setDistinct(true);
right.setDistinct(true);
break;
default:
代码示例来源:origin: com.h2database/com.springsource.org.h2
public Expression optimizeInJoin(Session session, Select select) throws SQLException {
if (all || compareType != Comparison.EQUAL) {
return this;
}
if (!query.isEverything(ExpressionVisitor.EVALUATABLE)) {
return this;
}
String alias = query.getFirstColumnAlias(session);
query.setDistinct(true);
if (alias == null) {
return this;
}
TableView view = TableView.createTempView(session, session.getUser(), query);
TableFilter filter = new TableFilter(session, view, view.getName(), false, select);
select.addTableFilter(filter, true);
ExpressionColumn column = new ExpressionColumn(session.getDatabase(), null, view.getName(), alias);
Expression on = new Comparison(session, Comparison.EQUAL, left, column);
on.mapColumns(filter, 0);
on.createIndexConditions(session, filter);
filter.addFilterCondition(on, true);
return ValueExpression.get(ValueBoolean.get(true));
}
代码示例来源:origin: com.eventsourcing/h2
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
case UNION:
case EXCEPT:
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
break;
break;
case INTERSECT:
left.setDistinct(true);
right.setDistinct(true);
break;
default:
代码示例来源:origin: org.wowtools/h2
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
case UNION:
case EXCEPT:
left.setDistinct(true);
right.setDistinct(true);
result.setDistinct();
break;
break;
case INTERSECT:
left.setDistinct(true);
right.setDistinct(true);
break;
default:
代码示例来源:origin: org.wowtools/h2
query.setSession(session);
if (!query.hasOrder()) {
query.setDistinct(true);
代码示例来源:origin: com.eventsourcing/h2
query.setSession(session);
if (!query.hasOrder()) {
query.setDistinct(true);
内容来源于网络,如有侵权,请联系作者删除!