milanradeta's avatar
milanradeta
Data Storage
07-24-2025
Status:
New Idea

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

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.

No CommentsBe the first to comment