SQL: a query over a geo_shape field with ignore_malformed as true fails for the faulty data

[astefan]

Given the mapping

    	"geo_shape_field": {
    		"type":"geo_shape",
		    "ignore_malformed": true
    	}

and test data as

{"index":{}}
{"geo_shape_field":"POINT (-71.34 41.12)"}
{"index":{}}
{"geo_shape_field":"foo"}

an SQL query like SELECT geo_shape_field FROM test will return the following result

{
    "error": {
        "root_cause": [
            {
                "type": "illegal_argument_exception",
                "reason": "Unknown geometry type: foo"
            }
        ],
        "type": "illegal_argument_exception",
        "reason": "Unknown geometry type: foo"
    },
    "status": 400
}

[elasticmachine]

Pinging @elastic/es-ql (Team:QL)

[astefan]

Fixed by #66622.