08: 
 org 
 From: moschlar@debian.org 
  
 Source: libbio-db-seqfeature-perl 
 Version: 1.7.5-1 
 Severity: important 
 Tags: upstream 
 Forwarded: https://github.com/bioperl/bio-db-seqfeature/issues/5 
 X-Debbugs-Cc: andresen@uni-mainz.de 
  
 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 
  
  
 -- System Information: 
 Debian Release: forky/sid 
   APT prefers testing 
   APT policy: (990, 'testing'), (500, 'unstable') 
 Architecture: amd64 (x86_64) 
  
 Kernel: Linux 6.16.12+deb14+1-amd64 (SMP w/8 CPU threads; PREEMPT) 
 Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE 
 not set 
 Shell: /bin/sh linked to /usr/bin/dash 
 Init: systemd (via /run/systemd/system) 
 LSM: AppArmor: enabled 
  
 --- SoupGate-Win32 v1.05 
  * Origin: you cannot sedate... all the things you hate (1:229/2)