eclipse-vertx / eclipse-vertx/vertx-sql-client
[MSSQL][DB2] Add support for XML data type
- Dominant language
- Java
- Stars
- 912
- Forks
- 212
- Avg merge
- 17h 30m
- Merged PRs (30d)
- 3
Description
[Based on the documentation](https://vertx.io/docs/vertx-mssql-client/java/#_data_types_supported), [the `xml` data type](https://learn.microsoft.com/en-us/sql/relational-databases/xml/xml-data-type-and-columns-sql-server?view=sql-server-ver16) is not supported in MSSQL.
Example of column definition:
```sql
xmlColumn xml
```
It currently throws (during a select sql query):
```
Caused by: java.lang.UnsupportedOperationException: Unable to decode typeInfo for XML
at io.vertx.mssqlclient.impl.codec.DataType.decodeTypeInfo(DataType.java:1065)
at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.handleColumnMetadata(MSSQLCommandCodec.java:120)
at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.decode(MSSQLCommandCodec.java:51)
at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.decodeMessage(TdsMessageDecoder.java:75)
at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.channelRead(TdsMessageDecoder.java:47)
at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
... 20 more
```
I've created this issue for SqlServer but Db2 has the same problem.
Contributor guide
Assessment
This issue has not been assessed yet.