Two single quotes sent to MS SQL server as a one single quote

Hi All,

  • What Grafana version and what operating system are you using?
    Grafana - 9.2.0
    OS - Ubuntu 20.04.5
    This problem occurred when applying the following updates to the server:
    Start-Date: 2022-10-16 08:41:43
    Commandline: apt upgrade -y
    Requested-By: grafadmin (1000)
    Install:
    linux-headers-5.4.0-128:amd64 (5.4.0-128.144, automatic),
    linux-headers-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
    linux-modules-extra-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
    linux-modules-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
    linux-image-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic)

Upgrade:
libgssapi3-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libwind0-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
linux-headers-generic:amd64 (5.4.0.126.127, 5.4.0.128.129),
linux-libc-dev:amd64 (5.4.0-126.142, 5.4.0-128.144),
linux-image-generic:amd64 (5.4.0.126.127, 5.4.0.128.129),
libheimntlm0-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libgmp10:amd64 (2:6.2.0+dfsg-4, 2:6.2.0+dfsg-4ubuntu0.1),
libheimbase1-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libhcrypto4-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
grafana-enterprise:amd64 (9.1.7, 9.2.0), unzip:amd64 (6.0-25ubuntu1, 6.0-25ubuntu1.1),
libroken18-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libasn1-8-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libkrb5-26-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libhx509-5-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
linux-generic:amd64 (5.4.0.126.127, 5.4.0.128.129)
End-Date: 2022-10-16 08:43:16

  • What are you trying to achieve?
    Send an empty string to our Microsoft SQL server ie ‘’

  • How are you trying to achieve it?
    Typing ‘’

  • What happened?
    The query inspector shows a single quote ’

  • What did you expect to happen?
    The query inspector should show two single quotes ‘’

  • Can you copy/paste the configuration(s) that you are having problems with?
    Example 1
    Line from the query, part of a case statement:
    WHEN TMSFC.code in(‘BHOL’,‘H’,‘HU’,‘CS’) and TMSFC.STARTDATE = ENDDATE AND TMSFC.STARTDATE = CAST(CAST(GETDATE() AS date) AS datetime) THEN ‘’

Query Inspector line
WHEN TMSFC.code in(‘BHOL’,‘H’,‘HU’,‘CS’) and TMSFC.STARTDATE = ENDDATE AND TMSFC.STARTDATE = CAST(CAST(GETDATE() AS date) AS datetime) THEN ’

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    I received the following below the query box:
    db query error: mssql: Incorrect syntax near ‘BHOL’.

  • Did you follow any online instructions? If so, what is the URL?
    I cannot find anything relating to this issue.

With thanks
Ian

in('BHOL','H','HU',CS')

You need a space after that in (
since the error says
db query error: mssql: Incorrect syntax near ‘BHOL’.