a very terribale bug

[MrYZhou]

First Check

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

Commit to Help

• [X] I commit to help with one of those options 👆

Example Code

@router.get("/list",status_code=200)
async def index():
    with Session(engine) as session:
        list = session.exec(select(Config).offset(0).limit(100)).all()
        return list

Description

it can not response a result, a very strange phenomenon. At the command line, the request url has been regnized by fastapi,but can not into breakline. without any error info.

finaly,i change the request method with post,it work. it is so unreasonable. It is worth mentioning that the way can work normally in other router file.

Operating System

Windows

Operating System Details

No response

SQLModel Version

latest

Python Version

3.10.5

Additional Context

Consider that bugs are hard to reproduce,this is my demo url.

about demo path: router/generate.py @router.get("/list",status_code=200) async def index(): with Session(engine) as session: list = session.exec(select(Config).offset(0).limit(100)).all() return list

[https://github.com/MrYZhou/fastapi-le.git](demo url)

[meirdev]

This is because:

@router.get("/{id}", tags=["web", "app"])
async def index(id):
    pass

move it under /list:

@router.get("/list",status_code=200)
async def index():
    ...

@router.get("/{id}", tags=["web", "app"])
async def index(id):
    ...

The pattern "/{id}" catch "/list"

[MrYZhou]

thanks very much , list was regnized as a id value

[MrYZhou]

This is because:

@router.get("/{id}", tags=["web", "app"])
async def index(id):
    pass

move it under /list:

@router.get("/list",status_code=200)
async def index():
    ...

@router.get("/{id}", tags=["web", "app"])
async def index(id):
    ...

The pattern "/{id}" catch "/list"

thanks very much,