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

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

本文整理了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

  1. query.setSession(session);
  2. if (!query.hasOrder()) {
  3. query.setDistinct(true);

代码示例来源:origin: com.h2database/h2

  1. left.setDistinct(true);
  2. right.setDistinct(true);
  3. result.setDistinct();
  4. case UNION:
  5. case EXCEPT:
  6. left.setDistinct(true);
  7. right.setDistinct(true);
  8. result.setDistinct();
  9. break;
  10. break;
  11. case INTERSECT:
  12. left.setDistinct(true);
  13. right.setDistinct(true);
  14. break;
  15. default:

代码示例来源:origin: com.h2database/com.springsource.org.h2

  1. result.setSortOrder(sort);
  2. if (distinct) {
  3. left.setDistinct(true);
  4. right.setDistinct(true);
  5. result.setDistinct();
  6. case UNION:
  7. case EXCEPT:
  8. left.setDistinct(true);
  9. right.setDistinct(true);
  10. result.setDistinct();
  11. break;
  12. break;
  13. case INTERSECT:
  14. left.setDistinct(true);
  15. right.setDistinct(true);
  16. break;
  17. default:

代码示例来源:origin: com.h2database/com.springsource.org.h2

  1. public Expression optimizeInJoin(Session session, Select select) throws SQLException {
  2. if (all || compareType != Comparison.EQUAL) {
  3. return this;
  4. }
  5. if (!query.isEverything(ExpressionVisitor.EVALUATABLE)) {
  6. return this;
  7. }
  8. String alias = query.getFirstColumnAlias(session);
  9. query.setDistinct(true);
  10. if (alias == null) {
  11. return this;
  12. }
  13. TableView view = TableView.createTempView(session, session.getUser(), query);
  14. TableFilter filter = new TableFilter(session, view, view.getName(), false, select);
  15. select.addTableFilter(filter, true);
  16. ExpressionColumn column = new ExpressionColumn(session.getDatabase(), null, view.getName(), alias);
  17. Expression on = new Comparison(session, Comparison.EQUAL, left, column);
  18. on.mapColumns(filter, 0);
  19. on.createIndexConditions(session, filter);
  20. filter.addFilterCondition(on, true);
  21. return ValueExpression.get(ValueBoolean.get(true));
  22. }

代码示例来源:origin: com.eventsourcing/h2

  1. left.setDistinct(true);
  2. right.setDistinct(true);
  3. result.setDistinct();
  4. case UNION:
  5. case EXCEPT:
  6. left.setDistinct(true);
  7. right.setDistinct(true);
  8. result.setDistinct();
  9. break;
  10. break;
  11. case INTERSECT:
  12. left.setDistinct(true);
  13. right.setDistinct(true);
  14. break;
  15. default:

代码示例来源:origin: org.wowtools/h2

  1. left.setDistinct(true);
  2. right.setDistinct(true);
  3. result.setDistinct();
  4. case UNION:
  5. case EXCEPT:
  6. left.setDistinct(true);
  7. right.setDistinct(true);
  8. result.setDistinct();
  9. break;
  10. break;
  11. case INTERSECT:
  12. left.setDistinct(true);
  13. right.setDistinct(true);
  14. break;
  15. default:

代码示例来源:origin: org.wowtools/h2

  1. query.setSession(session);
  2. if (!query.hasOrder()) {
  3. query.setDistinct(true);

代码示例来源:origin: com.eventsourcing/h2

  1. query.setSession(session);
  2. if (!query.hasOrder()) {
  3. query.setDistinct(true);

相关文章