Incorrect value for output size for both ExeMgr and CalGetTrace() rows

Bug #461516 reported by mroberts
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
InfiniDB Community
Confirmed
Low
Unassigned

Bug Description

Running this query attempts to join 5610197 rows with 87298316 rows and returns
0 rows (no matches).

select count(*) from orders, lineitem where o_orderdate between '1994-01-01'
and '1994-01-09' and o_orderkey = l_orderkey and l_shipdate between
'1994-05-15' and '1994-05-19';

However:
1) the ExeMgr output returns a value of 78848 for the output size
2) the getcaltrace (which reads ExeMgr ouput) returns 78848 for the row count.

Actual value should be 87298316, the number of rows put into the large side of
the join.

This behavior appears consistent with other queries as well.

ses:1 st: 1 finished at 2009-08-21 16:08:01.365927; PhyI/O-0; CacheI/O-843794;
MsgsSent-1232; MsgsRvcd-78848; BlocksTouched-843794; BlockedFifoIn/Out-0/46;
output size-78848
        PartitionBlocksEliminated-20193603; MsgBytesIn-7623KB; MsgBytesOut-81KB
        1st read 2009-08-21 16:07:59.955419; EOI 2009-08-21 16:08:01.365841;
runtime-1.410422s
        Job completion status 0

select count(*) from orders, lineitem where o_orderdate between '1994-01-01'
and '1994-01-09' and o_orderkey = l_orderkey and l_shipdate between
'1994-05-15' and '1994-05-19';
\. stat
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set, 1 warning (11.72 sec)

|
Desc Mode Table TableOID ReferencedOIDs PIO LIO PBE Elapsed Rows
BPS PM orders 3560 (3565,3561) 0 31161 720297 0.584
5610197
BPS PM lineitem 3075 (3086,3076,3084) 0 843794 20193603 1.410 78848
HJS PM lineitem 3075 - - - - 0.000 -
ADS UM - - - - - - 1.391 -
 |

mysql> select count(*) from orders where o_orderdate between '1994-01-01' and
'1994-01-09' ;
+----------+
| count(*) |
+----------+
| 5610197 |
+----------+
1 row in set, 1 warning (0.89 sec)

mysql> select count(*) from lineitem where l_shipdate between '1994-05-15' and
'1994-05-19';
+----------+
| count(*) |
+----------+
| 87298316 |
+----------+
1 row in set, 1 warning (1.32 sec)

mroberts (mroberts)
Changed in infinidb:
importance: Undecided → Low
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.