search

tableau / connector-plugin-sdk

SDK for Developing Tableau Connector Plugins
https://tableau.github.io/connector-plugin-sdk/
MIT License
108 stars 108 forks source link

[Question] Custom String escaping functionality #1221

Closed BentsiLeviav closed 6 months ago

BentsiLeviav commented 7 months ago

Hi Tableau team,

I'm trying to run the TDVT tests suite and facing some issues related to string escaping. Our connector is based on the PostgreSQL90Dialect dialect.

When running the string.contains.regex test, the generated SQL is escaping the string "A\" with an escape string constant of E (as it works for Postgres). Is there a way to overwrite the escape functionality in my dialect?

yurifal commented 7 months ago

Hi @BentsiLeviav,

It was my decision to set the PostgreSQL90Dialect as the base one, mainly for the ISO-8601 Calendar to be available (in Tableau Desktop / Web Edit). I guess you may write any other dialect in the TDD as a base, for example MySQL8Dialect.

Yours, Yuri

lukewrites commented 7 months ago

Internal tracking: W-15205945

rosswbrown commented 6 months ago

The E prefix comes from using <format-string-literal value='Extended' />. I would recommend trying to use <format-string-literal value='Standard' /> as a starting point.

Additional documentation and sample