We are using SAP Data services to replicate data to SingleStore database. Actually, most of our test is working fine.
But we have found one issue when SAP Data services is trying to make a Delta Load.
When table key is a String the application will use the following syntax
SELECT 1 FROM <TABLE> WHERE <COLUMN> = N'Literal'
Here our problem is that SAP Data services does not support natively SingleStore but support MySQL 5.x and MySQL 8.x
Do you have an option that can be specified in order to support such syntax?