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...
https://github.com/elastic/elasticsearch/pull/41531    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"      },    &...
https://github.com/elastic/elasticsearch/issues/53445    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) )...
https://github.com/elastic/elasticsearch/issues/49672    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....
https://github.com/elastic/elasticsearch/issues/49391    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...
https://github.com/elastic/elasticsearch/issues/46396    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...
https://github.com/elastic/elasticsearch/issues/45251    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 ...
https://github.com/elastic/elasticsearch/issues/43766    Author: astefan , 2020-03-30, 15:16
SQL: selecting a sub-field and all subfields generates error - ElasticSearch - [issue]
...Issue reproduced on demo.elastic.co:POST _sql?pretty&format=txt{  "query":"select Carrier.keyword, Carrier.* from flights"}Gives:{  "error": {    "root_cause": [  &n...
https://github.com/elastic/elasticsearch/issues/43163    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...
https://github.com/elastic/elasticsearch/issues/35472    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...
https://github.com/elastic/elasticsearch/issues/35200    Author: astefan , 2020-03-30, 15:13