The current splitSql function is very flawed, as it doesn't support basic comments, or more complex procedures and transactions.

as a consequence, if you have a comment followed by a query in your component sql update files, the query will be ignored.

for example, this will be seen as a comment instead of one comment + 1 query

# this is my comment
UPDATE TABLE #__example_table ADD column eg VARCHAR(255);

Steps to reproduce the issue

Create a new sql update file for a component in the installer zip, adding some dummy column, like above

Expected result

the query should run

Actual result

the query just following the comment is ignored

System information (as much as possible)

Additional comments

This is undocumented, and very hard to debug for extensions maintainers, as putting comment happens ;)