When I use 'await session.commit()', the field content of my instance has become an error

[HaleTime]

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

import uuid
from sqlalchemy.ext.asyncio import AsyncSession
from app.core.db import async_engine
from sqlmodel import SQLModel, Field


class Test(SQLModel, table=True):
    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
    name: str = Field(max_length=255)


async def main():
    async with async_engine.begin() as conn:
        await conn.run_sync(SQLModel.metadata.create_all)

    async with AsyncSession(async_engine) as session:
        test = Test(name='test')
        session.add(test)
        await session.commit()
        await session.refresh(test)
        return test


if __name__ == '__main__':
    import asyncio

    asyncio.run(main())

Description

When I use 'await session.commit()', the field content of my instance has become an error, like
(sqlalchemy.exc.MissingGreenlet) greenlet_spawn has not been called; can't call await_only() here. Was IO attempted in an unexpected place?
[SQL: SELECT test.id AS test_id, test.name AS test_name
FROM test
WHERE test.id = %s]
[parameters: [{'pk_1': UUID('84f97a3a-107b-4ae6-81bb-f04295cf0d3f')}]]

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.10

Additional Context

No response

[monchin]

This is a sqlalchemy issue. Try this