Change Details

If you have a table with a list storage type `List of (,) Wikitext String` let's say, and you alias the table, the auto-inserted ORDER BY will not use the table alias and will fail. ``` {{#cargo_query: tables=Contacts=c |fields=_pageName,Role |where=c.`Username` = 'Ofbeaton' |format=table }} ``` this fails with a `Unknown column 'cago__Contacts.Role__full' in 'order clause'` error. If you remove the table alias, it works. This is on MySQL 5.7

If you have a table with a list storage type `List of (,) Wikitext String` let's say, and you alias the table, the auto-inserted ORDER BY will not use the table alias and will fail. ``` {{#cargo_query: tables=Contacts=c |fields=_pageName,Role |where=c.`Username` = 'Ofbeaton' |format=table }} ``` this fails with a `Unknown column 'cargo__Contacts.Role__full' in 'order clause'` error. If you remove the table alias, it works. This is on MySQL 5.7

If you have a table with a list storage type `List of (,) Wikitext String` let's say, and you alias the table, the auto-inserted ORDER BY will not use the table alias and will fail. ``` {{#cargo_query: tables=Contacts=c |fields=_pageName,Role |where=c.`Username` = 'Ofbeaton' |format=table }} ``` this fails with a `Unknown column 'cargo__Contacts.Role__full' in 'order clause'` error. If you remove the table alias, it works. This is on MySQL 5.7