You are viewing an old version of this question. View the current version here.

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

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");
 }
 
 ####

Comments

Comments loading...