SET String type

[nemke82]

Is your feature request related to a problem? Please describe. A lot of popular CMS/Ecommerce applications are utilizing SET sql_mode="" in SELECT queries

Describe the solution you'd like Add SET String type to readyset application

Describe alternatives you've considered So far, ProxySQL can rewrite each query, but that is not a permanent solution.

Additional context Could expand application popularity and use cases

[jbensal]

Hi @nemke82, thanks for reporting this! Which CMS/Ecommerce application are you using?

I'll file an internal ticket right now for this and can follow up when we get to it.

[nemke82]

Hello @jbensal. Thanks for the quick response. Yeah, you can test in Magento 2, and due to this line, it is not functional if I parse SELECT queries through Readyset since they add SET in each query (sad but true).

https://github.com/magento/magento2/blob/2.4-develop/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php#L432

[nemke82]

I just wanted to follow up on this @jbensal. Any news or plans?

[Marcuzz]

This also makes it impossible to use Readyset in Drupal.

[JihadMotii-REISys]

We are also running into the same issue with Springboot ORM (Hibernate).