https://bugs.documentfoundation.org/show_bug.cgi?id=145723
Bug ID: 145723
Summary: Query in SQL view says there's an error in SQL syntax,
but really, it's just an empty result set
Product: LibreOffice
Version: 7.0.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:
When a query is set up with calculations on a timestamp field, and the result
set should be empty, Base complains of an SQL syntax error at the calculation.
This errant error message is debilitatingly confusing, especially since there's
no good way to do such calculations in Design View (which would a very nice
improvement to base).
Steps to Reproduce:
1.Set up an .odb file with a mySQL backend
2.Set up a query that uses calculations on a timestamp field (such as
DATE_ADD()).
3.Arrange for it to produce an empty result set based on a Where clause on a
boolean.
4.From the Edit SQL window for the query, click the "Run Query" button.
5.Observe the error message
6.Remove the Where clause that makes the result set empty.
7.Re-click the run button.
8.Observe the lack of error message.
Actual Results:
Confusing errant error message comes up when it shouldn't.
Expected Results:
Empty result set should be shown without error message.
Reproducible: Always
User Profile Reset: No
Additional Info:
In my case, the query SQL spans joined tables.
--
You are receiving this mail because:
You are the assignee for the bug.
