Beispiel #1
0
    /** Uses multiple EQUAL expressions */
    private void getFirstRowMulti() {

      boolean convertible = true;
      Object[] currentJoinData = new Object[rangeVar.rangeIndex.getVisibleColumns()];

      for (int i = 0; i < rangeVar.multiColumnCount; i++) {
        Type valueType = rangeVar.findFirstExpressions[i].getRightNode().getDataType();
        Type targetType = rangeVar.findFirstExpressions[i].getLeftNode().getDataType();
        Object value = rangeVar.findFirstExpressions[i].getRightNode().getValue(session);

        if (targetType.compareToTypeRange(value) != 0) {
          convertible = false;

          break;
        }

        currentJoinData[i] = targetType.convertToType(session, value, valueType);
      }

      it =
          convertible
              ? rangeVar.rangeIndex.findFirstRow(
                  session, store, currentJoinData, rangeVar.multiColumnCount)
              : rangeVar.rangeIndex.emptyIterator();
    }
Beispiel #2
0
    private void getFirstRow() {

      Object value = rangeVar.indexCondition.getRightNode().getValue(session);
      Type valueType = rangeVar.indexCondition.getRightNode().getDataType();
      Type targetType = rangeVar.indexCondition.getLeftNode().getDataType();
      int exprType = rangeVar.indexCondition.getType();
      int range = 0;

      if (targetType != valueType) {
        range = targetType.compareToTypeRange(value);
      }

      if (range == 0) {
        value = targetType.convertToType(session, value, valueType);
        it = rangeVar.rangeIndex.findFirstRow(session, store, value, exprType);
      } else if (range < 0) {
        switch (exprType) {
          case OpTypes.GREATER_EQUAL:
          case OpTypes.GREATER:
            it = rangeVar.rangeIndex.findFirstRowNotNull(session, store);
            break;

          default:
            it = rangeVar.rangeIndex.emptyIterator();
        }
      } else {
        switch (exprType) {
          case OpTypes.SMALLER_EQUAL:
          case OpTypes.SMALLER:
            it = rangeVar.rangeIndex.findFirstRowNotNull(session, store);
            break;

          default:
            it = rangeVar.rangeIndex.emptyIterator();
        }
      }

      return;
    }
  protected void writeDaySecondInterval(IntervalSecondData o, Type type) {

    write('\'');
    writeBytes(type.convertToString(o));
    write('\'');
  }
  protected void writeYearMonthInterval(IntervalMonthData o, Type type) {

    write('\'');
    writeBytes(type.convertToString(o));
    write('\'');
  }
  protected void writeTimestamp(TimestampData o, Type type) {

    write('\'');
    writeBytes(type.convertToString(o));
    write('\'');
  }
 protected void writeDecimal(BigDecimal o, Type type) {
   writeBytes(type.convertToSQLString(o));
 }