Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.1.10
-
None
-
None
-
None
-
Raspbian 11
-
3.11
Description
I am running a MariaDB server and operating data via python connector.
The setup is stable and many other operations are running with no issues.
There is a table with 3 columns defined as `bigint(20) unsigned` and one int.
Bigint columns used to store values that come close to (2^64)-1.
Just to be specific, the value in question is `13837380911034793984` which is above signed limit, and requires the unsigned type.
Simply speaking, `cursor.execute` works, but `cursor.executemany` fails with
` self._execute_bulk()
mariadb.DataError: Out of range value for column 'fen2' at row 1`
To narrow the issue I tried 3 ways to insert the same data and ony one is failing range validation
- *works *- manual insertion without any python code - `INSERT INTO `evaluations_binary` VALUES (0, 9232974212090577672, 11529232914765115761, 58), (0, 13837380911034793984, 11529233872889843812, 0), (0, 0, 2351636844950589488, 9999);`
- *works *- `cursor.execute` being called in a loop 3 times with each of the tuples above
- *fails * - `cursor.executemany` with a list consisting of 3 tuples above