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: | |
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
[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