#4356 (ok 4.1.13) GROUPed selects show number of rows as if not grouped

4.1.12
fixed
Marc Delisle
None
1
2014-04-13
2014-04-09
Raimund Meyer
No
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL,
  `test` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO `test` (`id`, `test`) VALUES
(1, '1'),
(2, '1');

SELECT * FROM `test` GROUP BY test

This query yields one row, but the message above the table says there are 2 rows. This also affects the calculation of the number of pages, so you can go to pages that don't actually exist.

1 Attachments

Discussion

  • Marc Delisle
    Marc Delisle
    2014-04-11

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2014-04-11

    • summary: GROUPed selects show number of rows as if not grouped --> (ok 4.1.13) GROUPed selects show number of rows as if not grouped
    • status: open --> resolved
    • Group: Latest_Git --> 4.1.12
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2014-04-13

    • Status: resolved --> fixed