You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE sbtest%d(
id %s,
k INTEGER DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
%s (id)
) %s %s]],
table_num, id_def, id_index_def, engine_def,
sysbench.opt.create_table_options)
FATAL: `sysbench.cmdline.call_command' function failed: ./oltp_common.lua:203: SQL error, errno = 0, state = '42601': multiple default values specified for column "pad" of table "sbtest1"
Creating table 'sbtest10'...
FATAL: PQexec() failed: 7 multiple default values specified for column "pad" of table "sbtest9"
FATAL: failed query was: CREATE TABLE sbtest9(
id SERIAL,
k INTEGER DEFAULT '0' NOT NULL,
c VARCHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL DEFAULT '',
PRIMARY KEY (id)
)
correct create table statement
CREATE TABLE sbtest%d(
id %s,
k INTEGER NOT NULL DEFAULT '0',
c CHAR(120) NOT NULL DEFAULT '',
pad CHAR(60) NOT NULL DEFAULT '' ,
%s (id)
) %s %s]],
table_num, id_def, id_index_def, engine_def,
sysbench.opt.create_table_options)
The text was updated successfully, but these errors were encountered:
CREATE TABLE sbtest%d(
id %s,
k INTEGER DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
%s (id)
) %s %s]],
table_num, id_def, id_index_def, engine_def,
sysbench.opt.create_table_options)
FATAL: `sysbench.cmdline.call_command' function failed: ./oltp_common.lua:203: SQL error, errno = 0, state = '42601': multiple default values specified for column "pad" of table "sbtest1"
Creating table 'sbtest10'...
FATAL: PQexec() failed: 7 multiple default values specified for column "pad" of table "sbtest9"
FATAL: failed query was: CREATE TABLE sbtest9(
id SERIAL,
k INTEGER DEFAULT '0' NOT NULL,
c VARCHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL DEFAULT '',
PRIMARY KEY (id)
)
correct create table statement
CREATE TABLE sbtest%d(
id %s,
k INTEGER NOT NULL DEFAULT '0',
c CHAR(120) NOT NULL DEFAULT '',
pad CHAR(60) NOT NULL DEFAULT '' ,
%s (id)
) %s %s]],
table_num, id_def, id_index_def, engine_def,
sysbench.opt.create_table_options)
The text was updated successfully, but these errors were encountered: