https://bugs.documentfoundation.org/show_bug.cgi?id=144694
flywire <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|FIXED |--- Status|RESOLVED |REOPENED --- Comment #21 from flywire <[email protected]> --- (In reply to Buovjaga from comment #20) > (In reply to flywire from comment #19) > > > *query.sql* > > > > Generating Syntax error in SQL statement > > > > Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community > > Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48 > > CPU threads: 6; OS: Windows 11 X86_64 (build 22631); UI render: Skia/Vulkan; > > VCL: win > > Locale: en-AU (en_AU); UI: en-GB > > Calc: CL threaded > > Maybe that's a new regression or something? In any case, best to create a > new report for it as this has already so many comments and commits. Just be clear, This *IS* the bug that does not work: (In reply to flywire from comment #0) > Direct SQL should process code the same as running it directly for both > Tools → SQL and Query → Direct SQL. > > The only real difference between these commands should be the second one > holds the output in a view (query grid). > > (In reply to Robert Großkopf from > https://bugs.documentfoundation.org/show_bug.cgi?id=143656#c18) > > (In reply to flywire from comment #17) > > Your findings are consistent with mine: > > > Empty SQLite database: > > 1. Output is never generated by Tools → SQL > > 2. Run code through Query → Direct SQL and table is generated first time > > [but returns error "The data content could not be loaded. The execution of > > the query doesn't return a valid result set."], run WITH RECURSIVE... code > > again and output is generated. > > ===== > > *query.sql* > > 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 under_alice; > > *output* > > Alice > ...Bob > ......Dave > ......Emma > ...Cindy > ......Fred > ......Gail > > > Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: e9b674a768fcf534335f172664aaf13dc2c79023 > CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: > win > Locale: en-AU (en_AU); UI: en-GB > Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
