Handling of inet data type

[lelit]

Accordingly to the documentation when an inet value is missing the subnet it is assumed to be a single host.

When I insert such value thru asyncpg however something goes wrong, as the following script shows:

import asyncio
import asyncpg


SETUP_SQL = """\
CREATE TABLE test_inet (
  id serial not null primary key,
  address inet
)
"""

INSERT_SQL_1 = """
INSERT INTO test_inet (address)
VALUES ('192.168.1.100')
"""

INSERT_SQL_2 = """
INSERT INTO test_inet (address)
VALUES ($1)
"""

FETCH_SQL = """
SELECT address
FROM test_inet
ORDER BY id
"""

CLEANUP_SQL = """
DROP TABLE test_inet
"""

async def run():
    conn = await asyncpg.connect(user='theuser', password='thepassword',
                                 database='test', host='127.0.0.1')

    await conn.execute(SETUP_SQL)
    try:
        await conn.execute(INSERT_SQL_1)
        await conn.execute(INSERT_SQL_2, '192.168.1.100')
        result = await conn.fetch(FETCH_SQL)
        print(result)
    finally:
        await conn.execute(CLEANUP_SQL)

    await conn.close()


def main():
    loop = asyncio.get_event_loop()
    loop.run_until_complete(run())


if __name__ == '__main__':
    main()

It emits:

[<Record address=IPv4Network('192.168.1.100/32')>, <Record address=IPv4Address('192.168.1.100')>]

Why does the second record, the one inserted using a parameter, have a different subnet?
Am I doing something wrong?

[lelit]

Oh, sorry, I saw #37 just now...

[lelit]

Another thing I'll wait 0.13 for! 😄

[elprans]

0.13 has been released with a fix for this.