https://bugs.documentfoundation.org/show_bug.cgi?id=144694
--- Comment #24 from flywire <[email protected]> --- (In reply to Commit Notification from comment #17) > Ilmari Lauhakangas committed a patch related to this issue. > > tdf#144694 In direct SQL dialog, activate options 'Run SQL command Tools → SQL Brings up the Execute SQL Statement dialog. (I note dialog width cannot be reduced now.) Select: 1. Run SQL command directly 2. Show output of "select" statements Paste *query.sql* test code Execute @Ilmari Lauhakangas Can you include a screenshot showing the output pane? When I Execute the Output pane only contains the text "Command executed", despite selecting Show output of "select" statements. Expected Output pane: Alice ...Bob ......Dave ......Emma ...Cindy ......Fred ......Gail PART 2 This fix seems to have broken Create Query in SQL View but it would run as two queries (Seems a different interface demonstrates the same issue differently). Select and Paste *query.sql* test code Save generates Error - Syntax error in SQL statement Use tool to set Run SQL command directly Run Query generates Error On first run - The data content could not be loaded, The execution of the query does not return a valid result set. Refresh tables and the org table has been created. On second run - The data content could not be loaded, table org already exists (1). Delete everything above WITH RECURSIVE and the query can be saved as query2.sql then Run query and the expected output is generated. Test Environment: Run https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite if required, LibreOfficeDev Base, Connect to existing database: ODBC, Choose a data source, create new database, then as described above. Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: da56d1bd13e0396ca04b58d9e09bc9ad6315a869 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 -- You are receiving this mail because: You are the assignee for the bug.
