v2.0.7 and Grafana v7.1.3: Error 400 - bad request

[ADovgalyuk]

Hi everyone.
I've got an error after plugin update from 1.9.5 to 2.0.7. My request:

  $rateColumns(
'Dir.'||toString(cgpn_dir)||', Serv.'||toString(sender_service) as key,
sum(count) as value)
FROM (
select cgpn_dir,sender_service, toStartOfMinute(event_time) as event_time,
count() as count
from $table
WHERE $timeFilter
and message_type=0
and status=1
and external_message_id=''
and (dictGetString('nodes', 'Node', tuple(host)) in ($Node) or lower(host) in lower($Node))
group by event_time, cgpn_dir,sender_service
)

On 1.9.5 generated sql request is:

SELECT t,
       arrayMap(a -> (a.1, a.2/runningDifference(t/1000)), groupArr)
FROM
  (SELECT t,
          groupArray((KEY, value)) AS groupArr
   FROM
     (SELECT (intDiv(toUInt32(event_time), 60) * 60) * 1000 AS t,
             'Dir.' || toString(cgpn_dir) || ', Serv.' || toString(sender_service) AS KEY,
                                                          sum(COUNT) AS value
      FROM
        (SELECT cgpn_dir,
                sender_service,
                toStartOfMinute(event_time) AS event_time,
                COUNT() AS COUNT
         FROM statistics.SMSC_cdr
         WHERE event_time BETWEEN toDateTime(1597039332) AND toDateTime(1597060874)
           AND event_time BETWEEN toDateTime(1597039332) AND toDateTime(1597060874)
           AND message_type=0
           AND status=1
           AND external_message_id=''
           AND (dictGetString('nodes', 'Node', tuple(HOST)) IN ('SMSUSSDC_01')
                OR lower(HOST) IN lower('SMSUSSDC_01'))
         GROUP BY event_time,
                  cgpn_dir,
                  sender_service)
      GROUP BY t,
               KEY
      ORDER BY t,
               KEY)
   GROUP BY t
   ORDER BY t)

But on 2.0.7 its different and incorrect, part of subquery is lost:

SELECT t,
       arrayMap(a -> (a.1, a.2/runningDifference(t/1000)), groupArr)
FROM
  (SELECT t,
          groupArray((KEY, value)) AS groupArr
   FROM
     (SELECT (intDiv(toUInt32(event_time), 60) * 60) * 1000 AS t,
             'Dir.' || toString(cgpn_dir) || ', Serv.' || toString(sender_service) AS KEY,
                                                          sum(COUNT) AS value
      FROM statistics.SMSC_cdr
      WHERE event_time BETWEEN toDateTime(1597039533) AND toDateTime(1597061073)
        AND event_time BETWEEN toDateTime(1597039533) AND toDateTime(1597061073)
        AND message_type=0
        AND status=1
        AND external_message_id=''
        AND (dictGetString('nodes', 'Node', tuple(HOST)) IN ('SMSUSSDC_01')
             OR lower(HOST) IN lower('SMSUSSDC_01'))
      GROUP BY event_time,
               cgpn_dir,
               sender_service)
   GROUP BY t,
            KEY
   ORDER BY t,
            KEY)
GROUP BY t
ORDER BY t)

Seems like a bug to me, but I didn't find anything similar in current open issues.

[Slach]

Hello @ADovgalyuk thanks for detailed report I will check it and fix ASAP

[Slach]

@ADovgalyuk could you check the latest master version of plugin?