sql-bench/test-table-elimination fails with SQL syntax error on OPTIMIZE if executed with --fast
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Low
|
Sergey Petrunia |
Bug Description
Got error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0x1a19340)' at line 1 when executing 'OPTIMIZE TABLE'
Offending query as it's written into the general log:
OPTIMIZE TABLE ARRAY(0x1a19340)
If sql-bench/
@@ -199,12 +199,12 @@
if ($opt_fast && defined(
{
- $server-
+ $server-
}
Reproducible on maria-5.1
bzr version-info
revision-id: <email address hidden>
date: 2012-04-06 13:31:33 +0500
build-date: 2012-04-22 05:08:00 +0400
revno: 3146
Same code in other versions.
To reproduce,
- start MariaDB server;
- run test-table-
(if it fails with a syntax error in LOCK TABLES, fix bug #986731 first).