Francesco Capponi

Why nested has a limit of 3?

6

Search for ` "size" : 3,` in the text below. Why this limit? It appears returning only three result top. I tried to look in code but I couldn't find...

Comparing date, timestamp and string lead to failures and Date formatted as timestamp

16

Version 1.13 (might be a regression from previous versions) The following query: ``` POST my_test_index_date/_doc/ { "field1": { "subFieldA": "2020-02-02" } } ``` generates the following mapping specifying the field...

Adding additional logging to ExprMissingValue exception

2

*Issue #, if available:* In a simple GROUP BY queries I'm getting the following exception and need more info about the problem: ``` { "error": { "reason": "There was internal...

*Issue #, if available:* *Description of changes:* By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.

*Issue #, if available:* *Description of changes:* By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.

Adding support for much more permissive date parsing for ExprTimestampValue creation (support of T or not T, autofill missing part with 0s) *Issue #, if available:* 1) after you add...

Adding simple In support

1

This works for `field IN (list...)` The support to subqueries in the IN clause is yet to come.

Year(MyDateField) <= YEAR(NOW()) not supported

4

Is there any way to get the current year? ``` YEAR(NOW()) ``` seems currently not supported ``` { "error": { "reason": "There was internal problem at backend", "details": "Nested function...

WHERE boolField = 'true', doesn't autocast (changed behavior)

6

Version 1.13 In the previous version, this type of autocasting was supported ``` POST my_test_ndex_bool/_doc/ { "field1": { "subFieldA": true, "subFieldB": 2 } } POST _opendistro/_sql { "query": """SELECT *...

Using IN ('some string') in combination to GROUP BY fails

1

Version 1.13 Given a doc ``` POST my_test_ndex2/_doc/ { "field1": { "subFieldA": 1, "subFieldB": 2 }, "field3": { "subFieldA": "test" } } ``` This query using GROUP BY and IN...