The repository README indicates the developer to add the singlestore connection with the collation of utf8mb4_unicode_ci , while the new Singlestore 9 uses utf8mb4_bin.
https://docs.singlestore.com/db/v9.0/release-notes/singlestore-memsql/9-0-release-notes/#collation-change
In my case, I get multiple mismatched datatypes warnings due to the table being unicode_ci and the query being executed with the bin collation.
https://docs.singlestore.com/cloud/reference/sql-reference/data-types/comparing-mismatched-datatypes/
I believe the README should be updated to the bin collation to avoid this kind of issue in new installations.