Hi all, In the Koha SQL Library we talk about "Runtime Variables" which are MySQL "User-defined Variables": https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables Well today I noticed that MySQL might be removing that functionality in the future: "Previous releases of MySQL made it possible to assign a value to a user variable in statements other than SET. This functionality is supported in MySQL 8.0 for backward compatibility but is subject to removal in a future release of MySQL." https://dev.mysql.com/doc/refman/8.0/en/user-variables.html I didn't see any reference to this in the MariaDB KB and I can't recall how far the two databases have diverged at this point but could be worth keeping in mind: https://mariadb.com/kb/en/user-defined-variables/. Of course, as noted in the Koha wiki, it looks like user-defined variables aren't really needed post 18.05 anyway. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595