SqlStreamInput/Output use TransportVersion from a read-in Version constant. We need to remove the useage of `transportVersion` field
x-pack/plugin/sql/qa/mixed-node/src/javaRestTest/java/org/elasticsearch/xpack/sql/qa/mixed_node/SqlSearchIT.java
builder.append(",");
            builder.append("""
                "geo_point_field":{"lat":"37.386483", "lon":"-122.083843"},""");
            fieldValues.put("geo_point_field", "POINT (-122.083843 37.386483)");
            builder.append("\"float_field\":" + randomFloat + ",");
            /*
             * Double.valueOf(float.toString) gets a `double` representing
             * the `float` that we'd get by going through json which is
             * base 10. just casting the `float` to a `double` will get
             * a lower number with a lot more trailing digits because
             * the cast adds *binary* 0s to the end. And those binary
             * 0s don't translate the same as json's decimal 0s.
             */
            fieldValues.put("float_field", Double.valueOf(Float.valueOf(randomFloat).toString()));
            float roundedHalfFloat = HalfFloatPoint.sortableShortToHalfFloat(HalfFloatPoint.halfFloatToSortableShort(randomFloat));
            builder.append("\"half_float_field\":\"" + randomFloat + "\"");
            fieldValues.put("half_float_field", Double.valueOf(Float.toString(roundedHalfFloat)));
        });
        assertAllTypesWithNodes(expectedResponse, bwcNodes);
    }
    public void testAllTypesWithRequestToUpgradedNodes() throws Exception {
        Map<String, Object> expectedResponse = prepareTestData(columns -> {
            columns.add(columnInfo("geo_point_field", "geo_point"));
            columns.add(columnInfo("float_field", "float"));
            columns.add(columnInfo("half_float_field", "half_float"));
        }, (builder, fieldValues) -> {
            Float randomFloat = randomFloat();
            builder.append(",");