Create integ tests for PR https://github.com/opensearch-project/sql/pull/1753 

Ask:
Create integ tests for the issue fixed in PR: https://github.com/opensearch-project/sql/pull/1753
Since it requires security plugin to reproduce the issue, we have decided to postpone the creation of integ tests.

Tagging this in https://github.com/opensearch-project/sql/issues/1713 along with other integ test issues with security pluing.