The SQL query "SELECT COUNT (...) GROUP BY" doesn't work on nested properties in the Web Management Console

Description

Below query works fine in gs-ui but fails in web-ui
select count(p1.x),p2.y from z where
rownum<5000 and p1.x='ZZ' group by p2.y

Attached reproduction test and snapshots from the gs-ui and web-ui

Workaround

None

Acceptance Test

manual

Assignee

Evgeny Fisher

Reporter

Yuval Dori

Labels

Priority

Critical

SalesForce Case ID

00011583

Fix versions

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Premium

Platform

All
Configure