Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
0.9.59
-
None
Description
When inserting NULL values to a server which doesn't support BULK statements NULL values are not inserted correctly.
Example:
import mariadb |
 |
conn=mariadb.connect(user="georg", database="test") |
cursor=conn.cursor() |
cursor.execute("CREATE TEMPORARY TABLE ind1 (a int, b int default 2,c int)") |
vals = [(1,4,3),(None, 2, 3)] |
cursor.executemany("INSERT INTO ind1 VALUES (?,?,?)", vals) |
cursor.execute("SELECT a, b, c FROM ind1") |
row= cursor.fetchall() |
print(row) |