Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
6.2.3, 23.02.3, 23.10.0, 5.6.8
-
None
-
None
-
ebi01:
CentOS Linux release 7.6.1810
10.3.16-MariaDB
Columnstore 1.2.5-1
ebi04:
Red Hat Enterprise Linux release 8.2
10.5.10-MariaDB MariaDB Server
Columnstore_version 5.5.2
Description
See the attached SQL EBI-499_bug_exposal_dummy.sql: the lines with "!!!" expose the bug when tested against dummy data tables on both EBI01 and EBI04 (MariaDB 10.3 and 10.5).
The problem are the MAX_INT values that must not occur when using COALESCE in the green boxes (and do not occur using InnoDB engine).
TODOs:
- check whether only Columnstore or also InnoDB is affected ==> DONE: only Columnstore
- simplify the bug exposal by using dummy data ==> DONE, see attached
- check if outer join or also inner join is affected ==> reduced to outer join (example makes no sense for inner join)
- check which MariaDB Version is affected ==> DONE, also 10.5 (on EBI04) is affected, same behaviour as for 10.3 (EBI01).