Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.5.3
-
None
-
2020-8
Description
The following query returns the wrong answer:
MariaDB [ssb]> select count(*) as c8 from lineorder where lo_orderdate in (select d_datekey from dateinfo where (d_yearmonthnum, d_daynuminmonth) in ((199204, 12), (199505,11))); |
+----+
|
| c8 |
|
+----+
|
| 0 | |
+----+
|
|
It should be:
MariaDB [ssb]> select count(*) as c8 from lineorder where lo_orderdate in (select d_datekey from dateinfo where (d_yearmonthnum, d_daynuminmonth) in ((199204, 12), (199505,11))); |
+------+
|
| c8 |
|
+------+
|
| 4755 | |
+------+
|
|