I've a simple table with only a single primary key constraint - why would the loader complain of "SQL error 250 = Duplicate secondary key:INDEX001 (error position: 1) " if i've specified ignore duplicates? See below for table def and script. Advice appreciated:
=============================
create table financial_event
(
id VARCHAR (50) unique not null ,
related_transaction_id VARCHAR(50) not null,
type VARCHAR(20) not null,
service VARCHAR(50) not null, user_id VARCHAR (50) not null,
user_phone VARCHAR (50) not null,
user_device_id VARCHAR (50) not null,
recipient_user_id VARCHAR (50) not null,
recipient_user_phone VARCHAR (50) not null,
carrier_id VARCHAR (50) not null,
sku_id VARCHAR (50) not null,
device_type VARCHAR (50) not null,
amount fixed(5,2) not null,
currency VARCHAR(10) not null,
create_date timestamp not null,
modify_date timestamp not null,
external_transaction_id VARCHAR(50)
)
============================= script and log output:
dataload table financial_event
if pos 1 > '' ignore duplicates id 1 related_transaction_id 2 type 3 service 4 user_id 5 user_phone 6 user_device_id 7 recipient_user_id 8 recipient_user_phone 9 carrier_id 10 sku_id 11 device_type 12 amount 13 currency 14 create_date 15 modify_date 16 external_transaction_id 17
infile 'financial_event.csv' TIMESTAMP 'YYYY-MM-DD HH:MM:SS' SEPARATOR ','
Error during execution -->-25010 SQL error 250 = Duplicate secondary key:INDEX001 (error position: 1)
Defined maximum number of errors (1) reached
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
