@pnowojski Hi, thanks for your review.
Yes, support VARCHAR(N) can solve the problem. As a workaround, we can cast the
literals to varchar to solve the problem, like: `case 1 when 1 then cast('a' as
varchar) when 2 then cast('bcd' as varchar) end`.
The behavior in strict SQL standard mode(SQL:2003) returns a CHAR(N) type with
blank-padded.
However, I test Oracle/SqlServer/Mysql and they all return the value without
blank-padded. Also, it seems that there is no way to turn blank-padded on.
This change will break implementations in Flink. Do you think we should make it
configurable?
Thanks, Hequn
[ Full content available at: https://github.com/apache/flink/pull/6519 ]
This message was relayed via gitbox.apache.org for [email protected]
