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

            summer.zhang Summer Zhang
            norbert.kocsis Norbert Kocsis (Inactive)
            Kiyoshi Lee Kiyoshi Lee
            Norbert Kocsis Norbert Kocsis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              2 years, 31 weeks, 1 day 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