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("""
                "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, newNodes);
    }
    @SuppressWarnings("unchecked")
    private Map<String, Object> prepareTestData(
        Consumer<List<Map<String, Object>>> additionalColumns,
        BiConsumer<StringBuilder, Map<String, Object>> additionalValues
    ) throws IOException {
        Map<String, Object> expectedResponse = new HashMap<>();
        List<Map<String, Object>> columns = new ArrayList<>();
        columns.add(columnInfo("interval_year", "interval_year"));
        columns.add(columnInfo("interval_minute", "interval_minute"));
        columns.add(columnInfo("long_field", "long"));
        columns.add(columnInfo("integer_field", "integer"));