danny0405 commented on a change in pull request #1740: [CALCITE-3713] Remove column names from Project#digest URL: https://github.com/apache/calcite/pull/1740#discussion_r365116823
########## File path: core/src/main/java/org/apache/calcite/rex/RexCall.java ########## @@ -127,11 +137,83 @@ protected final StringBuilder appendOperands(StringBuilder sb) { includeType = RexDigestIncludeType.NO_TYPE; } } - sb.append(((RexLiteral) operand).computeDigest(includeType)); + operandDigests.add(((RexLiteral) operand).computeDigest(includeType)); + } + int totalLength = (operandDigests.size() - 1) * 2; // commas + for (String s : operandDigests) { + totalLength += s.length(); + } + sb.ensureCapacity(sb.length() + totalLength); + sortOperandsIfNeeded(sb, operands, operandDigests); + for (int i = 0; i < operandDigests.size(); i++) { + String op = operandDigests.get(i); + if (i != 0) { + sb.append(", "); + } + sb.append(op); } return sb; } + private void sortOperandsIfNeeded(StringBuilder sb, + List<RexNode> operands, List<String> operandDigests) { + if (operands.isEmpty() || !needNormalize()) { + return; + } + final SqlKind kind = op.getKind(); + if (SqlKind.SYMMETRICAL_SAME_ARG_TYPE.contains(kind)) { + final RelDataType firstType = operands.get(0).getType(); + for (int i = 1; i < operands.size(); i++) { + if (!equalSansNullability(firstType, operands.get(i).getType())) { + // Arguments have different type, thus they must not be sorted Review comment: I agree for the first iteration, we can keep it as simple as possible. Why do you think `PLUS` for different data types are rare cases, i believe there would be many cases in production ~ ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services