Currently I think this issues arises maybe because of query cache. We need to invalidate this one.

https://www.loom.com/share/1f7a4deb94834c57a6111816de1d7879?sid=e5c883e9-d8aa-467f-9a82-a05af281a2b1