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.
If your ORM/App is configured to send a SET command, we can allow it on readyset via ALLOW_UNSUPPORTED_SET=true however it will log two warnings in the logs
2024-08-16T16:17:29.244127Z WARN connection{addr=10.0.0.170:60860}:query: readyset_mysql::query_handler: unknown sql modes in set e=SqlMode parse failed: TRADITIONAL
2024-08-16T16:17:29.244128Z WARN connection{addr=10.0.0.170:60860}:query: readyset_adapter::backend: received unsupported SET statement set=SET @@LOCAL.sql_mode = 'TRADITIONAL'
We should get rid of those as they are flooding the log.
Description
If your ORM/App is configured to send a SET command, we can allow it on readyset via
ALLOW_UNSUPPORTED_SET=truehowever it will log two warnings in the logsWe should get rid of those as they are flooding the log.
Change in user-visible behavior
Requires documentation change