Reply To: svn-1303 – thinks it is a new database on startup?

#5518
fizze
Participant

hm I just peeked at db-sql.c in the trunk.

Looks like you handled that thing in
db_sql_open()

still looking weird to me though, being used to PL/SQL and plain C 😉

anyway, I suggest you put a NVL() around

select value from config where term='version'

in
f.i. db_sqlite3_open()
so it would read:

select nvl(value, 0) from config where term='version'

where it would return 0 if the value is null, missing, ^NIL 😉

that would be a proper approach, from the DB side, at least.