SQL plugin offset not working

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

Describe the issue:
I use opensearch and I have two indices transaction and users
when I creating inner join the offset not working but limit works


Relevant Logs or Screenshots:

Because of the nature of OpenSearch, support for JOINs and limits/pagination is still pending.

see: Limitations - OpenSearch documentation