For example:
ALTER TABLE customer
ADD CONSTRAINT pk_customer
PRIMARY KEY (c_w_id, c_d_id, c_id);

But the "datagen -t mysql" generate data include null values . They can not be created to be primary key. And the c_w_id, c_d_id, c_id has the same values . They are not unique. They also can not be created to primary key.

make[3]: Leaving directory '/home/lshn1118/sqlbench/src/storeproc'
Making all in core
make[3]: Entering directory '/home/lshn1118/sqlbench/src/core'
gcc -g -O2 -pthread -Wl,-rpath=/usr/lib/x86_64-linux-gnu -o datagen datagen.o libcore.a ../simple/libsimplesql.a ../extended/libextended.a ../dbc/mysql/libdbc_mysql.a -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lm -lrt -latomic -ldl -lm
../dbc/mysql/libdbc_mysql.a(libdbc_mysql_a-dbc_mysql.o): In function mysql_open_loader_stream': /home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:269: undefined reference to cli_safe_read'
/home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:277: undefined reference to net_field_length' /home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:286: undefined reference to my_net_write'
/home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:287: undefined reference to net_flush' ../dbc/mysql/libdbc_mysql.a(libdbc_mysql_a-dbc_mysql.o): In function mysql_close_loader_stream':
/home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:331: undefined reference to my_net_write' /home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:339: undefined reference to my_net_write'
/home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:339: undefined reference to net_flush' ../dbc/mysql/libdbc_mysql.a(libdbc_mysql_a-dbc_mysql.o): In function mysql_write_to_stream':
/home/lshn1118/sqlbench/src/dbc/mysql/dbc_mysql.c:311: undefined reference to `my_net_write'
collect2: error: ld returned 1 exit status
Makefile:416: recipe for target 'datagen' failed
make[3]: *** [datagen] Error 1
make[3]: Leaving directory '/home/lshn1118/sqlbench/src/core'
Makefile:322: recipe for target 'all-recursive' failed
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory '/home/lshn1118/sqlbench/src'
Makefile:368: recipe for target 'all-recursive' failed
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory '/home/lshn1118/sqlbench'
Makefile:307: recipe for target 'all' failed
make: *** [all] Error 2

环境：
debian 9.4

src/core/datagen -t mysql --dbname=tpcd --host=localhost --port=3306 --socket=/usr/local/mysql/mysql.sock --user=root --password=root -j1 -w100

warehouses = 100
districts = 10
customers = 3000
items = 100000
orders = 3000
stock = 100000
new_orders = 900

load threads: 1
Output directory of data files: current directory

Loading data to database for 100 warehouse(s)...
Generating item table data...
FATAL: could not write to stream

cat error.log

Thu Aug 1 18:44:58 2019
tid:47515789649664 dbc_mysql.c:329
could not execute load data local infile statement: The used command is not allowed with this MySQL version