MySQL Features Unsupported in MemSQL

MemSQL intentionally does not support all of the features of MySQL. In some cases, MemSQL can safely ignore unsupported features in a SQL statement and continue executing only the supported features.

Unsupported Feature List

Behavior Differences

MemSQL differs from MySQL query behavior in a few ways, mostly in cases where MySQL behavior is officially undefined, and the observed behavior depends on the details of implementation.

memsql> SELECT * FROM messages;
+----+-------+
| id | msg   |
+----+-------+
|  2 | ohai! |
|  3 | kthx  |
|  1 | yo    |
+----+-------+
3 rows in set (0.00 sec)

memsql> SELECT * FROM messages ORDER BY id;
+----+-------+
| id | msg   |
+----+-------+
|  1 | yo    |
|  2 | ohai! |
|  3 | kthx  |
+----+-------+
3 rows in set (0.00 sec)
Was this article useful?