When inserting multiple entries into a column that allows NULL values executemany() throws a DataError. This only happens if some of the tuples contain values with the coresponding type and some are of type None. If all values are None or if all values are not None and have the proper type, this error doesn't occur.
1. create a table with a column that allows NULL values
2. use executemany() to insert values that can either be of type int (in this example) or None
Either a proper exception that describes why None cannot be inserted together with the proper type or insertion of NULL values.
A mariadb.DatabaseError.DataError with the message "Invalid parameter type at row 2, column 1".
(Another example can be found on StackOverflow)