Reposted from the #public-memsql-chat created by Aaron Pfeifer:
Hey folks – I’ve been observing an issue with the memsql cli (on 6.5) where queries will have vastly different performance (40x difference in one case) based on a difference in the spacing within the query. The query is executed multiple times to verify consistent performance.
When I paste the query (split up onto multiple lines), my query will take 4s. When I paste the query as a single line, the query takes 0.1s. The results are identical and can be replicated. Additionally, I’ve verified that the queries are the exact same syntax.
Has anyone seen this before?
The version of
memsql being used is:
/var/lib/memsql-ops/lib/memsql-client Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper```