MySQL in Malloy (from Fernando's Repo)

[lloydtabb]

To test, set environment variables

export MYSQL_HOST=127.0.0.1 export MYSQL_PORT=3306 export MYSQL_USER=root export MYSQL_DATABASE=malloytest

start the docker by

cd test/mysql ./mysql_start.sh

Known Problems/ missing

• [ ] Symmetric aggregtes are losing precision
• [ ] Dates/timestamps aren't implemented (need to make sense of the JSON results)
• [ ] unnesting second stages
• [ ] There is no native boolean type. Need to either stub some tests make them work where it makes sense
• [ ] MySQL connection pooling