When issuing a query with a window function, for example:
SELECT AVG(a) over (PARTITION BY b ORDER BY b ROWS 15 PRECEDING) FROM t;
a user may receive the following error:
”Feature 'Complex frame in window clause' is not supported by MemSQL”.
As of version 5.0.8, MemSQL only supports the default frame clause and simple frames which start from the beginning of the partition and end at the current row (i.e.
ROWS UNBOUNDED PRECEDING). Complex frames specifying a number of rows
FOLLOWING are currently not supported.