Unit Test Failure: AssertionError in `test_execute.py` for error messages

[setoru]

Description:
When executing the test case tests/test_execute.py::TestExecuteScript::test_execute_exceptions_1, an AssertionError is thrown. The error occurs because the expected error message "relation "dne" does not exist" does not match the actual error message "Relation "dne" does not exist on dn_6001_6002_6003.".

Logs:

Traceback (most recent call last):
  File "/usr/lib64/python3.9/unittest/case.py", line 59, in testPartExecutor
    yield
  File "/usr/lib64/python3.9/unittest/case.py", line 592, in run
    self._callTestMethod(testMethod)
  File "/usr/lib64/python3.9/unittest/case.py", line 550, in _callTestMethod
    method()
  File "/home/gaussdbuser/gaussdb-python-async/.venv/lib64/python3.9/site-packages/async_gaussdb/_testbase/__init__.py", line 92, in wrapper
    self.loop.run_until_complete(coro)
  File "/usr/lib64/python3.9/asyncio/base_events.py", line 642, in run_until_complete
    return future.result()
  File "/home/gaussdbuser/gaussdb-python-async/tests/test_execute.py", line 68, in test_execute_exceptions_1
    await execute('select * from __dne__')
  File "/usr/lib64/python3.9/unittest/case.py", line 239, in __exit__
    self._raiseFailure("{} does not match {}".format(
  File "/usr/lib64/python3.9/unittest/case.py", line 163, in _raiseFailure
    raise self.test_case.failureException(msg)
AssertionError: "relation "__dne__" does not exist" does not match "Relation "__dne__" does not exist on dn_6001_6002_6003."

How to reproduce it:

pytest --durations=0 -s -v tests/test_execute.py

Expected Behavior
Test assertion passes, meaning the expected and actual error messages match.

Actual Behavior
The test fails with an AssertionError due to a mismatch between the expected and actual "relation does not exist" error messages.

Environment

• OS: Huawei Cloud EulerOS 2.0
• Python Version: 3.9
• Database: GaussDB Kernel 505.2.1.SPC0800 build 3e43b3bc

[zhanghaitao3]

Title: Fix Error Message Case Sensitivity in Test Assertions

Description:
Fixed test failure due to case sensitivity in error message matching:

AssertionError: "relation "dne" does not exist" does not match "Relation "dne" does not exist on dn_6001_6002_6003."


Root Cause:
The test was failing due to differences in error message capitalization and additional database-specific context in the error message.

Fix:
Updated the test to use case-insensitive matching for error messages, making the tests more robust across different database implementations and versions.