Fixes returned ids in multiple_insert for mysqldb (Issue 443 web.py) by nlaurens · Pull Request #447

Fixes returned ids in multiple_insert for mysqldb (Issue 443 web.py) by nlaurens · Pull Request #447 · webpy/webpy

multiple_insert assumes the returned id is the ID of the last item
in the rows. Mysql actually returns the id of the first row. Fix
does not alter behaviour for other dbs. Note, that for postgres
and sqllite the current behaviour is correct.

mentioned this pull request

Sep 16, 2019

iredmail added a commit that referenced this pull request

Sep 16, 2019

- Fixed incorrect returned insert ids with `multiple_insert()`. Tested with MariaDB-10.1.29 on Ubuntu 18.04, and PostgreSQL-11.5 on OpenBSD 6.5.
- Update ChangeLog.txt.

Fixes #447
Fixes #263