ERROR: Conversion failed when converting from a character string to uniqueidentifier.

[urosjarc]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

# I have table with primary key as UUID...

class Table(SQLModel, table=True):
        __tablename__ = "optimization_postman"
        
        id: uuid.UUID = Field(primary_key=True)
        optimization_id: uuid.UUID = Field(foreign_key="optimization.id")
        delivery_time: float
        vehicle_types: str
        quantity: int


# In database I allready have few records...
# And when I want to search one record with specific ID...

with Session(db) as conn:
	query = select(Table).where(Table.id == uuid.uuid4())
	row = conn.exec(query).one_or_none()

I get error...

sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting from a character string to uniqueidentifier. (8169) (SQLExecDirectW)')
[SQL: SELECT optimization_postman.id, optimization_postman.optimization_id, optimization_postman.delivery_time, optimization_postman.vehicle_types, optimization_postman.quantity 
FROM optimization_postman 
WHERE optimization_postman.id = ?]
[parameters: ('5b18ff56545d4d62bccb66391954b13a',)]
(Background on this error at: https://sqlalche.me/e/20/f405)

It looks like that sqlmodel serialize UUID to wrong uniqueidentifier... 5b18ff56545d4d62bccb66391954b13a

Description

I can't select records by specific UUID value because UUID serialization is wrong.

Operating System

Linux

Operating System Details

linux ubuntu, database: mssql 2017

docker-compose.yaml

version: "3.2"
services:
  db-posta-poi:
    container_name: mssql
    image: mcr.microsoft.com/mssql/server:2017-latest
    restart: always
    environment:
      ACCEPT_EULA: Y
      MSSQL_SA_PASSWORD: password
    ports:
      - 1433:1433

SQLModel Version

0.0.19

Python Version

3.11

Additional Context

[urosjarc]

I have found duplicated discusion: #878