Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-12966

Undefined sorting of posts with same post_time on postgres

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 3.0.12, 3.1.0-RC2
    • 3.1.0-RC4
    • Viewing posts
    • None

    Description

      Posts are sorted by using ORDER BY p.post_time. As far as postgres is concerned, the sorting for rows with the same post time is undefined. It apparently only depends on which row is loaded from the database backend first.

      This should be changed to also sort by post_id.

      Attachments

        Activity

          People

            Marc Marc
            Marc Marc
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: