dynamobi/dynamobi — Issue #150: [LDB-172] Script generates wrong data for TPC-H
Author: dynamobi-build
Created: 2011-12-30 02:17:00+00:00
State: open
Labels: LDB, Test

[reporter="kvu", created="Mon, 3 Mar 2008 16:40:11 -0500 (GMT-05:00)"]
JVS discovered following problem while trying to load flatfiles generated by the script in open/thirdparty/tpch.tar.gz for TPC-H 10G:

MonetDB is

detecting a referential integrity violation between orders and customers

when I attempt to add the foreign key. I ran an outer join query to

find the violations, and they are for real.

If I grep for these keys in orders*.tbl, the references are there, but

the corresponding primary keys do not exist in customer*.tbl.

sql>select orders.o_custkey from orders left outer join customer on

orders.o_custkey=customer.c_custkey where customer.c_custkey is null;

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

| o_custkey |

+============+

| 26248435 |

| 1423281874 |

| 1797676328 |

| 2128179385 |

| 18556156 |

| 627611099 |

| 2135722591 |

| 1023898660 |

| 23603857 |

| 852458768 |

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

JVS