MySQL: Every derived table must have its own alias

[yli1_aldo]

We are currently migrating our setup from oracle to mysql. Everything is working fine with oracle. Initializing hybris with mysql is fine as well.

Problem comes after when system is running specific query, mysql throws an error Every derived table must have its own alias

It seems that aliases for derivated tables are not added. Am I missing a config ? is it possible to tell hybris to add those?

Thank you

[arvind-kumar_avinash]

Is this happening with out-of-the-box code/query or some custom code/query? If it is happening with out-of-the-box code/query, I will suggest you raise a support ticket for a quicker resolution. If it is happening with custom code/query, you need to adjust your code/query to provide with an alias as MySQL does expect an alias for a derived table. You can check https://stackoverflow.com/questions/1888779/what-is-the-error-every-derived-table-must-have-its-own-... for an example.