Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11.4, 11.0(EOL)
-
None
-
Windows 11
Description
@@version: 11.0.2-MariaDB
Insert puts data after the .dbf end-of-file marker (0x1A) and doesn't update the number of records counter in the header.
I created a table:
CREATE TABLE test ( id INT(10) )
ENGINE=connect table_type=DBF
file_name='C:/tmp/test.dbf'
CHARACTER SET = 'cp852'
COLLATE='cp852_general_ci';
Then inserted a record:
INSERT INTO test(id) VALUES(5);
– End-of-file marker is missing.
After that I opened test.dbf with libreoffice calc, and add one line than save the file in dbf format. Libreoffice put end-of-file marker. The select statement list two records.
The next insert fails:
INSERT INTO test(id) VALUES(1);
SELECT * FROM test;
Select shows only two records instead of three and the dbf file is corrupted. The attached file has 5 records but only two of them are visible.
Attachments
Issue Links
- relates to
-
MDEV-31662 plugin ha_connect, file_type=DBF DELETE fails
- Open