Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-280

fix LP bug#1001092 Query with GROUP BY returns an extra row

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Won't Fix
        • Affects Version/s: 5.2.12
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Gliffy Diagrams

            Attachments

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment -

              It is not repeatable on 5.3.

              Show
              sanja Oleksandr Byelkin added a comment - It is not repeatable on 5.3.
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment -

              In 5.3 it was fixed by adding this to Cached_item_field::cmp :

              /*
              If value is not null and value changed (from null to not null or
              becasue of value change), then copy the new value to buffer.
              */
              if (! null_value && (tmp || (tmp= (field->cmp(buff) != 0))))
              field->get_image(buff,length,field->charset());

              Show
              sanja Oleksandr Byelkin added a comment - In 5.3 it was fixed by adding this to Cached_item_field::cmp : /* If value is not null and value changed (from null to not null or becasue of value change), then copy the new value to buffer. */ if (! null_value && (tmp || (tmp= (field->cmp(buff) != 0)))) field->get_image(buff,length,field->charset());

                People

                • Assignee:
                  sanja Oleksandr Byelkin
                  Reporter:
                  sanja Oleksandr Byelkin
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: