Uploaded image for project: 'InsightEdge Platform'
  1. GS-13543

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 12.3.1, 12.1.0-patch2
    • Labels:
    • Platform:
      All
    • Acceptance Test:
      manual
    • Sprint:
    • Product:
      XAP
    • Edition:
      Premium

      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: