org.h2.command.dml.Query.setDistinct()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(2.6k)|赞(0)|评价(0)|浏览(157)

本文整理了Java中org.h2.command.dml.Query.setDistinct方法的一些代码示例,展示了Query.setDistinct的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.setDistinct方法的具体详情如下:
包路径:org.h2.command.dml.Query
类名称:Query
方法名:setDistinct

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);

相关文章