Hi,
I'm trying to build a query based on an existing (parsed) SQL query. I'm
parsing this query:
select
case room_name
when 'Meeting room for Aeronautics' then 'is_aero'
else 'not_aero'
end room_category
from meeting_rooms
The RexNode, after SqlToRelConverter has the "is_aero" string literal
wrapped in a cast to a fixed-length type: CAST('is_aero'):CHAR(8)
This *seems* incorrect as when compared to another value, it will be padded
out to 'is_aero ' and a comparison with the literal 'is_aero' will fail. Is
there a way to get this to behave more like VARCHAR earlier in the
pipeline, possibly in the parser or SqlToRelConverter?
Thanks
Jess