Queries using the DISTINCT keyword do not work in the Web Management Console

Description

The followning sql query will fail in the webui:

select distinct type from com.acme.crew.cache.model.shared.ContractMonth where rowNum<50

'type' is defined to be a String in this example.
Error message that appears in the webui:

java.sql.SQLException: Error in statement [select UID, distinct type from com.acme.crew.cache.model.shared.ContractMonth where rowNum<50]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "distinct" "distinct"" at line 1, column 12. Was expection one of: "uid" ...

Works when using gs-ui. Works when using JDBC api from Java client.

Workaround

None

Acceptance Test

manual

Assignee

Evgeny Fisher

Reporter

Dixson Huie

Labels

Priority

Medium

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Premium

Platform

All
Configure