Class BaseExpressionActivation

java.lang.Object
org.apache.derby.impl.sql.execute.BaseExpressionActivation

public abstract class BaseExpressionActivation extends Object
BaseExpressionActivation Support needed by Expression evaluators (Filters) and by ResultSet materializers (Activations)
  • Constructor Details

    • BaseExpressionActivation

      BaseExpressionActivation()
  • Method Details

    • minValue

      public static DataValueDescriptor minValue(DataValueDescriptor v1, DataValueDescriptor v2, DataValueDescriptor v3, DataValueDescriptor v4, int judgeTypeFormatId, int judgeUserJDBCTypeId, int judgePrecision, int judgeScale, boolean judgeIsNullable, int judgeMaximumWidth, int judgeCollationType, int judgeCollationDerivation) throws StandardException

      Get the minimum value of 4 input values. If less than 4 values, input null for the unused parameters and place them at the end. If more than 4 input values, call this multiple times to accumulate results. Also have judge's type as parameter to have a base upon which the comparison is based. An example use is for code generation in bug 3858.

      If all the input values are SQL NULL, return SQL NULL. Otherwise, return the minimum value of the non-NULL inputs.

      Parameters:
      v1 - 1st value
      v2 - 2nd value
      v3 - 3rd value
      v4 - 4th value
      judgeTypeFormatId - type format id of the judge
      judgeUserJDBCTypeId - JDBC type id if judge is user type; -1 if not user type
      judgePrecision - precision of the judge
      judgeScale - scale of the judge
      judgeIsNullable - nullability of the judge
      judgeMaximumWidth - maximum width of the judge
      judgeCollationType - collation type of the judge
      judgeCollationDerivation - collation derivation of the judge
      Returns:
      The minimum value of the 4.
      Throws:
      StandardException
    • maxValue

      public static DataValueDescriptor maxValue(DataValueDescriptor v1, DataValueDescriptor v2, DataValueDescriptor v3, DataValueDescriptor v4, int judgeTypeFormatId, int judgeUserJDBCTypeId, int judgePrecision, int judgeScale, boolean judgeIsNullable, int judgeMaximumWidth, int judgeCollationType, int judgeCollationDerivation) throws StandardException

      Get the maximum value of 4 input values. If less than 4 values, input null for the unused parameters and place them at the end. If more than 4 input values, call this multiple times to accumulate results. Also have judge's type as parameter to have a base upon which the comparison is based. An example use is for code generation in bug 3858.

      If all the input values are SQL NULL, return SQL NULL. Otherwise, return the maximum value of the non-NULL inputs.

      Parameters:
      v1 - 1st value
      v2 - 2nd value
      v3 - 3rd value
      v4 - 4th value
      judgeTypeFormatId - type format id of the judge
      judgeUserJDBCTypeId - JDBC type id if judge is user type; -1 if not user type
      Returns:
      The maximum value of the 4.
      Throws:
      StandardException