Using SingleStore for a Live Model - any issues?

[irismaessen]

Has anyone used SingleStore as a basis for a Live Model?  

We are experimenting with it but are running into some issues with date or date/time fields and I was wondering if anyone else encountered similar issues. 

[irismaessen · Accepted solution]

The issue we were running into turned out to be related to a compatibility mode settings for Singlestore -- newer versions of Singlestore have stricter date/time conversion syntax/behaviour. Setting the compatibility mode in Singlestore to 6.0 made things work.