Asyncpg: Can't resolve tuple argument types

[LEW21]

• asyncpg version: 0.18.3
• PostgreSQL version: 11.5
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: No, it's on docker
• Python version: 3.7.4
• Platform: Linux
• Do you use pgbouncer?: No
• Did you install asyncpg with pip?: Yes
• If you built asyncpg locally, which version of Cython did you use?: No
• Can the issue be reproduced under both asyncio and
  uvloop?: Didn't try uvloop.

asyncpg is unable to resolve argument types for the following SQL query:

SELECT * FROM lorem WHERE (first_id, second_id) = $1

Complete example - this script fails:

import asyncio
import asyncpg
import os

async def main():
    conn = await asyncpg.connect(os.environ['DATABASE_URL'])
    try:
        await conn.execute(
            """
            create table "lorem" (
                "first_id" int,
                "second_id" int,
                primary key ("first_id", "second_id")
            );
            """
        )
        await conn.execute("insert into lorem values (5, 5)")
    except asyncpg.DuplicateTableError:
        pass

    sql = "SELECT * FROM lorem WHERE (first_id) = $1"
    print(sql)
    print(await conn.fetch(sql, 5)) # Works

    sql = "SELECT * FROM lorem WHERE (first_id, second_id) = $1"
    print(sql)
    print(await conn.fetch(sql, (5, 5))) # Crashes

asyncio.run(main())

with

SELECT * FROM lorem WHERE (first_id) = $1
[<Record first_id=5 second_id=5>]
SELECT * FROM lorem WHERE (first_id, second_id) = $1
Traceback (most recent call last):
  File "nano.py", line 31, in <module>
    asyncio.run(main())
  File "/usr/lib/python3.7/asyncio/runners.py", line 43, in run
    return loop.run_until_complete(main)
  File "/usr/lib/python3.7/asyncio/base_events.py", line 579, in run_until_complete
    return future.result()
  File "nano.py", line 29, in main
    print(await conn.fetch(sql, (5, 5))) # Crashes
  File "/home/lew21/.venv/lib/python3.7/site-packages/asyncpg/connection.py", line 421, in fetch
    return await self._execute(query, args, 0, timeout)
  File "/home/lew21/.venv/lib/python3.7/site-packages/asyncpg/connection.py", line 1414, in _execute
    query, args, limit, timeout, return_status=return_status)
  File "/home/lew21/.venv/lib/python3.7/site-packages/asyncpg/connection.py", line 1422, in __execute
    return await self._do_execute(query, executor, timeout)
  File "/home/lew21/.venv/lib/python3.7/site-packages/asyncpg/connection.py", line 1434, in _do_execute
    stmt = await self._get_statement(query, None)
  File "/home/lew21/.venv/lib/python3.7/site-packages/asyncpg/connection.py", line 356, in _get_statement
    'in {} attempts'.format(tries)
asyncpg.exceptions._base.InternalClientError: could not resolve query result and/or argument types in 6 attempts

[eirnym]

I haven't seen there any support of tuple unpacking. I'd separate parameters to $1 and $2 to avoid such problem

[LEW21]

I haven't seen there any support of tuple unpacking. I'd separate parameters to $1 and $2 to avoid such problem

Unfortunately, I can't do it - I'm using WHERE (first_id, second_id) = any($1) and providing a list of tuples.

[elprans]

This is a PostgreSQL protocol limitation. Anonymous row types (tuples) cannot be described. The error handling in this case could be better, sure.

@LEW21 If you can afford it, I would suggest declaring an explicit composite type:

CREATE TYPE id_pair AS (first_id int, second_id int)

and then

WHERE (first_id, second_id) = any($1::id_pair[])