Bug #29460 falcon - Can't find record in 't1'
Submitted: 30 Jun 2007 20:00 Modified: 19 Oct 2007 20:56
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.1-BK OS:Any
Assigned to: CPU Architecture:Any

[30 Jun 2007 20:00] Shane Bester
Description:
Works for myisam and innodb tables.  Falcon gives some duplicate key error.

mysql> drop table if exists t1;
Query OK, 0 rows affected (0.00 sec)

mysql> create table t1 (a varchar(3),primary key(a))engine=falcon;
Query OK, 0 rows affected (0.06 sec)

mysql> load data local infile '/tmp/load.txt' replace into table t1 (@h) set a=UNHEX(@h);
ERROR 1032 (HY000): Can't find record in 't1'

In mysql error log, there are some lines:
Exception: duplicate values for key T1..PRIMARY_KEY in table TEST.T1

How to repeat:
drop table if exists t1;
create table t1 (a varchar(3),primary key(a))engine=falcon;
load data local infile '/tmp/load.txt' replace into table t1 (@h) set a=UNHEX(@h);

Suggested fix:
.
[30 Jun 2007 20:01] MySQL Verification Team
file to be loaded with load data infile ...

Attachment: load.txt (text/plain), 63.15 KiB.

[2 Jul 2007 11:44] MySQL Verification Team
Thank you for the bug report.

c:\dev\6.0>bin\mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 6.0.1-alpha-nt Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t1 (a varchar(3),primary key(a))engine=falcon;
Query OK, 0 rows affected (0.64 sec)

mysql> load data local infile 'c:/temp/load.txt' replace into table t1 (@h) set a=UNHEX(@h);
ERROR 1032 (HY000): Can't find record in 't1'
mysql> alter table t1 engine=MyISAM;
Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> load data local infile 'c:/temp/load.txt' replace into table t1 (@h) set a=UNHEX(@h);
Query OK, 16577 rows affected (0.41 sec)
Records: 13108  Deleted: 3469  Skipped: 0  Warnings: 0

mysql>
[16 Oct 2007 11:43] Hakan Küçükyılmaz
Shane,

can you retry with latest Falcon release?

Best regards,

Hakan
[19 Oct 2007 20:56] Ann Harrison
It appears to work for me.

Regards,

Ann