The queries Sisense generates in some cases uses the pipe operator (||) to concatenate the strings.
However, SingleStore has 2 different modes of treating the pipe operator, depending on @@sql_mode engine variable and PIPES_AS_CONCAT flag:
- flag is ON: pipe operator is treated as CONCAT and the Sisense-generated query works
- flag is OFF (default): pipe operator is treated as OR and the Sisense-generated query throws an error
In order to avoid the ambiguity, I suggest that SingleStore (MemSQL) Connector uses CONCAT instead of pipe operator by default.