Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 0.9.59
-
Fix Version/s: 1.0.0
-
Component/s: DBAPI 2.0
-
Labels: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) |