Mysql[i] - list_fields - get all Table with the name *tl_news

[stefanheimes]

Hi,

we have a little problem with the Database updater. The DB update wants to delete some fields. But the fields didn't exist in the table. After some debuging i find some rows with a SQL statment to fetch all fields from the INFORMATION_SCHEMA. But in this SQL we have a
``TABLE_NAME LIKE '%$strTable' and there was the error. The '%' finds the tl_news and a tmp_tl_news.

So i ask me why we have a '%'. We only want the fields from one table and not from all that have a 'tl_news' at the end of the name or is there a special case?

See:
https://github.com/contao/core/blob/master/system/modules/core/library/Contao/Database/Mysql.php#L142
https://github.com/contao/core/blob/master/system/modules/core/library/Contao/Database/Mysqli.php#L125

[leofeyer]

So i ask me why we have a '%'.

Me too, honestly. @contao/developers Thoughts?

[ausi]

Related commit: 3980d2b

I don't see a reason for the %

[Toflar]

Neither do I.

[aschempp]

I think that's a leftover from sprintf and should be removed.

[leofeyer]

Fixed in c8a8e53.