[MDEV-31662] plugin ha_connect, file_type=DBF DELETE fails - Jira

XML

Word

Printable

@@version: 11.0.2-MariaDB

like ~~MDEV-31625~~ but different:

There's a problem still in the deletes aren't affecting the file format correctly (though SQL seems to cope).

MariaDB [test]>  insert into t1 values (4),(3),(2),(1);

$ od --endian=big -x /tmp/build-mariadb-server-10.4-datadir/test/t1.dbf

0000000 037b 070b 0400 0000 4200 0c00 0000 0000

0000020 0000 0000 0000 0000 0000 0000 0000 0000

0000040 6100 0000 0000 0000 0000 004e 0000 0000

0000060 0b00 0000 0000 0000 0000 0000 0000 0000

0000100 0d00 2020 2020 2020 2020 2020 2034 2020

0000120 2020 2020 2020 2020 2033 2020 2020 2020

0000140 2020 2020 2032 2020 2020 2020 2020 2020

0000160 2031 1a00

MariaDB [test]> delete from t1 where a=1;

$ od --endian=big -x /tmp/build-mariadb-server-10.4-datadir/test/t1.dbf

0000000 037b 070b 0400 0000 4200 0c00 0000 0000

0000020 0000 0000 0000 0000 0000 0000 0000 0000

0000040 6100 0000 0000 0000 0000 004e 0000 0000

0000060 0b00 0000 0000 0000 0000 0000 0000 0000

0000100 0d00 2020 2020 2020 2020 2020 2034 2020

0000120 2020 2020 2020 2020 2033 2020 2020 2020

0000140 2020 2020 2032 2a20 2020 2020 2020 2020

0000160 2031 1a00

offset 0146 is different.

The record isn't deleted, its still there. The Number of records in the header isn't updated.

libreoffice thinks the file is now corrupted (though does a decent recovery job).

relates to

MDEV-31625 plugin ha_connect, file_type=DBF insert fails

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.