Doing my project, I bumped with strange behaviour of Database integration activity.
It does not accept command DELIMITER, which I need to use in my SQL requests.
I am utilise the standard Database package
activity looks like this
error message here
Execute Non Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DELIMITER $$ select SQRT(4) $$ DELIMITER’ at line 1
Connection using “MySql.Data.MySqlClient” provider.
Do not experience any other issues with this provider , do I suspect that this command ruin communications.
I would appreciate if anybody who met and solved this issue, could share his solution.