When trying to execute my sql query to see if there is duplicate usernames
SELECT IF(EXISTS(SELECT username FROM auto_users WHERE username = "sean1"), 1, 0)
I am getting the following error…
GatewayException: Unable to read response from Gateway.
caused by org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 76; Element type “column” must be followed by either attribute specifications, “>” or “/>”.
Ignition v8.0.16 (b2020082513)
Java: Azul Systems, Inc. 11.0.7
Does anyone know why this is happening, the SQL is working in MYSQL.