Package org.h2.value
Class ValueInterval
Implementation of the INTERVAL data type.
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final int
The default leading field precision for intervals.static final int
The default scale for intervals with seconds.private final long
static final int
The maximum leading field precision for intervals.static final int
The maximum scale for intervals with seconds.private static final long[]
private final boolean
private final long
private final int
Fields inherited from class org.h2.value.Value
ARRAY, ASSIGN_TO, BIGINT, BINARY, BLOB, BOOLEAN, CAST_TO, CHAR, CLOB, CONVERT_TO, DATE, DECFLOAT, DOUBLE, EMPTY_VALUES, ENUM, GEOMETRY, GROUP_BINARY_STRING, GROUP_BOOLEAN, GROUP_CHARACTER_STRING, GROUP_COLLECTION, GROUP_DATETIME, GROUP_INTERVAL_DT, GROUP_INTERVAL_YM, GROUP_NULL, GROUP_NUMERIC, GROUP_OTHER, GROUPS, INTEGER, INTERVAL_DAY, INTERVAL_DAY_TO_HOUR, INTERVAL_DAY_TO_MINUTE, INTERVAL_DAY_TO_SECOND, INTERVAL_HOUR, INTERVAL_HOUR_TO_MINUTE, INTERVAL_HOUR_TO_SECOND, INTERVAL_MINUTE, INTERVAL_MINUTE_TO_SECOND, INTERVAL_MONTH, INTERVAL_SECOND, INTERVAL_YEAR, INTERVAL_YEAR_TO_MONTH, JAVA_OBJECT, JSON, MAX_LONG_DECIMAL, MIN_LONG_DECIMAL, NULL, NUMERIC, REAL, ROW, SMALLINT, TIME, TIME_TZ, TIMESTAMP, TIMESTAMP_TZ, TINYINT, TYPE_COUNT, UNKNOWN, UUID, VARBINARY, VARCHAR, VARCHAR_IGNORECASE
Fields inherited from interface org.h2.util.HasSQL
ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS
-
Constructor Summary
ConstructorsModifierConstructorDescriptionprivate
ValueInterval
(int type, boolean negative, long leading, long remaining) -
Method Summary
Modifier and TypeMethodDescriptionAdd a value and return the result.(package private) boolean
checkPrecision
(long prec) Check if the precision is smaller or equal than the given precision.int
compareTypeSafe
(Value v, CompareMode mode, CastDataProvider provider) Compare this value against another value given that the values are of the same data type.boolean
Check if the two values have the same hash code.static ValueInterval
from
(IntervalQualifier qualifier, boolean negative, long leading, long remaining) Create a ValueInterval instance.static int
getDisplaySize
(int type, int precision, int scale) Returns display size for the specified qualifier, precision and fractional seconds precision.double
Returns this value as a Javadouble
value.float
getFloat()
Returns this value as a Javafloat
value.Returns the interval.long
Returns value of leading field of this interval.long
getLong()
Returns this value as a Javalong
value.int
Get the memory used by this object.Returns the interval qualifier.long
Returns combined value of remaining fields of this interval.int
getSQL
(StringBuilder builder, int sqlFlags) Appends the SQL statement of this object to the specified builder.Get the value as a string.getType()
Returns the data type.int
Get the value type.int
hashCode()
boolean
Returns where the interval is negative.negate()
Return -value if this value support arithmetic operations.(package private) ValueInterval
setPrecisionAndScale
(TypeInfo targetType, Object column) Subtract a value and return the result.Methods inherited from class org.h2.value.Value
cache, castTo, charLength, clearCache, compareTo, compareWithNull, containsNull, convertForAssignTo, convertTo, convertTo, convertTo, convertTo, convertTo, convertToAnyArray, convertToAnyRow, convertToBigint, convertToBoolean, convertToChar, convertToDate, convertToDouble, convertToEnum, convertToGeometry, convertToInt, convertToInt, convertToJavaObject, convertToReal, convertToSmallint, convertToTinyint, convertToUuid, divide, getBoolean, getByte, getBytes, getBytesNoCopy, getDataConversionError, getDataConversionError, getHigherOrder, getHigherOrderKnown, getInputStream, getInputStream, getInt, getReader, getReader, getShort, getTypeName, getUnsupportedExceptionForOperation, getValueTooLongException, isFalse, isTrue, modulus, multiply, octetLength, rangeCheck, toString
Methods inherited from class org.h2.value.VersionedValue
getCommittedValue, getCurrentValue, getOperationId, isCommitted
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.h2.util.HasSQL
getSQL, getTraceSQL
-
Field Details
-
DEFAULT_PRECISION
public static final int DEFAULT_PRECISIONThe default leading field precision for intervals.- See Also:
-
MAXIMUM_PRECISION
public static final int MAXIMUM_PRECISIONThe maximum leading field precision for intervals.- See Also:
-
DEFAULT_SCALE
public static final int DEFAULT_SCALEThe default scale for intervals with seconds.- See Also:
-
MAXIMUM_SCALE
public static final int MAXIMUM_SCALEThe maximum scale for intervals with seconds.- See Also:
-
MULTIPLIERS
private static final long[] MULTIPLIERS -
valueType
private final int valueType -
negative
private final boolean negative -
leading
private final long leading -
remaining
private final long remaining
-
-
Constructor Details
-
ValueInterval
private ValueInterval(int type, boolean negative, long leading, long remaining)
-
-
Method Details
-
from
public static ValueInterval from(IntervalQualifier qualifier, boolean negative, long leading, long remaining) Create a ValueInterval instance.- Parameters:
qualifier
- qualifiernegative
- whether interval is negativeleading
- value of leading fieldremaining
- values of all remaining fields- Returns:
- interval value
-
getDisplaySize
public static int getDisplaySize(int type, int precision, int scale) Returns display size for the specified qualifier, precision and fractional seconds precision.- Parameters:
type
- the value typeprecision
- leading field precisionscale
- fractional seconds precision. Ignored if specified type of interval does not have seconds.- Returns:
- display size
-
getSQL
Description copied from interface:HasSQL
Appends the SQL statement of this object to the specified builder.- Parameters:
builder
- string buildersqlFlags
- formatting flags- Returns:
- the specified string builder
-
getType
Description copied from interface:Typed
Returns the data type. -
getValueType
public int getValueType()Description copied from class:Value
Get the value type.- Specified by:
getValueType
in classValue
- Returns:
- the value type
-
getMemory
public int getMemory()Description copied from class:Value
Get the memory used by this object. -
checkPrecision
boolean checkPrecision(long prec) Check if the precision is smaller or equal than the given precision.- Parameters:
prec
- the maximum precision- Returns:
- true if the precision of this value is smaller or equal to the given precision
-
setPrecisionAndScale
-
getString
Description copied from class:Value
Get the value as a string. -
getLong
public long getLong()Description copied from class:Value
Returns this value as a Javalong
value. -
getBigDecimal
- Overrides:
getBigDecimal
in classValue
-
getFloat
public float getFloat()Description copied from class:Value
Returns this value as a Javafloat
value. -
getDouble
public double getDouble()Description copied from class:Value
Returns this value as a Javadouble
value. -
getInterval
Returns the interval.- Returns:
- the interval
-
getQualifier
Returns the interval qualifier.- Returns:
- the interval qualifier
-
isNegative
public boolean isNegative()Returns where the interval is negative.- Returns:
- where the interval is negative
-
getLeading
public long getLeading()Returns value of leading field of this interval. ForSECOND
intervals returns integer part of seconds.- Returns:
- value of leading field
-
getRemaining
public long getRemaining()Returns combined value of remaining fields of this interval. ForSECOND
intervals returns nanoseconds.- Returns:
- combined value of remaining fields
-
hashCode
public int hashCode() -
equals
Description copied from class:Value
Check if the two values have the same hash code. No data conversion is made; this method returns false if the other object is not of the same class. For some values, compareTo may return 0 even if equals return false. Example: ValueDecimal 0.0 and 0.00. -
compareTypeSafe
Description copied from class:Value
Compare this value against another value given that the values are of the same data type.- Specified by:
compareTypeSafe
in classValue
- Parameters:
v
- the other valuemode
- the compare modeprovider
- the cast information provider- Returns:
- 0 if both values are equal, -1 if the other value is smaller, and 1 otherwise
-
getSignum
public int getSignum() -
add
Description copied from class:Value
Add a value and return the result. -
subtract
Description copied from class:Value
Subtract a value and return the result. -
negate
Description copied from class:Value
Return -value if this value support arithmetic operations.
-