You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
column types are not correctly inferred when updating mariadb to version 11.
It's probably worthwhile switching to the latest mariadb c connector
with MariaDB Server 10:
julia>DataFrame(DBInterface.execute(conn, "select * from `benutzer`"))
2×1 DataFrame
Row │ uname
│ String?
─────┼─────────
1 │ test
2 │ rest
with MariaDB Server 11:
julia> DBInterface.execute(conn, "select * from `benutzer`") |> DataFrame
ERROR: ArgumentError: invalid number format test
Stacktrace:
[1] parse(#unused#::Type{DecFP.Dec64}, s::String)
@ DecFP C:\Users\helmu\.julia\packages\DecFP\Cud5F\src\DecFP.jl:323
If I store strings that can be parsed as numbers in the field 'uname' the columns are indeed read as Dec64.