@Override @Deprecated public final WindowSpecificationOrderByStep partitionByOne() { partitionByOne = true; partitionBy.add(one()); return null; }
@Override public final WindowSpecificationOrderByStep partitionByOne() { partitionByOne = true; partitionBy.add(one()); return null; }
@Override public final SelectSelectStep<Record1<Integer>> selectOne() { return new SelectImpl(configuration, this).select(one()); }
private static final Field<Integer> parseZeroOne(ParserContext ctx) { if (parseIf(ctx, '0')) return zero(); else if (parseIf(ctx, '1')) return one(); else throw ctx.expected("0 or 1"); }
@Override public SelectSelectStep<Record1<Integer>> selectOne() { return new SelectImpl(configuration(), null).select(one().as("one")); }
@Override final Field<BigDecimal> getFunction0(Configuration configuration) { switch (configuration.family()) { case CUBRID: case HSQLDB: case MARIADB: case MYSQL: case POSTGRES: return DSL.exp(argument.mul(two())).sub(one()).div(DSL.exp(argument.mul(two())).add(one())); default: return function("tanh", SQLDataType.NUMERIC, argument); } } }
private static final Field<Integer> parseZeroOneDefault(ParserContext ctx) { if (parseIf(ctx, '0')) return zero(); else if (parseIf(ctx, '1')) return one(); else if (parseKeywordIf(ctx, "DEFAULT")) return defaultValue(INTEGER); else throw ctx.expected("0 or 1"); }
@Override public void accept(Context<?> c) { c.visit(DSL.max(DSL.when(condition, one()).otherwise(zero()))); toSQLOverClause(c); } });
@SuppressWarnings("unchecked") @Override final Field<Integer> getFunction0(Configuration configuration) { switch (configuration.dialect()) { case SQLITE: return DSL .when(((Field<Integer>) argument).greaterThan(zero()), one()) .when(((Field<Integer>) argument).lessThan(zero()), one().neg()) .otherwise(zero()); default: return function("sign", getDataType(), argument); } } }
@Override public void accept(Context<?> c) { c.visit(DSL.min(DSL.when(condition, one()).otherwise(zero()))); toSQLOverClause(c); } });
case MYSQL: case POSTGRES: return DSL.exp(one());
@SuppressWarnings("serial") @Override public final void accept(Context<?> ctx) { switch (ctx.family()) { case POSTGRES: super.accept(ctx); break; default: final Field<Integer> max = DSL.field("{0}", Integer.class, new CustomQueryPart() { @Override public void accept(Context<?> c) { c.visit(DSL.max(DSL.when(condition, one()).otherwise(zero()))); toSQLOverClause(c); } }); ctx.visit(DSL.field(max.eq(one()))); break; } } }
@SuppressWarnings("serial") @Override public final void accept(Context<?> ctx) { switch (ctx.family()) { case POSTGRES: super.accept(ctx); break; default: final Field<Integer> max = DSL.field("{0}", Integer.class, new CustomQueryPart() { @Override public void accept(Context<?> c) { c.visit(DSL.min(DSL.when(condition, one()).otherwise(zero()))); toSQLOverClause(c); } }); ctx.visit(DSL.field(max.eq(one()))); break; } } }
@SuppressWarnings("unchecked") @Override final Field<Integer> getFunction0(Configuration configuration) { switch (configuration.dialect()) { /* [pro] xx xxxx xxxxxxx xxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx xxxxxxxxxx xx [/pro] */ case SQLITE: return DSL.decode() .when(((Field<Integer>) argument).greaterThan(zero()), one()) .when(((Field<Integer>) argument).lessThan(zero()), one().neg()) .otherwise(zero()); default: return function("sign", getDataType(), argument); } } }
private final <Q extends QueryPartList<? super Field<?>>> Q resolveAsterisk(Q result) { // [#109] [#489] [#7231]: SELECT * is only applied when at least one // table from the table source is "unknown", i.e. not generated from a // physical table. Otherwise, the fields are selected explicitly if (knownTableSource()) for (TableLike<?> table : getFrom()) for (Field<?> field : table.asTable().fields()) result.add(field); // The default is SELECT 1, when projections and table sources are // both empty if (getFrom().isEmpty()) result.add(one()); return result; }
@Override public void accept(Context<?> ctx) { switch (ctx.family()) { // [#6574] [#7183] Some databases do not allow for ORDER BY null clauses case DERBY: case HSQLDB: case POSTGRES: ctx.sql('(').visit(select(one())).sql(')'); break; default: ctx.visit(DSL.NULL().sortDefault()); break; } } }
@SuppressWarnings({ "unchecked" }) @Override public void accept(Context<?> ctx) { switch (ctx.family()) { case POSTGRES: ctx.visit(DSL.field("{width_bucket}({0}, {1}, {2}, {3})", getType(), field, low, high, buckets)); break; default: ctx.visit( DSL.when(field.lt(low), zero()) .when(field.ge(high), buckets.add(one())) .otherwise((Field<Integer>) DSL.floor(field.sub(low).mul(buckets).div(high.sub(low))).add(one())) ); break; } }
return DSL.position(DSL.substring(in, startIndex), search).add(startIndex).sub(one());
@Override final Field<BigDecimal> getFunction0(Configuration configuration) { switch (configuration.family()) { case CUBRID: case HSQLDB: case MARIADB: case MYSQL: case POSTGRES: return DSL.exp(argument.mul(two())).add(one()).div(DSL.exp(argument).mul(two())); default: return function("cosh", SQLDataType.NUMERIC, argument); } } }
@Override final Field<BigDecimal> getFunction0(Configuration configuration) { switch (configuration.family()) { case CUBRID: case HSQLDB: case MARIADB: case MYSQL: case POSTGRES: return DSL.exp(argument.mul(two())).sub(one()).div(DSL.exp(argument).mul(two())); default: return function("sinh", SQLDataType.NUMERIC, argument); } } }