[FLINK-22448] FlinkRexUtil create Sarg String array elemet supplement space

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: Junning Liang
• Created: 25/Apr/21 08:08
• Updated: 12/May/21 02:46
• Resolved: 12/May/21 02:46

Description

As we know, the new version of Calcite introduces the SEARCH rex call to express range conditions. But when i used string array to express range in the StreamSQL, i found that some string in the array had problems with the completion length by using space.

the following query:

 

create view tempView as
  select * from sourceTable where action in ('systemnotifyv2', 'session_auth', 'create_session', 'close_single_chat')

after Sarg operator created, the result is :

 

 

create view tempView as
 select * from sourceTable where action in ('systemnotifyv2', 'session_auth  ', 'create_session', 'close_single_chat')

I debuged to see why dose the happans. After calling  rexBuilder.makeLiteral in

FlinkRexUtil#expandSearchOperands, the string 'session_auth' became 'session_auth  '.And i also found that the type and length of the string array were determined by the first string in the array.Just like my example above, the type of the array was Char and the length of the array was 14.the length of 'session_auth' string was 12 so that calcite would supplement  2 space to make it meet the length of 14.

Now, i All I can think of is adding trim parameter to remove the space。do you have a better way to fix or avoid the problem happens?

 

Issue Links

• is duplicated by: FLINK-22486 Wrong results of the IN operator