HyperSQL Database 2.7.4 · org.hsqldb.types.NumberType

Modifier and Type	Field and Description
pack-priv static final BigDecimal	BD_1
public static final int	BIGINT_WIDTH
public static final int	bigintPrecision
pack-priv static final int	bigintSquareNumericPrecision
public static final int	BIT_WIDTH
public static final int	DECIMAL_WIDTH
pack-priv static final int	decimalLiteralPrecision
public static final int	defaultNumericPrecision
public static final int	defaultNumericScale
public static final int	DOUBLE_WIDTH
pack-priv static final int	doublePrecision
public static final int	INTEGER_WIDTH
pack-priv static final int	integerPrecision
public static final BigDecimal	MAX_DOUBLE
public static final BigDecimal	MAX_INT
public static final BigDecimal	MAX_LONG
public static final BigInteger	MAX_LONG_BI
public static final int	maxNumericPrecision
pack-priv static final BigDecimal	MBD_1
public static final BigDecimal	MIN_INT
public static final BigDecimal	MIN_LONG
public static final BigInteger	MIN_LONG_BI
public static final int	SMALLINT_WIDTH
pack-priv static final int	smallintPrecision
public static final Type	SQL_NUMERIC_DEFAULT_INT
public static final int	TINYINT_WIDTH
pack-priv static final int	tinyintPrecision
pack-priv final int	typeWidth

Constructor Summary

Access	Constructor and Description
public	NumberType(int type, long precision, int scale)

Method Summary

