[Libreoffice-bugs] [Bug 136475] New: Libre Base SQL Syntax Unrecognized For FireBird DateAdd() Function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136475

            Bug ID: 136475
           Summary: Libre Base SQL Syntax Unrecognized For FireBird
                    DateAdd() Function
           Product: LibreOffice
           Version: 3.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: doug at defeditsoftware.com

Description:
Using LibreOffice Base, JDBC driver connected to a remote FireBird SQL
database, a SQL query using firebird's DateAdd() function returns an unexpected
end of statement error.

An example query is:
Select * From Entitlements
Where EXPIRATIONDATE <= DateAdd(90 day to current_date)

I was attempting to use this sql statement in a saved Query, and it tells me
when attempting to run or save the query that the syntax is incorrect. However
the query does execute properly within Firebird / within FlameRobin, a
management tool for it. 

The query is accepted if I remove the Where clause that contains the DateAdd()
function

Steps to Reproduce:
1.Connect Base to an external FireBird database (Or, optionally, use an
embedded database using Firebird)
2. Create a table in the database with a DATE column
3. Attempt to create a query using the firebird DateAdd() function

Actual Results:
SQL Status: HY000
Error code: 1000

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Expected Results:
Query should have executed with appropriate data results


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.3.2 (x64)
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200904/b14fef1d/attachment-0001.htm>