============ show space 'mspace' entries filter "upper(tvalue)='VALUe5'"
Show Space Entries: ________________________________________________________________________________ Show entries for space 'mspace' Filter: upper(tvalue)='VALUe5' Distribution Scope: all Time Scope: time_scope_current Query Limit: 10000 Prefetch: 1 Browser Size: -1 Space Size: 7 Filtered Space Size: 1 Browser Init Time: 0ms --------------------------------------------------------------------------------
{ tvalue : Value5 tid : 5 tid2 : 30 }
You can use upper(tvalue)=upper('value5') too.
Note that this query will ignore index scan even if you have a proper index created.