Hi all,
I’ve just run into this exception:
Type mismatch: rowtype of new rel: RecordType(VARCHAR pub, VARCHAR pub0, DOUBLE
NOT NULL $f2) NOT NULL rowtype of set: RecordType(VARCHAR pub, VARCHAR pub0,
DOUBLE rate) NOT NULL
executing this SQL:
SELECT base."pub”,
Any_value(base.”rate”),
Any_value(comparison."rate")
FROM (
SELECT "pub",
Min(total)/Max(price) AS "rate"
FROM "test_data"
WHERE "__time" >= timestamp '2022-03-01 00:00:00'
GROUP BY "pub"
ORDER BY TRUE,
2 limit 500 ) base
left outer join
(
SELECT "pub",
min(total)/max(price) AS "rate"
FROM "test_data"
WHERE "__time" < timestamp '2022-03-01 00:00:00'
GROUP BY "pub" ) comparison
ON base."pub" = comparison."pub"
GROUP BY 1
looking through JIRA I concluded that bug is still an issue, I wonder if
there’s a known workaround for that?
