select statement returns incorrect result for array fields #235

asfoorial · 2021-10-17T11:50:07Z

PUT someindex/_doc/doc1
{
"name":"person1",
"roles":["engineer","consultant"]
}

The below returns both engineer and consultant while it is supposed to return only "engineer”.

select distinct roles from someindex where roles like 'eng%'

This bug is also linked to this post https://discuss.opendistrocommunity.dev/t/apply-match-like-query-on-the-result-of-aggregations/7267/5

* Updated Arithmetic functions from old engine to new engine (#235) * Updated ADD, SUBTRACT, MULTIPLY, DIVIDE, MODULUS to V2 engine Signed-off-by: Matthew Wells <[email protected]>

* Updated Arithmetic functions from old engine to new engine (#235) * Updated ADD, SUBTRACT, MULTIPLY, DIVIDE, MODULUS to V2 engine Signed-off-by: Matthew Wells <[email protected]> (cherry picked from commit bc39346)

* Updated Arithmetic functions from old engine to new engine (#235) * Updated ADD, SUBTRACT, MULTIPLY, DIVIDE, MODULUS to V2 engine Signed-off-by: Matthew Wells <[email protected]> (cherry picked from commit bc39346) Co-authored-by: Matthew Wells <[email protected]>

penghuo mentioned this issue Feb 21, 2022

Better document limitation on Array support. #442

Open

dai-chen added the enhancement New feature or request label Sep 8, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

select statement returns incorrect result for array fields #235

select statement returns incorrect result for array fields #235

asfoorial commented Oct 17, 2021 •

edited

Loading

select statement returns incorrect result for array fields #235

select statement returns incorrect result for array fields #235

Comments

asfoorial commented Oct 17, 2021 • edited Loading

asfoorial commented Oct 17, 2021 •

edited

Loading