SqlStreamInput/Output use TransportVersion from a read-in Version constant. We need to remove the useage of `transportVersion` field
x-pack/plugin/sql/src/test/java/org/elasticsearch/xpack/sql/common/io/SqlStreamTests.java
String result = out.streamAsString();
        assertThat(result.length(), lessThan(1000));
    }
    public void testOldCursorProducesVersionMismatchError() {
        SqlIllegalArgumentException ex = expectThrows(
            SqlIllegalArgumentException.class,
            () -> SqlStreamInput.fromString(
                
                "97S0AwFaAWMBCHRlc3RfZW1whgEBAQljb21wb3NpdGUHZ3JvdXBieQEDbWF4CDJkMTBjNGJhAAD/AQls"
                    + "YW5ndWFnZXMAAAD/AAD/AQAIYmRlZjg4ZTUBBmdlbmRlcgAAAQAAAQEKAQhiZGVmODhlNf8AAgEAAAAA"
                    + "AP////8PAAAAAAAAAAAAAAAAAVoDAAICAAAAAAAAAAAKAP////8PAgFtCDJkMTBjNGJhBXZhbHVlAAEE"
                    + "QllURQFrCGJkZWY4OGU1AAABAwA=",
                new NamedWriteableRegistry(List.of()),
                Version.CURRENT
            )
        );
        assertThat(ex.getMessage(), containsString("Unsupported cursor version [7.15.1], expected [" + Version.CURRENT + "]"));
    }
    public void testVersionCanBeReadByOldNodes() throws IOException {
        Version version = randomFrom(Version.V_7_0_0, Version.V_7_2_1, Version.V_8_1_0);
        SqlStreamOutput out = SqlStreamOutput.create(version, randomZone());
        out.writeString("payload");
        out.close();
        String encoded = out.streamAsString();
        byte[] bytes = Base64.getDecoder().decode(encoded);
        InputStreamStreamInput in = new InputStreamStreamInput(new ByteArrayInputStream(bytes));
        assertEquals(version, Version.readVersion(in));
    }
}