https://bugs.documentfoundation.org/show_bug.cgi?id=144694
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected] --- Comment #1 from Julien Nabet <[email protected]> --- 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.
