[CALCITE-4389] Calls to ROW and anonymous row operators sometimes print too many spaces

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 09/Nov/20 06:23
• Updated: 03/Jun/21 22:32
• Resolved: 13/Nov/20 05:59

Description

Calls to ROW and anonymous row operators sometimes print too many spaces. For example, "VALUES (1, TRUE)" is converted to SQL as

VALUES  (1, TRUE)

(Note two spaces after "VALUES".)

The cause is that the argument to VALUES is initially represented as a call to the ROW operator, "ROW (1, TRUE)", and later converted to a call to the anonymous row operator. The anonymous row operator, whose name is " " (one space), does not to be preceded by white space, but the one white space " " has already been printed.