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

Status

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