Since updating Julia from v1.6.2 (SQLite v1.2.0) to v1.7.1 (SQLite v 1.3.0) I get an error while trying to add data to an existing table in my database.
julia> dataBiomet |> SQLite.load!(db,"Biomet")
ERROR: SQLiteException("NOT NULL constraint failed: Biomet.ALB_1_1_1other")
The SQLite.load! function did receive some updates in the update from 1.2.0 to 1.3.0 but to me it doesn’t seem like it should cause a problem for my case. The database and all of its contents were created using SQLite.jl.
Here is the information returned by SQLite.tableinfo(db,"Biomet"):
cid = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9 … 34, 35, 36, 37, 38, 39, 40, 41, 42, 43]
name = ["Timestamp", "ALB_1_1_1other", "CS_1_1_1other", "CS_2_1_1other", "CS_3_1_1other", "CS_4_1_1other", "CS_5_1_1other", "LWIN_1_1_1W_per_m2", "LWINraw_1_1_1W_per_m2", "LWOUT_1_1_1W_per_m2" … "TS_1_4_1C", "TS_1_5_1C", "TS_1_6_1C", "TS_2_1_1C", "TS_2_2_1C", "TS_2_3_1C", "TS_2_4_1C", "TS_2_5_1C", "TS_2_6_1C", "CHK"]
type = ["TEXT", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL" … "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "INT"]
notnull = [1, 1, 1, 1, 1, 1, 1, 1, 1, 1 … 1, 1, 1, 1, 1, 1, 1, 1, 1, 1], dflt_value = [missing, missing, missing, missing, missing, missing, missing, missing, missing, missing … missing, missing, missing, missing, missing, missing, missing, missing, missing, missing]
pk = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0 … 0, 0, 0, 0, 0, 0, 0, 0, 0, 0])