[sr-dev] sql column type check

[Juha Heinanen]

Jasmin Schnatterbeck writes:

> I think it's much more efficient if values are checked before they are
> written to database. That would mean one "check" for each value -
> opposing to many more checks that would occur, if kamailio checks values
> every time it reads them from the database...

in case of lcr module, db is not accessed for each message, but only
during lcr reload and thus checking types of values is not a performance
issue.

> So if a server-wide parameter "skip db value type checks" exists, the
> kamailio user will be able to choose the preferred model....

it would be hard to do, because VAL_TYPE returns type of value that is
then checked in the module, e.g.

if (VAL_TYPE(ROW_VALUES(row) + 1) != DB1_STRING) ...

so it would not work just by turning VAL_TYPE into a no-op.

-- juha