| Bug #43128 | Falcon can't delete rows with decimal column boundary values | ||
|---|---|---|---|
| Submitted: | 24 Feb 2009 7:08 | Modified: | 24 Feb 2009 8:00 |
| Reporter: | Nidhi Shrotriya | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 6.0.10 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[24 Feb 2009 8:00]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior with current bzr sources, although bug was repeatable with previous versions. Please wait next release.
Description: As described in How to repeat section. How to repeat: CREATE TABLE t1(c1 DECIMAL(10,5) UNSIGNED NOT NULL, c2 DECIMAL(10,5) SIGNED NULL, c3 DECIMAL, c4 INT, UNIQUE INDEX idx(c1,c2)) engine=falcon; INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1); Warnings: Note 1265 Data truncated for column 'c3' at row 1 INSERT INTO t1(c1) VALUES('12345.000009'); Warnings: Note 1265 Data truncated for column 'c1' at row 1 INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3); Warnings: Note 1265 Data truncated for column 'c3' at row 1 SELECT * FROM t1; c1 c2 c3 c4 100.05000 -100.05000 100 1 12345.00001 NULL NULL NULL 99999.99999 -99999.99999 100000 3 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5); ERROR 23000: Duplicate entry '99999.99999--99999.99999' for key 'idx' DELETE FROM t1 WHERE c1='99999.99999' AND c2='-99999.99999'; SELECT * FROM t1; c1 c2 c3 c4 100.05000 -100.05000 100 1 12345.00001 NULL NULL NULL 99999.99999 -99999.99999 100000 3 rows with c1='99999.99999' AND c2='-99999.99999' are still present.