[jira] [Created] (GUACAMOLE-870) Connection history query fails against SQL Server

["Michael Jumper (Jira)" <ji...@apache.org>]

Michael Jumper created GUACAMOLE-870:
----------------------------------------

             Summary: Connection history query fails against SQL Server
                 Key: GUACAMOLE-870
                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-870
             Project: Guacamole
          Issue Type: Bug
          Components: guacamole-auth-jdbc-sqlserver
            Reporter: Michael Jumper


While the connection history initially displays correctly, any queries against the history fail with the following error:

{code:none}
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'username'.
{code}

This is due to the use of the {{POSITION()}} function within the query and is presumably a holdover from the initial creation of SQL Server support for Guacamole. This function is present in both the MySQL and PostgreSQL flavors of the Guacamole history query, which predate SQL Server support and would have been used as its basis.

Unlike MySQL and PostgreSQL, SQL Server does not support the {{POSITION()}} function. The {{CHARINDEX()}} function should be used instead.



--
This message was sent by Atlassian Jira
(v8.3.2#803003)