[Libreoffice-bugs] [Bug 144694] Base Direct SQL Not Running Properly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144694

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de,
                   |                            |serval2412 at yahoo.fr

--- Comment #1 from Julien Nabet <serval2412 at yahoo.fr> ---
I must recognize I don't understand how to reproduce this.

Here what I did:
- create a brand new odb file (HSQL embedded)
- select "Create Query in SQL View..."
- copy paste:
CREATE TABLE org(
  name TEXT PRIMARY KEY,
  boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);
INSERT INTO org VALUES('Bob','Alice');
INSERT INTO org VALUES('Cindy','Alice');
INSERT INTO org VALUES('Dave','Bob');
INSERT INTO org VALUES('Emma','Bob');
INSERT INTO org VALUES('Fred','Cindy');
INSERT INTO org VALUES('Gail','Cindy');

WITH RECURSIVE
  under_alice(name,level) AS (
    VALUES('Alice',0)
    UNION ALL
    SELECT org.name, under_alice.level+1
      FROM org JOIN under_alice ON org.boss=under_alice.name
     ORDER BY 2 DESC
  )
SELECT substr('..........',1,level*3) || name FROM un


- Click "Run SQL Command directly" icon (at right)
- Click "Save" icon + close
- Double click query to execute it
=> Error message:
SQL Status: 00000
Error code: -155

Statement does not generate a result set
/home/julien/lo/libreoffice/connectivity/source/drivers/jdbc/Object.cxx:174

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210924/02aaed4e/attachment.htm>