Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 6.1.1
-
Fix Version/s: 22.08
-
Component/s: PrimProc
-
Labels:
Description
The legacy regression test working_tpch1_compareLogOnly/having/having2.sql has a failure running the query:
MariaDB [tpch1]> select cinteger, abs(avg(cinteger)) from DataTypeTestm group by cinteger having abs(avg(cinteger)) > 7483645;
|
+----------+--------------------+
|
| cinteger | abs(avg(cinteger)) |
|
+----------+--------------------+
|
| 7483646 | 7483646.0000 |
|
| 7483647 | 7483647.0000 |
|
+----------+--------------------+
|
2 rows in set (0.011 sec)
|
The correct result is however:
MariaDB [tpch1]> select cinteger, abs(avg(cinteger)) from test42 group by cinteger having abs(avg(cinteger)) > 7483645;
|
+----------+--------------------+
|
| cinteger | abs(avg(cinteger)) |
|
+----------+--------------------+
|
| -7483646 | 7483646.0000 |
|
| 7483646 | 7483646.0000 |
|
| 7483647 | 7483647.0000 |
|
+----------+--------------------+
|
3 rows in set (0.001 sec)
|
As you can see the 3d record with a negative cinteger value isn't returned.