The ALL syntax in the EXCEPT ALL, MINUS ALL, and INTERSECT ALL operators was unintentionally added in an earlier release and will be officially removed in MemSQL 6.5 to reduce confusion.
The OPTIMIZE TABLE command currently allows passing in a list containing more than one table name. This behavior is not supported and can result in a possible deadlock. You must only pass in one table name for each call to OPTIMIZE TABLE. Specifying two or more table names will result in an error in MemSQL 6.5.