SingleStore (MemSQL) Connector: Use CONCAT instead of Pipe operator (||) | Product Feedback Forum

milanradeta · 2025-07-24T11:04:48.552000Z

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 worksflag is OFF (default): pipe operator is treated as OR and the Sisense-generated query throws an errorIn order to avoid the ambiguity, I suggest that SingleStore (MemSQL) Connector uses CONCAT instead of pipe operator by default.

MoreDiscussions

SingleStore (MemSQL) Connector: Use CONCAT instead of Pipe operator (||) | Product Feedback Forum | Sisense Community