search

readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.25k stars 117 forks source link

SET String type #30

Open nemke82 opened 1 year ago

nemke82 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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

Marcuzz commented 4 months ago

This also makes it impossible to use Readyset in Drupal.

JihadMotii-REISys commented 2 months ago

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