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: [email protected]
Reporter: [email protected]
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.
