Dear Maintainers,

when running the script bp_seqfeature_load on Bookworm or Trixie, we get

DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near 'offset   int(10) unsigned not null,
  sequence longblob,
  primary key(id,off...' at line 3 at
/usr/share/perl5/Bio/DB/SeqFeature/Store/DBI/MariaDB.pm line 475.
-------------------- EXCEPTION --------------------
MSG: You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near 'offset   int(10)
unsigned not null,
  sequence longblob,
  primary key(id,off...' at line 3
STACK Bio::DB::SeqFeature::Store::DBI::MariaDB::_create_table
/usr/share/perl5/Bio/DB/SeqFeature/Store/DBI/MariaDB.pm:475
STACK Bio::DB::SeqFeature::Store::DBI::MariaDB::_init_database
/usr/share/perl5/Bio/DB/SeqFeature/Store/DBI/MariaDB.pm:448
STACK Bio::DB::SeqFeature::Store::init_database
/usr/share/perl5/Bio/DB/SeqFeature/Store.pm:426
STACK Bio::DB::SeqFeature::Store::DBI::MariaDB::init
/usr/share/perl5/Bio/DB/SeqFeature/Store/DBI/MariaDB.pm:229
STACK Bio::DB::SeqFeature::Store::new
/usr/share/perl5/Bio/DB/SeqFeature/Store.pm:388
STACK toplevel /usr/bin/bp_seqfeature_load:237
-------------------------------------------

The reason for this is that offset is a reserved keyword since MariaDB 10.6
(cf. https://mariadb.com/docs/server/reference/sql-structure/sql-language-
structure/reserved-words).

Regards,
Moritz Schlarb

Hi all,

my patch has been accepted by upstream and included in the repo:
https://salsa.debian.org/med-team/libbio-db-seqfeature-perl/-/commit/6bc2b7f50c1773a7af7bcec263b667f68bcbb877

It would be nice to have it going to p-u, too.

Regards,
Moritz