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

LP:1001092 - Query with GROUP BY returns an extra row

        Details

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

          Description

          The following test case produces a wrong result in MariaDB 5.2:

          CREATE TABLE t1 (vc varchar(1), INDEX vc_idx (vc)) ;
          INSERT INTO t1 VALUES (NULL), ('o'), (NULL), ('p'), ('c');
          FLUSH TABLE t1;
          SELECT vc FROM t1 GROUP BY vc;

          MariaDB [test]> SELECT vc FROM t1 GROUP BY vc;
          ------

          vc

          ------

          NULL
          NULL
          c
          o
          p

          ------
          5 rows in set (0.01 sec)

          (See also bug #12837714 in mysql-trunk)

            Gliffy Diagrams

              Attachments

                Activity

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

                Re: Query with GROUP BY returns an extra row
                It is not repeatable on 5.3

                Show
                sanja Oleksandr Byelkin added a comment - Re: Query with GROUP BY returns an extra row It is not repeatable on 5.3
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 1001092

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1001092
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                The bug is not repetable in 5.3, 5.5, 10.0

                Show
                sanja Oleksandr Byelkin added a comment - The bug is not repetable in 5.3, 5.5, 10.0
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                We can't repeat the bug any more

                Show
                sanja Oleksandr Byelkin added a comment - We can't repeat the bug any more

                  People

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

                    Dates

                    • Created:
                      Updated:
                      Resolved: