Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.2
-
None
Description
Since MariaDB Server 10.5 data type JSON is not returned as MYSQL_TYPE_JSON anymore, but as MYSQL_TYPE_BLOB with extended field attributes, which results in wrong data type:
import mariadb |
 |
conn=mariadb.connect(db="test") |
cursor=conn.cursor() |
cursor.execute("create temporary table t1(a json)") |
cursor.execute("insert into t1 values ('{}')") |
cursor.execute("select * from t1"); |
fieldinfo= mariadb.fieldinfo() |
info= cursor.description |
print(fieldinfo.type(info[0])) |
del cursor |
del connection |
Output:
BLOB
|