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

PostgreSQLTransformerLogic.replaceCastLong(Matcher matcher) converts to a wrong type

    Details

      Description

      protected String replaceCastLong(Matcher matcher) {
      	return matcher.replaceAll("CAST($1 AS INTEGER)");
      }
      

      This is wrong as INTEGER is only 4 bytes in PostgreSQL. It should be BIGINT instead.
      Refer to:
      https://www.postgresql.org/docs/9.1/datatype-numeric.html

        Attachments

          Activity

            People

            Assignee:
            summer.zhang Summer Zhang
            Reporter:
            norbert.kocsis Norbert Kocsis (Inactive)
            Participants of an Issue:
            Recent user:
            Jason Pince
            Engineering Assignee:
            Norbert Kocsis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 29 weeks, 6 days ago

                Packages

                Version Package
                7.1.10 DXP FP17
                7.1.10.4 SP4
                7.1.X
                7.2.10 DXP FP5
                7.2.10.2 DXP SP2
                7.2.X
                7.3.1 CE GA2
                7.3.2 CE GA3
                7.3.10 DXP GA1
                Master