PGbouncer Extension || Query Rewrite Feature Issues
AustinPark00 opened this issue · 0 comments
My colleague is trying to implement the Query Rewrite feature noted in the README with Amazon Aurora w/PostGres as the database. They made a few valid modifications to the rewrite_query.py code, which I will include within the attachments. With their modifications, they are currently not seeing any rewrites being executed even if the query passed in MATCHES q1, q2, or q3. In the case where it does not match, the function then rewrites the query to the same exact query (ex. If q1, q2, q3, were apple banana orange respectively, if I pass in something w/'apple' no rewrites occurs. If I pass in lettuce, a rewrite would occur and it would be rewritten to lettuce again). A longer video can also describe this issue if I can attach it elsewhere.
Given that the function still executes with no errors, but does not execute the logic determined within the file, we are not sure what steps to take to get this feature functional. We are looking to see if the team responsible for this GitHub to confirm that this features works as advertised, and if so where exactly are we making mistakes?