I had the same problem when activating sql-mode="ansi"

However since the patch attached is a quite cryptic on the ' " ` escapes, I wrote a cleaner version of it.
Should work the same way both with and without "ansi-quotes".

--- debian-start.inc.sh.orig    2009-01-06 14:51:44.000000000 +0000
+++ debian-start.inc.sh 2009-01-06 14:49:33.000000000 +0000
@@ -18,10 +18,10 @@
  tempfile=`tempfile`
  # We have to use xargs in this case, because a for loop barfs on the
  # spaces in the thing to be looped over.
-  LC_ALL=C $MYSQL --skip-column-names --batch -e  '
-      select concat("select count(*) into @discard from `",
-                    TABLE_SCHEMA, "`.`", TABLE_NAME, "`")
-      from information_schema.TABLES where ENGINE="MyISAM"' | \
+  LC_ALL=C $MYSQL --skip-column-names --batch -e  "
+      select concat('select count(*) into @discard from ',
+                    TABLE_SCHEMA, '.', TABLE_NAME, '')
+      from information_schema.TABLES where ENGINE='MyISAM'" | \
    xargs -i $MYSQL --skip-column-names --silent --batch \
                    --force -e "{}" >$tempfile
  if [ -s $tempfile ]; then




--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to