[debian-mysql] Bug#1120329: Problem identified & fix confirmed

[Richard C]

The problem here is that xargs will strip single and double quotes from its
inputs, meaning table names with spaces are not correctly dealt with.

I can confirm a preferred fix - use backticks:

I have changed the SELECT line to:
SELECT CONCAT("select count(*) into @discard from `", TABLE_SCHEMA, "`.`",
TABLE_NAME, "`")

And can confirm that works.
xargs does not apparently strip backticks.

There is another potential fix mentioned in the answer below, which is
specify the delimiter to xargs using `-d '\n'` which will also apparently
work.


RE: related answer given here:
https://stackoverflow.com/questions/79812697
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20251111/a2732bde/attachment.htm>