test-table-elimination fails
why does test-table-elimination generate a broken SQL command and fail? is the test wrong, or is the SQL parser broken?
$ ./test-table-elimination --socket=/tmp/rfp.sock --lock Testing server 'MySQL 5.5.23 MariaDB' at 2012-04-21 16:47:25
Testing table elimination feature The test table has 100000 rows.
Creating tables
Error executing 'LOCK TABLES elim_facts, elim_attr1, elim_attr2 WRITE': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' elim_attr1, elim_attr2 WRITE' at line 1
Answer Answered by Elena Stepanova in this comment.
Hi,
Thank you for reporting this.
This is a test problem; it's now been filed on your behalf as https://bugs.launchpad.net/maria/+bug/986731, you can follow the progress at launchpad. If you need a workaround, please try to apply the following change:
@@ -92,7 +92,7 @@
if ($opt_lock_tables)
{
- do_query($dbh,"LOCK TABLES elim_facts, elim_attr1, elim_attr2 WRITE");
+ do_query($dbh,"LOCK TABLES elim_current_facts WRITE, elim_facts WRITE, elim_attr1 WRITE, elim_attr2 WRITE");
}
if ($opt_fast && defined($server->{vacuum}))
@@ -204,7 +204,7 @@
if ($opt_lock_tables)
{
- do_query($dbh,"LOCK TABLES elim_facts, elim_attr1, elim_attr2 WRITE");
+ do_query($dbh,"LOCK TABLES elim_current_facts WRITE, elim_facts WRITE, elim_attr1 WRITE, elim_attr2 WRITE");
}
####
