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

Reply via email to