hmmm … mystic:
If there is an trigger defined on databse level, openHAB2 persistant service reacts “not amused” with “Error in SQL query” at record insert statement.
Trigger works without problems. This is tested.
OpenHAB insert statement works fine, if no trigger is defined. This is tested.
What’s going on here?
The trigger action doesn’t attach the insert procedure directly. It only delets old records from tabel.