If a complete SQL statement is put in msg.topic and msg.payload is empty, an error occurs.

stackhero-io / node-red-contrib-stackhero-mysql

Node-RED node to read and write to a MySQL or a MariaDB database. Compatible with TLS (SSL) and "Caching SHA2 password" authentication method.

16 stars 7 forks source link

Closed juggledad closed 4 years ago

juggledad commented 4 years ago

If I put "select * from foo" into msg.topic (where 'foo' is an actual table) and msg.payload is empty, an error is returned with the message:

"msg.payload should be an object containing the query arguments."

The seems like a bug since there are no query arguments in this query.

Bacto commented 4 years ago

Hi,

Thanks for this issue. This is resolved with 1.0.3 :)