How to use

getSQL

method

in

org.h2.expression.ExpressionColumn

@Override
public void updateAggregate(Session session) {
  Value now = columnResolver.getValue(column);
  Select select = columnResolver.getSelect();
  if (select == null) {
    throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  HashMap<Expression, Object> values = select.getCurrentGroup();
  if (values == null) {
    // this is a different level (the enclosing query)
    return;
  }
  Value v = (Value) values.get(this);
  if (v == null) {
    values.put(this, now);
  } else {
    if (!database.areEqual(now, v)) {
      throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
    }
  }
}

@Override
public Value getValue(Session session) {
  Select select = columnResolver.getSelect();
  if (select != null) {
    HashMap<Expression, Object> values = select.getCurrentGroup();
    if (values != null) {
      Value v = (Value) values.get(this);
      if (v != null) {
        return v;
      }
    }
  }
  Value value = columnResolver.getValue(column);
  if (value == null) {
    if (select == null) {
      throw DbException.get(ErrorCode.NULL_NOT_ALLOWED, getSQL());
    } else {
      throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
    }
  }
  if (column.getEnumerators() != null && value != ValueNull.INSTANCE) {
    return ValueEnum.get(column.getEnumerators(), value.getInt());
  }
  return value;
}

if (ec2 instanceof ExpressionColumn) {
  ExpressionColumn c2 = (ExpressionColumn) ec2;
  String ta = exprCol.getSQL();
  String tb = c2.getSQL();
  String s2 = c2.getColumnName();
  found = db.equalsIdentifiers(col, s2);

@Override
public void updateAggregate(Session session) {
  Value now = columnResolver.getValue(column);
  Select select = columnResolver.getSelect();
  if (select == null) {
    throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  HashMap<Expression, Object> values = select.getCurrentGroup();
  if (values == null) {
    // this is a different level (the enclosing query)
    return;
  }
  Value v = (Value) values.get(this);
  if (v == null) {
    values.put(this, now);
  } else {
    if (!database.areEqual(now, v)) {
      throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
    }
  }
}

public void updateAggregate(Session session) throws SQLException {
  Value now = resolver.getValue(column);
  Select select = resolver.getSelect();
  if (select == null) {
    throw Message.getSQLException(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  HashMap values = select.getCurrentGroup();
  if (values == null) {
    // this is a different level (the enclosing query)
    return;
  }
  Value v = (Value) values.get(this);
  if (v == null) {
    values.put(this, now);
  } else {
    if (!database.areEqual(now, v)) {
      throw Message.getSQLException(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
    }
  }
}

@Override
public void updateAggregate(Session session) {
  Value now = columnResolver.getValue(column);
  Select select = columnResolver.getSelect();
  if (select == null) {
    throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  HashMap<Expression, Object> values = select.getCurrentGroup();
  if (values == null) {
    // this is a different level (the enclosing query)
    return;
  }
  Value v = (Value) values.get(this);
  if (v == null) {
    values.put(this, now);
  } else {
    if (!database.areEqual(now, v)) {
      throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
    }
  }
}

public Value getValue(Session session) throws SQLException {
  // TODO refactor: simplify check if really part of an aggregated value /
  // detection of
  // usage of non-grouped by columns without aggregate function
  Select select = resolver.getSelect();
  if (select != null) {
    HashMap values = select.getCurrentGroup();
    if (values != null) {
      Value v = (Value) values.get(this);
      if (v != null) {
        return v;
      }
    }
  }
  Value value = resolver.getValue(column);
  if (value == null) {
    throw Message.getSQLException(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  return value;
}

@Override
public Value getValue(Session session) {
  Select select = columnResolver.getSelect();
  if (select != null) {
    HashMap<Expression, Object> values = select.getCurrentGroup();
    if (values != null) {
      Value v = (Value) values.get(this);
      if (v != null) {
        return v;
      }
    }
  }
  Value value = columnResolver.getValue(column);
  if (value == null) {
    columnResolver.getValue(column);
    throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  return value;
}

@Override
public Value getValue(Session session) {
  Select select = columnResolver.getSelect();
  if (select != null) {
    HashMap<Expression, Object> values = select.getCurrentGroup();
    if (values != null) {
      Value v = (Value) values.get(this);
      if (v != null) {
        return v;
      }
    }
  }
  Value value = columnResolver.getValue(column);
  if (value == null) {
    columnResolver.getValue(column);
    throw DbException.get(ErrorCode.MUST_GROUP_BY_COLUMN_1, getSQL());
  }
  return value;
}

if (ec2 instanceof ExpressionColumn) {
  ExpressionColumn c2 = (ExpressionColumn) ec2;
  String ta = exprCol.getSQL(); // exprCol.getTableAlias();
  String tb = c2.getSQL(); // getTableAlias();
  found = col.equals(c2.getColumnName());
  if (ta == null || tb == null) {

if (ec2 instanceof ExpressionColumn) {
  ExpressionColumn c2 = (ExpressionColumn) ec2;
  String ta = exprCol.getSQL();
  String tb = c2.getSQL();
  String s2 = c2.getColumnName();
  found = db.equalsIdentifiers(col, s2);

if (ec2 instanceof ExpressionColumn) {
  ExpressionColumn c2 = (ExpressionColumn) ec2;
  String ta = exprCol.getSQL();
  String tb = c2.getSQL();
  String s2 = c2.getColumnName();
  found = db.equalsIdentifiers(col, s2);