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

Blog entries published in the same minute are placed in reverse order when using Oracle 10

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: No Longer Reproducible
    • Affects Version/s: 5.2.X EE, 6.0.12 EE, 6.1.0 CE RC1
    • Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M2
    • Labels:
      None
    • Environment:
      Tomcat 6.0.32 + Oracle 10.2.0.1.0. 5.2.x Revision 84698.
      Tomcat 6.0.32 + Oracle 10.2.0.1.0. 6.0.x Revision 84668.
      Tomcat 6.0.32 + Oracle 10.2.0.1.0. 6.1.x Revision 84698.
    • Fix Priority:
      2

      Description

      When a user publishes multiple blog entries during the same minute (an example would be publishing 2 blog entries at 3:15 pm), the order of the blog entries is arranged in a reverse order. This only occurs when the user is using Oracle 10 as a database.

      Here are the steps to reproduce the issue:

      1. Start Liferay using the Oracle database
      2. Add a blogs portlet
      3. Publish 2 or 3 blogs entries in the same minute; name the entries "Blog 1", "Blog 2", and "Blog 3"
      4. Check the order. Instead of being ordered from most to least recently published (Blog 3, Blog 2, Blog 1), the entries are ordered from least to most recently published (Blog 1, Blog 2, Blog 3)
      5. Publish an entry titled "Blog 4" during the next minute (Meaning that if the user published the first 2 or 3 blog entries at 3:15 pm, Blog 4 should be published at 3:16 pm or later)
      6. Check the order. Blog 4 will be the first blog entry listed (The new order will be "Blog 4, Blog 1, Blog 2, Blog 3"

        Attachments

          Activity

            People

            • Assignee:
              ken.duenwald Ken Duenwald
              Reporter:
              ken.duenwald Ken Duenwald
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 43 weeks, 1 day ago