Memory table does not construct query correctly when filtering

[thomheymann]

There is an issue with the way search bar queries are constructed when filtering in EuiMemoryTable component causing bugs when e.g. usernames or tags contain special characters: elastic/kibana#143079

To fix this values that contain special characters should be wrapped in quotation marks, e.g.:

• username:user@domain should be username:"user@domain" instead
• tag:(tag1 or tag2@tag2) should be tag:(tag1 or "tag2@tag2") instead

[cee-chen]

@thomheymann can you clarify the urgency level of this bug? Is it something that needs to get in before 8.6FF?

[thomheymann]

@thomheymann can you clarify the urgency level of this bug? Is it something that needs to get in before 8.6FF?

@constancecchen Would be great to have obviously but if there's more urgent issues 8.7 would be ok too I think.

[cee-chen]

FYI @chandlerprall

[chandlerprall]

As long as the fix doesn't touch the query syntax parsing (doesn't sound like it will), if we can get a fix merged by EOD Thursday then a quick backport for 8.6 makes sense to me (I can run that & the Kibana update).

[cee-chen]

touch the query syntax parsing (doesn't sound like it will)

I think it does (or at least that would be my preferred fix, personally, and to expand this fix to all special characters that don't have EQL meaning (e.g. not throwing on ~!@#$%^&; etc). Am I off on that?

PR for review: #6356

We're also getting real close to FF so I'm not totally sure we should try and squeeze this in, unless someone else wants to pick this up.