SQL: SELECT [constant] FROM [index] returns one record only

[astefan]

Assuming an index that has more than one document in it, issuing a query that SELECTs a constant from it will return just one document, whereas it should return [number_of_documents_in_index] records.

Example query: SELECT 1=1 FROM "test_emp".
Result:

---------------
true

Desired result:

---------------
true
true
true
....

[elasticmachine]

Pinging @elastic/es-search-aggs

[nikoncode]

I'll take a look.

reminder: @nikoncode

[nikoncode]

I have found root cause, I will work on fix.

[nikoncode]

Done.

[nikoncode]

My idea - skip optimization, doesn't work after e5d18ad commit.

[nikoncode]

Commit which I mentioned above changed result extracting mechanism. And root cause is moved from optimization itself to oversimplified result collection code. Constant clauses treated as supportedByAggsOnlyQuery and we use wrong collector to get the result. To prove that, you can query constant with any real field - select 1, name from tweets;

Moreover I believe some new errors are introduced.

Also following query doesn't work:

select 1, count(*) from tweets;
select 1, count(*) from tweets group by name;