node-red-node-sqlite which is configured as
Error: SQLITE_RANGE: column index out of range
when I am passing as input:
I managed to fix this by deleting the msg.payload from my input and then it is working.
So it works properly when I pass exactly the same input without msg.payload.
In that case I didn't get the error and FYI the query returned the following:
It took me quite some time to figure out that the
msg.payload was causing this.
Maybe it would be good to update the documentation or make the implementation independent from the msg.payload passed as input when "Via msg.topic" is used.