Modifier and Type	Method and Description
public Object	absolute(Object a) Overrides org.hsqldb.types.Type.absolute. All arithmetic ops are called on the pre-determined Type object of the result
public boolean	acceptsPrecision() Overrides org.hsqldb.types.Type.acceptsPrecision.
public boolean	acceptsScale() Overrides org.hsqldb.types.Type.acceptsScale.
public Object	add(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.add.
public boolean	canConvertFrom(Type otherType) Implements abstract org.hsqldb.types.Type.canConvertFrom.
public int	canMoveFrom(Type otherType) Overrides org.hsqldb.types.Type.canMoveFrom. When canConvertFrom() is true, can convert without changing the object
public Object	ceiling(Object a)
public int	compare(Session session, Object a, Object b) Implements abstract org.hsqldb.types.Type.compare.
public static int	compareBigDecimalToLongLimits(Object value)
public static int	compareDouble(double value1, double value2)
public static int	compareToLongLimits(BigDecimal value)
public static int	compareToLongLimits(BigInteger value)
public int	compareToTypeRange(Object o) Overrides org.hsqldb.types.Type.compareToTypeRange.
public int	compareToZero(Object a)
public Object	convertJavaToSQL(SessionInterface session, Object a) Overrides org.hsqldb.types.Type.convertJavaToSQL.
private static BigDecimal	convertToDecimal(Object a)
public Object	convertToDefaultType(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToDefaultType. Relaxes SQL parameter type enforcement for DECIMAL, allowing long values.
private static Double	convertToDouble(Object a) Converter from a numeric object to Double.
pack-priv static Integer	convertToInt(SessionInterface session, Object a, int type) Converter from a numeric object to Integer.
pack-priv static Long	convertToLong(SessionInterface session, Object a) Converter from a numeric object to Long.
public String	convertToSQLString(Object a) Implements abstract org.hsqldb.types.Type.convertToSQLString.
public String	convertToString(Object a) Implements abstract org.hsqldb.types.Type.convertToString.
public Object	convertToType(SessionInterface session, Object a, Type otherType) Implements abstract org.hsqldb.types.Type.convertToType. Same as castToType except for CHARACTER values.
public Object	convertToTypeJDBC(SessionInterface session, Object a, Type otherType) Overrides org.hsqldb.types.Type.convertToTypeJDBC. Convert type for JDBC reads.
public Object	convertToTypeLimits(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToTypeLimits.
public int	displaySize() Implements abstract org.hsqldb.types.Type.displaySize.
public Object	divide(Session session, Object a, Object b) Overrides org.hsqldb.types.Type.divide.
public Object	floor(Object a)
public Type	getAggregateType(Type other) Implements abstract org.hsqldb.types.Type.getAggregateType. Common type used in comparison operations.
public Type	getCombinedType(Session session, Type other, int operation) Implements abstract org.hsqldb.types.Type.getCombinedType. Returns a SQL type "wide" enough to represent the result of the expression.
public int	getDecimalPrecision() Returns decimal precision.
public String	getDefinition() Implements abstract org.hsqldb.types.Type.getDefinition. Returns the full definition of the type, including parameters
public String	getFullNameString() Overrides org.hsqldb.types.Type.getFullNameString. Returns the name of the type
public Type	getIntegralType()
public Class<T>	getJDBCClass() Implements abstract org.hsqldb.types.Type.getJDBCClass.
public String	getJDBCClassName() Implements abstract org.hsqldb.types.Type.getJDBCClassName. Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.
public int	getJDBCPrecision() Overrides org.hsqldb.types.Type.getJDBCPrecision.
public int	getJDBCTypeCode() Implements abstract org.hsqldb.types.Type.getJDBCTypeCode. Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.
public long	getMaxPrecision() Overrides org.hsqldb.types.Type.getMaxPrecision.
public int	getMaxScale() Overrides org.hsqldb.types.Type.getMaxScale.
public String	getNameString() Implements abstract org.hsqldb.types.Type.getNameString. Returns the name of the type
public int	getNominalWidth()
public static NumberType	getNumberType(int type, long precision, int scale)
public static NumberType	getNumberTypeForLiteral(BigDecimal value)
public int	getNumericPrecisionInRadix()
public int	getPrecision() Returns decimal precision for NUMERIC/DECIMAL.
public int	getPrecisionRadix() Overrides org.hsqldb.types.Type.getPrecisionRadix.
public boolean	isDecimalType() Overrides org.hsqldb.types.Type.isDecimalType.
public boolean	isExactNumberType() Overrides org.hsqldb.types.Type.isExactNumberType.
public boolean	isIntegralType() Overrides org.hsqldb.types.Type.isIntegralType.
public boolean	isNegative(Object a) Overrides org.hsqldb.types.Type.isNegative.
public boolean	isNumberType() Overrides org.hsqldb.types.Type.isNumberType.
public static boolean	isZero(Object a)
public Object	modulo(Session session, Object a, Object b, Type otherType)
public Object	multiply(Object a, Object b) Overrides org.hsqldb.types.Type.multiply.
public Object	negate(Object a) Overrides org.hsqldb.types.Type.negate.
public int	precedenceDegree(Type other) Overrides org.hsqldb.types.Type.precedenceDegree.
public static int	precision(BigDecimal o)
public Object	round(Object a, int s)
public static long	scaledDecimal(Object a, int scale)
public Object	subtract(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.subtract.
public static double	toDouble(Object a)
public Object	truncate(Object a, int s)

Inherited from org.hsqldb.types.Type:: acceptsFractionalPrecision arrayLimitCardinality canBeAssignedFrom canCompareDirect cardinality castToType collectionBaseType compare compare compile concat convertSQLToJava convertToJSON convertToJSON duplicate equals getAggregateType getCatalogName getChangeTimestamp getCharacterSet getCollation getComponents getDefaultArrayType getDefaultType getDefaultTypeWithSize getDegree getHSQLDBTypeCode getJDBCScale getJDBCTypeCode getName getOwner getReferences getSchemaName getSQL getSQLGenericTypeCode getType getType getType getTypeDefinition getTypeForJDBCConvertToken getTypeNr hashCode hashCode isArrayType isBinaryType isBitType isBooleanType isCharacterType isDateOrTimestampType isDateTimeType isDateTimeTypeWithZone isDistinctType isDomainType isIntervalDaySecondType isIntervalType isIntervalYearMonthType isLobType isMultisetType isObjectType isRowType isStructuredType isSupportedSQLType isTimestampType isTimeType isUUIDType matches requiresPrecision

Field Detail

BD_1	back to summary
pack-priv static final BigDecimal BD_1

BIGINT_WIDTH	back to summary
public static final int BIGINT_WIDTH

bigintPrecision	back to summary
public static final int bigintPrecision

bigintSquareNumericPrecision	back to summary
pack-priv static final int bigintSquareNumericPrecision

BIT_WIDTH	back to summary
public static final int BIT_WIDTH

DECIMAL_WIDTH	back to summary
public static final int DECIMAL_WIDTH

decimalLiteralPrecision	back to summary
pack-priv static final int decimalLiteralPrecision

defaultNumericPrecision	back to summary
public static final int defaultNumericPrecision

defaultNumericScale	back to summary
public static final int defaultNumericScale

DOUBLE_WIDTH	back to summary
public static final int DOUBLE_WIDTH

doublePrecision	back to summary
pack-priv static final int doublePrecision

INTEGER_WIDTH	back to summary
public static final int INTEGER_WIDTH

integerPrecision	back to summary
pack-priv static final int integerPrecision

MAX_DOUBLE	back to summary
public static final BigDecimal MAX_DOUBLE

MAX_INT	back to summary
public static final BigDecimal MAX_INT

MAX_LONG	back to summary
public static final BigDecimal MAX_LONG

MAX_LONG_BI	back to summary
public static final BigInteger MAX_LONG_BI

maxNumericPrecision	back to summary
public static final int maxNumericPrecision

MBD_1	back to summary
pack-priv static final BigDecimal MBD_1

MIN_INT	back to summary
public static final BigDecimal MIN_INT

MIN_LONG	back to summary
public static final BigDecimal MIN_LONG

MIN_LONG_BI	back to summary
public static final BigInteger MIN_LONG_BI

SMALLINT_WIDTH	back to summary
public static final int SMALLINT_WIDTH

smallintPrecision	back to summary
pack-priv static final int smallintPrecision

SQL_NUMERIC_DEFAULT_INT	back to summary
public static final Type SQL_NUMERIC_DEFAULT_INT

TINYINT_WIDTH	back to summary
public static final int TINYINT_WIDTH

tinyintPrecision	back to summary
pack-priv static final int tinyintPrecision

typeWidth	back to summary
pack-priv final int typeWidth

Constructor Detail

NumberType	back to summary
public NumberType(int type, long precision, int scale)

Method Detail

absolute	back to summary
public Object absolute(Object a) Overrides org.hsqldb.types.Type.absolute. Doc from org.hsqldb.types.Type.absolute. All arithmetic ops are called on the pre-determined Type object of the result

absolute

back to summary

public Object absolute(Object a)

Overrides org.hsqldb.types.Type.absolute.

Doc from org.hsqldb.types.Type.absolute.

All arithmetic ops are called on the pre-determined Type object of the result

acceptsPrecision	back to summary
public boolean acceptsPrecision() Overrides org.hsqldb.types.Type.acceptsPrecision.

acceptsScale	back to summary
public boolean acceptsScale() Overrides org.hsqldb.types.Type.acceptsScale.

add	back to summary
public Object add(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.add.

canConvertFrom	back to summary
public boolean canConvertFrom(Type otherType) Implements abstract org.hsqldb.types.Type.canConvertFrom.

canMoveFrom	back to summary
public int canMoveFrom(Type otherType) Overrides org.hsqldb.types.Type.canMoveFrom. Doc from org.hsqldb.types.Type.canMoveFrom. When canConvertFrom() is true, can convert without changing the object

canMoveFrom

back to summary

public int canMoveFrom(Type otherType)

Overrides org.hsqldb.types.Type.canMoveFrom.

Doc from org.hsqldb.types.Type.canMoveFrom.

When canConvertFrom() is true, can convert without changing the object

ceiling	back to summary
public Object ceiling(Object a)

compare	back to summary
public int compare(Session session, Object a, Object b) Implements abstract org.hsqldb.types.Type.compare.

compareBigDecimalToLongLimits	back to summary
public static int compareBigDecimalToLongLimits(Object value)

compareDouble	back to summary
public static int compareDouble(double value1, double value2)

compareToLongLimits	back to summary
public static int compareToLongLimits(BigDecimal value)

compareToLongLimits	back to summary
public static int compareToLongLimits(BigInteger value)

compareToTypeRange	back to summary
public int compareToTypeRange(Object o) Overrides org.hsqldb.types.Type.compareToTypeRange.

compareToZero	back to summary
public int compareToZero(Object a)

convertJavaToSQL	back to summary
public Object convertJavaToSQL(SessionInterface session, Object a) Overrides org.hsqldb.types.Type.convertJavaToSQL.

convertToDecimal	back to summary
private static BigDecimal convertToDecimal(Object a)

convertToDefaultType	back to summary
public Object convertToDefaultType(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToDefaultType. Relaxes SQL parameter type enforcement for DECIMAL, allowing long values.

convertToDefaultType

back to summary

public Object convertToDefaultType(SessionInterface session, Object a)

Implements abstract org.hsqldb.types.Type.convertToDefaultType.

Relaxes SQL parameter type enforcement for DECIMAL, allowing long values.

convertToDouble	back to summary
private static Double convertToDouble(Object a) Converter from a numeric object to Double. Input is checked to be within range represented by Double

convertToInt	back to summary
pack-priv static Integer convertToInt(SessionInterface session, Object a, int type) Converter from a numeric object to Integer. Input is checked to be within range represented by the given number type.

convertToLong	back to summary
pack-priv static Long convertToLong(SessionInterface session, Object a) Converter from a numeric object to Long. Input is checked to be within range represented by Long.

convertToSQLString	back to summary
public String convertToSQLString(Object a) Implements abstract org.hsqldb.types.Type.convertToSQLString.

convertToString	back to summary
public String convertToString(Object a) Implements abstract org.hsqldb.types.Type.convertToString.

convertToType

back to summary

public Object convertToType(SessionInterface session, Object a, Type otherType)

Implements abstract org.hsqldb.types.Type.convertToType.

Doc from org.hsqldb.types.Type.convertToType.

Same as castToType except for CHARACTER values. Perform string truncation of trailing spaces only. For other long strings, it raises an exception.

convertToTypeJDBC

back to summary

public Object convertToTypeJDBC(SessionInterface session, Object a, Type otherType)

Overrides org.hsqldb.types.Type.convertToTypeJDBC.

Doc from org.hsqldb.types.Type.convertToTypeJDBC.

Convert type for JDBC reads. Same as convertToType, but supports non-standard SQL conversions supported by JDBC

convertToTypeLimits	back to summary
public Object convertToTypeLimits(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToTypeLimits.

displaySize	back to summary
public int displaySize() Implements abstract org.hsqldb.types.Type.displaySize.

divide	back to summary
public Object divide(Session session, Object a, Object b) Overrides org.hsqldb.types.Type.divide.

floor	back to summary
public Object floor(Object a)

getAggregateType

back to summary

public Type getAggregateType(Type other)

Implements abstract org.hsqldb.types.Type.getAggregateType.

Doc from org.hsqldb.types.Type.getAggregateType.

Common type used in comparison operations. other must be comparable with this.

getCombinedType

back to summary

public Type getCombinedType(Session session, Type other, int operation)

Implements abstract org.hsqldb.types.Type.getCombinedType.

Returns a SQL type "wide" enough to represent the result of the expression.
A type is "wider" than the other if it can represent all its numeric values.
Arithmetic operation terms are promoted to a type that can represent the resulting values and avoid incorrect results.

FLOAT/REAL/DOUBLE used in an operation results in the same type, regardless of the type of the other operand. When the result or the expression is converted to the type of the target column for storage, an exception is thrown if the resulting value cannot be stored in the column

Types narrower than INTEGER (int) are promoted to INTEGER. The order of promotion is as follows

INTEGER, BIGINT, NUMERIC/DECIMAL

TINYINT and SMALLINT in any combination return INTEGER
TINYINT/SMALLINT/INTEGER and INTEGER return BIGINT
TINYINT/SMALLINT/INTEGER and BIGINT return NUMERIC/DECIMAL
BIGINT and BIGINT return NUMERIC/DECIMAL
REAL/FLOAT/DOUBLE and any type return REAL/FLOAT/DOUBLE
NUMERIC/DECIMAL any type other than REAL/FLOAT/DOUBLE returns NUMERIC/DECIMAL
In the case of NUMERIC/DECIMAL returned, the result precision is always large enough to express any value result, while the scale depends on the operation:
For ADD/SUBTRACT/DIVIDE, the scale is the larger of the two
For MULTIPLY, the scale is the sum of the two scales

getDecimalPrecision	back to summary
public int getDecimalPrecision() Returns decimal precision.

getDefinition

back to summary

public String getDefinition()

Implements abstract org.hsqldb.types.Type.getDefinition.

Doc from org.hsqldb.types.Type.getDefinition.

Returns the full definition of the type, including parameters

getFullNameString

back to summary

public String getFullNameString()

Overrides org.hsqldb.types.Type.getFullNameString.

Doc from org.hsqldb.types.Type.getFullNameString.

Returns the name of the type

getIntegralType	back to summary
public Type getIntegralType()

getJDBCClass	back to summary
public Class<T> getJDBCClass() Implements abstract org.hsqldb.types.Type.getJDBCClass.

getJDBCClassName

back to summary

public String getJDBCClassName()

Implements abstract org.hsqldb.types.Type.getJDBCClassName.

Doc from org.hsqldb.types.Type.getJDBCClassName.

Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.

getJDBCPrecision	back to summary
public int getJDBCPrecision() Overrides org.hsqldb.types.Type.getJDBCPrecision.

getJDBCTypeCode

back to summary

public int getJDBCTypeCode()

Implements abstract org.hsqldb.types.Type.getJDBCTypeCode.

Doc from org.hsqldb.types.Type.getJDBCTypeCode.

Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.

getMaxPrecision	back to summary
public long getMaxPrecision() Overrides org.hsqldb.types.Type.getMaxPrecision.

getMaxScale	back to summary
public int getMaxScale() Overrides org.hsqldb.types.Type.getMaxScale.

getNameString

back to summary

public String getNameString()

Implements abstract org.hsqldb.types.Type.getNameString.

Doc from org.hsqldb.types.Type.getNameString.

Returns the name of the type

getNominalWidth	back to summary
public int getNominalWidth()

getNumberType	back to summary
public static NumberType getNumberType(int type, long precision, int scale)

getNumberTypeForLiteral	back to summary
public static NumberType getNumberTypeForLiteral(BigDecimal value)

getNumericPrecisionInRadix	back to summary
public int getNumericPrecisionInRadix()

getPrecision	back to summary
public int getPrecision() Returns decimal precision for NUMERIC/DECIMAL. Returns binary precision for other parts.

getPrecisionRadix	back to summary
public int getPrecisionRadix() Overrides org.hsqldb.types.Type.getPrecisionRadix.

isDecimalType	back to summary
public boolean isDecimalType() Overrides org.hsqldb.types.Type.isDecimalType.

isExactNumberType	back to summary
public boolean isExactNumberType() Overrides org.hsqldb.types.Type.isExactNumberType.

isIntegralType	back to summary
public boolean isIntegralType() Overrides org.hsqldb.types.Type.isIntegralType.

isNegative	back to summary
public boolean isNegative(Object a) Overrides org.hsqldb.types.Type.isNegative.

isNumberType	back to summary
public boolean isNumberType() Overrides org.hsqldb.types.Type.isNumberType.

isZero	back to summary
public static boolean isZero(Object a)

modulo	back to summary
public Object modulo(Session session, Object a, Object b, Type otherType)

multiply	back to summary
public Object multiply(Object a, Object b) Overrides org.hsqldb.types.Type.multiply.

negate	back to summary
public Object negate(Object a) Overrides org.hsqldb.types.Type.negate.

precedenceDegree	back to summary
public int precedenceDegree(Type other) Overrides org.hsqldb.types.Type.precedenceDegree.

precision	back to summary
public static int precision(BigDecimal o)

round	back to summary
public Object round(Object a, int s)

scaledDecimal	back to summary
public static long scaledDecimal(Object a, int scale)

subtract	back to summary
public Object subtract(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.subtract.

toDouble	back to summary
public static double toDouble(Object a)

truncate	back to summary
public Object truncate(Object a, int s)

public final Class NumberType

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail