[BUG] Query with nested field type does not fall back to legacy #1277
Description
What is the bug?
SELECT message.info FROM nested_simple; is being run on the new engine instead of Legacy. It is not supported by the new engine yet and should fall back to Legacy.
How can one reproduce the bug?
Steps to reproduce the behavior:
- Checkout upstream opensearch-sql branch 2.x
- Install the plugin to your local server
- Run opensearch
- Run the query
SELECT message.info FROM nested_simple; - See results as
NULLand the Logs shows that it is being run on the new engine
What is the expected behavior?
Since this is not supported in the new engine, it should fall back to Legacy
What is your host/environment?
opensearch-sql 2.4.0
Do you have any screenshots?
[2023-01-12T11:01:49,953][ERROR][o.o.s.l.p.RestSQLQueryAction] [Unused26-MacBook.local] [c7c6efae-d236-4093-9516-37c94896ceb3] Request is handled by new SQL query engine
Test data mappings
"mappings": {
"properties": {
"message": {
"type": "nested",
"properties": {
"info": {
"type": "keyword",
"index": "true"
},
"author": {
"type": "keyword",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
},
"index": "true"
},
"dayOfWeek": {
"type": "long"
}
}
},
"comment": {
"type": "nested",
"properties": {
"data": {
"type": "keyword",
"index": "true"
},
"likes": {
"type": "long"
}
}
},
"myNum": {
"type": "long"
},
"someField": {
"type": "keyword",
"index": "true"
}
}
}
}