SQL: wrong number of values for columns

[bpintea]

The queries that contain a duplicate column will only return once the value in a row.
Example:
select emp_no, first_name, emp_no from employees will return:

{"columns":[{"name":"emp_no","type":"text","display_size":2147483647},{"name":"first_name","type":"text","display_size":2147483647},{"name":"emp_no","type":"text","display_size":2147483647}],"rows":[["10001","Georgi"]]}

[elasticmachine]

Pinging @elastic/es-search

[astefan]

Just for the record, this issue manifests itself in a nastier way in case format=txt (as in /_sql?format=txt):

{
    "error": {
        "root_cause": [
            {
                "type": "index_out_of_bounds_exception",
                "reason": "Index 1 out of bounds for length 1"
            }
        ],
        "type": "index_out_of_bounds_exception",
        "reason": "Index 1 out of bounds for length 1"
    },
    "status": 500
}

@emasab thank you for providing the PR and apologies for the delay on looking at it. We plan on having a look and validate shortly.

[emasab]

@astefan you're welcome, I'm pleased to contribute

[matriv]

master : 097ea36
7.x : 87156ad
7.4 : 79f1e53
7.3 : a63524b
6.8 : b3c4854