public int getInt() { return convertTo(Value.INT).getInt(); }
private int getIntValue() { expression = expression.optimize(session); return expression.getValue(session).getInt(); }
/** * Get the sample size, if set. * * @param session the session * @return the sample size */ int getSampleSizeValue(Session session) { if (sampleSizeExpr == null) { return 0; } Value v = sampleSizeExpr.optimize(session).getValue(session); if (v == ValueNull.INSTANCE) { return 0; } return v.getInt(); }
/** * Returns the value of the specified column as an int. * * @param columnIndex (1,2,...) * @return the value * @throws SQLException if the column is not found or if the result set is * closed */ @Override public int getInt(int columnIndex) throws SQLException { try { debugCodeCall("getInt", columnIndex); return get(columnIndex).getInt(); } catch (Exception e) { throw logAndConvert(e); } }
/** * Returns the value of the specified column as an int. * * @param columnLabel the column label * @return the value * @throws SQLException if the column is not found or if the result set is * closed */ @Override public int getInt(String columnLabel) throws SQLException { try { debugCodeCall("getInt", columnLabel); return get(columnLabel).getInt(); } catch (Exception e) { throw logAndConvert(e); } }
/** * @see http://dev.mysql.com/doc/refman/5.7/en/select.html */ @Override public SQLTranslated translate(Select select, ObjectNode executionOn, Map<ObjectNode, Map<TableFilter, ObjectNode>> consistencyTableNodes) { ArrayList<Expression> expressions = select.getExpressions(); Expression[] exprList = expressions.toArray(new Expression[expressions.size()]); Expression limitExpr = select.getLimit(); Expression offsetExpr = select.getOffset(); Integer limit = null, offset = null; if (limitExpr != null) { limit = limitExpr.getValue(select.getSession()).getInt(); } if (offsetExpr != null) { offset = offsetExpr.getValue(select.getSession()).getInt(); } return translate(select, executionOn, consistencyTableNodes, exprList, limit, offset); }
idx = v.getInt(); if (idx < 0) { reverse = true;
private int readInt() { boolean minus = false; if (currentTokenType == MINUS) { minus = true; read(); } else if (currentTokenType == PLUS) { read(); } if (currentTokenType != VALUE) { throw DbException.getSyntaxError(sqlCommand, parseIndex, "integer"); } if (minus) { // must do that now, otherwise Integer.MIN_VALUE would not work currentValue = currentValue.negate(); } int i = currentValue.getInt(); read(); return i; }
int offset = offsetExpr.getValue(session).getInt(); if (offset > 0) { limitRows += offset;
public void resetResult(ResultTarget result) { if(!isPrepared()) { throw DbException.throwInternalError("executor not prepared."); } if (result instanceof LocalResult) { LocalResult r = (LocalResult) result; if (limitPushless) { Expression offsetExpr = prepared.getOffset(); SortOrder sortOrder = prepared.getSortOrder(); int offset = offsetExpr.getValue(session).getInt(); if(sortOrder == null) { //drop offset rows if sortOrder is null while (offset-- > 0) { if (!next()) { break; } } r.setOffset(0); } } else { r.setOffset(0); } } }
return ValueByte.get(convertToByte(getShort())); case INT: return ValueByte.get(convertToByte(getInt())); case LONG: return ValueByte.get(convertToByte(getLong())); return ValueShort.get(getByte()); case INT: return ValueShort.get(convertToShort(getInt())); case LONG: return ValueShort.get(convertToShort(getLong())); return ValueLong.get(getShort()); case INT: return ValueLong.get(getInt()); case DECIMAL: return ValueLong.get(convertToLong(getBigDecimal())); return ValueDecimal.get(BigDecimal.valueOf(getShort())); case INT: return ValueDecimal.get(BigDecimal.valueOf(getInt())); case LONG: return ValueDecimal.get(BigDecimal.valueOf(getLong())); return ValueDouble.get(getShort()); case INT: return ValueDouble.get(getInt()); case LONG: return ValueDouble.get(getLong());
} else { double d = v0.getDouble(); int p = v1 == null ? 0 : v1.getInt(); double f = Math.pow(10., p); double g = d * f; } else { result = ValueString.get(insert(v0.getString(), v1.getInt(), v2.getInt(), v3.getString()), database.getMode().treatEmptyStringsAsNull); result = ValueString.get(left(v0.getString(), v1.getInt()), database.getMode().treatEmptyStringsAsNull); break; case LOCATE: { int start = v2 == null ? 0 : v2.getInt(); result = ValueInt.get(locate(v0.getString(), v1.getString(), start)); break; int start = v2 == null ? 0 : v2.getInt(); result = ValueInt.get(locate(v1.getString(), v0.getString(), start)); break; int count = Math.max(0, v1.getInt()); result = ValueString.get(repeat(v0.getString(), count), database.getMode().treatEmptyStringsAsNull); result = ValueString.get(right(v0.getString(), v1.getInt()), database.getMode().treatEmptyStringsAsNull);
case RAND: { if (v0 != null) { session.getRandom().setSeed(v0.getInt()); case SECURE_RAND: result = ValueBytes.getNoCopy( MathUtils.secureRandomBytes(v0.getInt())); break; case ZERO: break; case CHAR: result = ValueString.get(String.valueOf((char) v0.getInt()), database.getMode().treatEmptyStringsAsNull); break; break; case SPACE: { int len = Math.max(0, v0.getInt()); char[] chars = new char[len]; for (int i = len - 1; i >= 0; i--) { Mode mode = database.getMode(); vt = (ValueTimestamp) vt.convertScale( mode.convertOnlyToSmallerScale, v0.getInt()); if (v0.getType() == Value.ARRAY) { Value v1 = getNullOrValue(session, args, values, 1); int element = v1.getInt();
int index = currentValue.getInt() - 1; if (index < 0 || index >= Constants.MAX_PARAMETER_INDEX) { throw DbException.getInvalidValueException(