@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.sep(""); } }
@Override public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { List<SqlNode> opList = call.getOperandList(); assert (opList.size() >= 1); SqlNode sqlNode = opList.get(0); sqlNode.unparse(writer, leftPrec, getLeftPrec()); writer.sep("IN"); Frame frame = writer.startList(FrameTypeEnum.SETOP, "(", ")"); for (SqlNode op : opList.subList(1, opList.size())) { writer.sep(","); op.unparse(writer, 0, 0); } writer.endList(frame); } }
void commaList(SqlWriter writer) { // The precedence of the comma operator if low but not zero. For // instance, this ensures parentheses in // select x, (select * from foo order by z), y from t for (SqlNode node : list) { writer.sep(","); node.unparse(writer, 2, 3); } }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.sep(kind == SqlKind.NEXT_VALUE ? "NEXT VALUE FOR" : "CURRENT VALUE FOR"); call.getOperandList().get(0).unparse(writer, 0, 0); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.sep(kind == SqlKind.NEXT_VALUE ? "NEXT VALUE FOR" : "CURRENT VALUE FOR"); call.getOperandList().get(0).unparse(writer, 0, 0); }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.keyword("SHOW"); writer.keyword("DATASOURCE"); if (likePattern != null) { writer.sep("LIKE"); likePattern.unparse(writer, leftPrec, rightPrec); } }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall("TRANSLATE"); for (SqlNode sqlNode : call.getOperandList()) { writer.sep(","); sqlNode.unparse(writer, leftPrec, rightPrec); } writer.endFunCall(frame); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.SIMPLE); arg(writer, call, leftPrec, rightPrec, 0); writer.sep(getName()); arg(writer, call, leftPrec, rightPrec, 1); writer.endList(frame); }
private void unparseSqlIntervalLiteralMssql( SqlWriter writer, SqlIntervalLiteral literal, int sign) { SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); writer.sep(",", true); if (interval.getSign() * sign == -1) { writer.print("-"); } writer.literal(literal.getValue().toString()); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.SIMPLE); arg(writer, call, leftPrec, rightPrec, 0); writer.sep(getName()); arg(writer, call, leftPrec, rightPrec, 1); writer.endList(frame); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.IDENTIFIER); call.operand(0).unparse(writer, leftPrec, 0); writer.sep("."); call.operand(1).unparse(writer, 0, 0); writer.endList(frame); }
public void unparseSqlDatetimeArithmetic(SqlWriter writer, SqlCall call, SqlKind sqlKind, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList("(", ")"); call.operand(0).unparse(writer, leftPrec, rightPrec); writer.sep((SqlKind.PLUS == sqlKind) ? "+" : "-"); call.operand(1).unparse(writer, leftPrec, rightPrec); writer.endList(frame); //Only two parameters are present normally //Checking parameter count to prevent errors if (call.getOperandList().size() > 2) { call.operand(2).unparse(writer, leftPrec, rightPrec); } }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); call.operand(0).unparse(writer, leftPrec, rightPrec); writer.sep("USING"); call.operand(1).unparse(writer, leftPrec, rightPrec); writer.endFunCall(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); call.operand(0).unparse(writer, 0, 0); writer.sep("FROM"); call.operand(1).unparse(writer, 0, 0); writer.endFunCall(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); call.operand(0).unparse(writer, 0, 0); writer.sep("FROM"); call.operand(1).unparse(writer, 0, 0); writer.endFunCall(frame); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); if (call.operandCount() == 2) { call.operand(0).unparse(writer, 0, 100); writer.sep("TO"); call.operand(1).unparse(writer, 100, 0); } else { call.operand(0).unparse(writer, 0, 0); } writer.endFunCall(frame); }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.startList(SqlWriter.FrameTypeEnum.SELECT); writer.sep(isUpsert() ? "UPSERT INTO" : "INSERT INTO"); final int opLeft = getOperator().getLeftPrec(); final int opRight = getOperator().getRightPrec(); targetTable.unparse(writer, opLeft, opRight); if (columnList != null) { columnList.unparse(writer, opLeft, opRight); } writer.newlineAndIndent(); source.unparse(writer, 0, 0); }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.startList(SqlWriter.FrameTypeEnum.SELECT); writer.sep(isUpsert() ? "UPSERT INTO" : "INSERT INTO"); final int opLeft = getOperator().getLeftPrec(); final int opRight = getOperator().getRightPrec(); targetTable.unparse(writer, opLeft, opRight); if (columnList != null) { columnList.unparse(writer, opLeft, opRight); } writer.newlineAndIndent(); source.unparse(writer, 0, 0); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); if (call.operandCount() == 2) { call.operand(0).unparse(writer, 0, 100); writer.sep("TO"); call.operand(1).unparse(writer, 100, 0); } else { call.operand(0).unparse(writer, 0, 0); } writer.endFunCall(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startFunCall(getName()); assert call.operand(0) instanceof SqlLiteral : call.operand(0); call.operand(0).unparse(writer, leftPrec, rightPrec); call.operand(1).unparse(writer, leftPrec, rightPrec); writer.sep("FROM"); call.operand(2).unparse(writer, leftPrec, rightPrec); writer.endFunCall(frame); }