uuid returned as an array of numbers for MS SQL

grafana / xk6-sql

k6 extension to load test RDBMSs (PostgreSQL, MySQL, MS SQL and SQLite3)

Apache License 2.0

107 stars 57 forks source link

uuid returned as an array of numbers for MS SQL #60

Closed adumitreseibogdan closed 5 months ago

adumitreseibogdan commented 5 months ago

Hi,

I'm connecting to a MS SQL database, when I query a table, the columns that have an uuid stored are returned as an array of numbers, for example for:

“Id”:“31834ec8-d1b5-48ee-8f2d-36072101aa74” is returned as: “Id”:[200,78,131,49,181,209,238,72,143,45,54,7,33,1,170,116]

adumitreseibogdan commented 5 months ago

gonna close this issue as it seems to be the normal behavior, the array of numbers represents ASCII codes, that need to be converted back to UUID format

vipul-mykaarma commented 4 months ago

@adumitreseibogdan any ways to achieve the same, facing the same issue