[CALCITE-4346] strange result in toString function with bigdecimal type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.27.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Zhixiong Chen
• Created: 20/Oct/20 02:58
• Updated: 18/Jun/21 08:43
• Resolved: 24/Oct/20 00:12

Description

In  SqlFunctions the toString function with BigDecimal type will replace 0.1 with .1 .

But why is this ?

public static String toString(BigDecimal x) {
 final String s = x.toString();
 if (s.equals("0")) {
 return s;
 } else if (s.startsWith("0.")) {
 // we want ".1" not "0.1"
 return s.substring(1);
 } else if (s.startsWith("-0.")) {
 // we want "-.1" not "-0.1"
 return "-" + s.substring(2);
 } else {

Issue Links

• duplicates: CALCITE-2980 Implement the FORMAT clause of the CAST operator