search

gregrahn / tpcds-kit

TPC-DS benchmark kit with some modifications/fixes
320 stars 205 forks source link

tpcds_ri.sql has several bugs #9

Closed gregrahn closed 10 years ago

gregrahn commented 10 years ago

Errors related to two references to columns that do not exist and three duplicate name collisions.

psql:tpcds-kit/tools/tpcds_ri.sql:39: ERROR:  column "cp_promo_id" referenced in foreign key constraint does not exist
psql:tpcds-kit/tools/tpcds_ri.sql:50: ERROR:  constraint "cr_i" for relation "catalog_returns" already exists
psql:tpcds-kit/tools/tpcds_ri.sql:55: ERROR:  column "cr_ship_date_sk" referenced in foreign key constraint does not exist
psql:tpcds-kit/tools/tpcds_ri.sql:119: ERROR:  constraint "wr_ret_cd" for relation "web_returns" already exists
psql:tpcds-kit/tools/tpcds_ri.sql:124: ERROR:  constraint "ws_b_cd" for relation "web_sales" already exists