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

Source formatter complains if custom SQL file has BETWEEN statement

    Details

      Description

      If custom-sql file default.xml contains SQL like this:

      <sql id="com.liferay.osb.lcs.service.persistence.LCSClusterNodeFinder.countByS_PCT">
      <![CDATA[
      SELECT
      COUNT as countByS_PCT
      FROM
      OSBLCS_LCSClusterNode
      WHERE
      (OSBLCS_LCSClusterNode.archived = 0) AND
      (OSBLCS_LCSClusterNode.status & ? = ?) AND
      (OSBLCS_LCSClusterNode.processorCoresTotal BETWEEN ? AND ?)
      ]]>
      </sql>

      Source formatter will keep complain about missing parentheses in line with BETWEEN keyword no matter where developer put parentheses.

        Attachments

          Activity

            People

            • Assignee:
              hugo.huijser Hugo Huijser
              Reporter:
              igor.beslic Igor Beslic
              Participants of an Issue:
              Recent user:
              Jason Pince
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 34 weeks, 5 days ago

                Packages

                Version Package
                7.0.X
                7.1.0 M1
                7.1.X
                Master