clear query| facets| time Search criteria: .   Results from 21 to 30 from 647 (0.0s).
Loading phrases to help you
refine your search...
SQL: Allow locally executed queries with count(*) - ElasticSearch - [issue]
...This PR adds functionality that allows locally executed queries with COUNT(*). For example select 1 having count(*) > 0; In these scenarios count(*) should always return a size of 1.Fixes...    Author: astefan , 2020-03-30, 15:31
SQL: SYS COLUMNS returns incorrect data for a field with the same name in multiple indices - ElasticSearch - [issue]
...Consider index test1:{  "mappings": {    "properties": {      "cycle_type": {        "type": "keyword"      },    &...    Author: astefan , 2020-03-30, 15:17
SQL: division by zero when grouping by - ElasticSearch - [issue]
...Similar to #49388, but this time on the aggregation side, where the Painless script already evaluates the value:SELECT CASE WHEN languages - 1 = 0 THEN NULL ELSE ( salary / (languages - 1) )...    Author: astefan , 2020-03-30, 15:17
SQL: the result of ROUND of an INTEGER is a floating point number - ElasticSearch - [issue]
...SELECT ROUND(salary,0) FROM test_emp returns .0 values even if salary is not a floating point field....    Author: astefan , 2020-03-30, 15:16
SQL: NPE when using the same alias for a projection and an aggregate and GROUPed BY - ElasticSearch - [issue]
...SELECT gender AS g, SUM(salary) AS g FROM test_emp GROUP BY gNotice the alias name (which is the same) which, used in the GROUP BY will trigger a NPE:[elasticsearch] java.lang.NullPointerExc...    Author: astefan , 2020-03-30, 15:16
SQL: SUM of multiple 0 values returns NULL - ElasticSearch - [issue]
...Given:SELECT SUM(val) FROM test WHERE val IS NOT NULL GROUP BY nameall val values are 0 for a certain name valueThe result of the above query will return NULL, whereas the result should be 0...    Author: astefan , 2020-03-30, 15:16
SQL: SqlIllegalArgumentException: Incorrect merging of mappings - ElasticSearch - [issue]
...Test data in a test index:{"index":{"_id":5}}{"test":[]}Using select * from test gives:[elasticsearch] org.elasticsearch.xpack.sql.SqlIllegalArgumentException: Incorrect merging of mappings ...    Author: astefan , 2020-03-30, 15:16
SQL: selecting a sub-field and all subfields generates error - ElasticSearch - [issue]
...Issue reproduced on _sql?pretty&format=txt{  "query":"select Carrier.keyword, Carrier.* from flights"}Gives:{  "error": {    "root_cause": [  &n...    Author: astefan , 2020-03-30, 15:15
SQL: selecting both nested fields and non-nested ones will only retrieve documents with nested fields - ElasticSearch - [issue]
...For an index that has a nested field in it where only some of the documents do actually have values for the nested field, retrieving both the nested fields (where applicable) and the non-nes...    Author: astefan , 2020-03-30, 15:14
SQL: using a normalized field in a GROUP BY throws an unexpected error - ElasticSearch - [issue]
...This is valid for ES 6.4.2.ES 6.5 and 7.x don't have this behavior, but there were changes in the way indices mappings are picked up and combined together as part of #34718.Normalized fields...    Author: astefan , 2020-03-30, 15:13