gpordeus opened a new issue, #12907:
URL: https://github.com/apache/cloudstack/issues/12907
### 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 1bff543e
- 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_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
