https://bugs.documentfoundation.org/show_bug.cgi?id=157465
Bug ID: 157465 Summary: SQL Explorer J successfully runs SQL query yet LibreOffice Base does not Product: LibreOffice Version: 7.5.6.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: jpkazar...@yahoo.com Description: If I run the following SQL command: select "ID" from "Watches" where "Type_FK" = 39; In SQL Workbench J connected to my Libra Office database files, I get an 11 row result set. If I use Tools -> SQL in LibreOffice Base itself, I get no output. I did not notice the problem until upgrading to 7.6.0.0 Alpha0+. However I uninstalled that version and reinstalled 7.5.6.2 to no avail. Is there a Base clean-up tool that I should use? Since I get different result sets in two different client tools using the HSQLDB, I'm assuming Base has the bug. Steps to Reproduce: 1. Launch Base 2. In Tools-> SQL, check the show output box 3. Run a query linking a foreign key to a primary key Actual Results: None Expected Results: 11 rows Reproducible: Always User Profile Reset: Yes Additional Info: Attaching Zip file of Base application. -- You are receiving this mail because: You are the assignee for the bug.