[#MDEV-25671] MOD function returns wrong value?

output from the second statement below (`select * from integers group by i%3 ;`) should not return the value 3.

MariaDB [test]> select distinct i%3 from integers;

+------+

| i%3  |

+------+

|    0 |

|    1 |

|    2 |

+------+

3 rows in set (0.499 sec)

MariaDB [test]> select * from integers  group by i%3 ;

+---+--------------------------------------+

| i | t1                                   |

+---+--------------------------------------+

| 3 | a44c970b-aff2-11eb-8dec-00155dfdb341 |

| 1 | a19fcf11-aff2-11eb-8dec-00155dfdb341 |

| 2 | a389475c-aff2-11eb-8dec-00155dfdb341 |

+---+--------------------------------------+

3 rows in set (0.553 sec)

MariaDB [test]> select @@version;

+----------------+

| @@version      |

+----------------+

| 10.5.9-MariaDB |

+----------------+

1 row in set (0.000 sec)

Table definition:

CREATE TABLE `integers` (

  `i` int(11) NOT NULL,

  `t1` varchar(36) DEFAULT NULL,

  PRIMARY KEY (`i`),

  KEY `integers_t1` (`t1`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Impression of contents of this table:

select min(i),max(i), count(*) from integers;

+--------+---------+----------+

| min(i) | max(i)  | count(*) |

+--------+---------+----------+

|      0 | 2097152 |  2097153 |

+--------+---------+----------+

[MDEV-25671] MOD function returns wrong value? Created: 2021-05-13 Updated: 2021-05-22 Resolved: 2021-05-22
Status:	Closed
Project:	MariaDB Server
Component/s:	Platform Windows
Affects Version/s:	10.5.9
Fix Version/s:	N/A