Different GROUPing results at vmode =2 and vmode=0

1 post / 0 new
lazialist
lazialist's picture
Offline
Last seen: 2 months 4 weeks ago
Joined: Nov 5 2013
Junior Boarder

Posts: 1

Alexander Levchenko
Different GROUPing results at vmode =2 and vmode=0

Hi Guys,
just upgraded to infinidb 4 and swithed to vmode =2
Have weird problem :

SELECT tmpId,
GROUP_(label___name SEPARATOR '\') from (
SELECT
label_object.campaign_id AS tmpId,
(label.id, '|', label.name, '|', label.color) AS label___name
FROM
label_object
JOIN label ON label.id = label_object.id AND label_object.scope ='campaign'
WHERE
label.account_id = '1976225674'
) a GROUP BY tmpId

have not correct results (some items are missing at result), but :
SELECT
label_object.campaign_id AS tmpId,
(label.id, '|', label.name, '|', label.color) AS label___name
FROM
label_object
JOIN label ON label.id = label_object.id AND label_object.scope ='campaign'
WHERE
label.account_id = '1976225674'

returns correct results

tried COUNT instead GROUP_- same , some items missed.

but all ok when vmode=0, seems when items grouping wrong when vmode=2.