Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-127682

Update SQL statement to account for SQL Server

    Details

      Description

      CountryLocalServiceTest#testSearchCountriesPagination is failing in SQL Server from the following errors:

      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'distinct'
      

        Attachments

          Activity

            People

            Assignee:
            melody.wu Melody Wu
            Reporter:
            patricia.perez Patricia Perez
            Participants of an Issue:
            Recent user:
            Melody Wu
            Engineering Assignee:
            Albert Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              4 days ago

                Packages

                Version Package
                Master