Account view's lateral join not supported in MariaDB

[gpordeus]

problem

I got an SQL exception due to lateral join (added in #12631), which is not supported in MariaDB.

2026-03-27 19:11:21,118 ERROR [c.c.u.d.ScriptRunner] (main:[]) (logid:) java.sql.SQLSyntaxErrorException: 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 '(         select             coalesce(sum(`user_statistics`.`net_bytes_receiv...' at line 1
2026-03-27 19:11:21,120 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[]) (logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException: 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 '(         select             coalesce(sum(`user_statistics`.`net_bytes_receiv...' at line 1

Will MariaDB support be dropped or was it just an oversight?

versions

• ACS 4.23-SNAPSHOT, commit 1bff543
• MariaDB 10.11.14
• Ubuntu 24.04.4

The steps to reproduce the bug

Fresh install of ACS, returns error during account_view creation.

What to do about it?

No response

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[gpordeus]

cc @sureshanaparti, I forgot to do it in the description.