The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

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");
 }
 
 ####
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.