Invalid input for query argument (value out of int32 range)

[stefanitsky]

• asyncpg version: 0.24.0
• PostgreSQL version: 12.8
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: no
• Python version: 3.8
• Platform: OS X
• Do you use pgbouncer?: no
• Did you install asyncpg with pip?: yes (poetry)
• If you built asyncpg locally, which version of Cython did you use?: -
• Can the issue be reproduced under both asyncio and
  uvloop?: yes

Hello!

I have a problem with bigint cast.

I'm using sqlalchemy with asyncpg, when i trying to cast value i get this:

sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $1: 880194977773281290 (value out of int32 range)
[SQL: UPDATE plugin_welcomer SET roles=array_remove(plugin_welcomer.roles, CAST(%s AS BIGINT)) WHERE plugin_welcomer.guild_id = %s]

Column:

DataGrip works perfectly:

I don't know what to do, and i don't want to change db types to varchar, but it looks like it will be...

[elprans]

You seem to be missing a bigint cast in the where clause.

[stefanitsky]

No, it's the second argument, error caued by first.

Well, i switched to raw sql and it works even without cast:

INFO:sqlalchemy.engine.Engine:
            UPDATE plugin_welcomer
            SET roles=array_remove(plugin_welcomer.roles, 880206199588371433)
            WHERE plugin_welcomer.guild_id = 873336491304329227;

It looks like this is not an asyncpg issue, sorry for wasting time.