Bug 156238

Description:
I write python macro embed in Calc which: create database, insert data and select data.
An Libreoffice error window is displayed when there is no data in the database (SELECT statement). Trying to catch an exception doesn't help.

Steps to Reproduce:
1. Install APSO
2. Open the attached file
3. Run "organise python script", select embedded modul "test", run "Python shell"
4. In shell type test1() + enter

Actual Results:
>>> test1()
/home/sznik/python_projekty/LibreOffice/test.odb
Connection to Base successful
query ='CREATE TABLE "tickers" ("id" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, "ticker" VARCHAR(50) NOT NULL, "currency" VARCHAR(10) NOT NULL)'
Query executed successfully
query ='INSERT INTO "tickers" ("ticker", "currency") VALUES (\'a\', \'aa\')'
Query executed successfully
query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'a\' '
Query executed successfully
execute_read_query(connection, query) =((0,),)

query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'b\' '
Traceback (most recent call last):
  File "/usr/lib/python3.10/code.py", line 90, in runcode
    exec(code, self.locals)
  File "<console>", line 1, in <module>
  File "/home/sznik/.config/libreoffice/4/user/Scripts/python/test.py", line 61, in test1
    print(f'{execute_read_query(connection, query) =}\n')
  File "/home/sznik/.config/libreoffice/4/user/Scripts/python/test.py", line 33, in execute_read_query
    result = connection.GetRows(query, directsql=True)
  File "/usr/lib/libreoffice/program/scriptforge.py", line 1603, in GetRows
    return self.ExecMethod(self.vbMethod + self.flgArrayRet, 'GetRows', sqlcommand, directsql, header, maxrows)
  File "/usr/lib/libreoffice/program/scriptforge.py", line 546, in ExecMethod
    return self.EXEC(self.objectreference, flags, methodname, *args)
  File "/usr/lib/libreoffice/program/scriptforge.py", line 306, in InvokeBasicService
    raise RuntimeError("The execution of the method '" + method + "' failed. Execution stops.")
RuntimeError: The execution of the method 'GetRows' failed. Execution stops.
>>> 

Expected Results:
>>> test1()
/home/sznik/python_projekty/LibreOffice/test.odb
Connection to Base successful
query ='CREATE TABLE "tickers" ("id" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, "ticker" VARCHAR(50) NOT NULL, "currency" VARCHAR(10) NOT NULL)'
Query executed successfully
query ='INSERT INTO "tickers" ("ticker", "currency") VALUES (\'a\', \'aa\')'
Query executed successfully
query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'a\' '
Query executed successfully
execute_read_query(connection, query) =((0,),)

query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'b\' '
Query executed successfully
execute_read_query(connection, query) =()
>>> 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: pl-PL (pl_PL.UTF-8); UI: pl-PL
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded